seafile
seafile copied to clipboard
sqlite2mysql.sh creates corrupt sql for seahub
Using the current sqlite2mysql.sh
and sqlite2mysql.py
creates corrupt sql file for seahub. The sql files for ccnet and seafile databases are syntactical correct and can applied to new database.
Output of sqlite3 /opt/seafile/seahub.db .dump | head -n 3
:
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE IF NOT EXISTS "django_content_type" (
Output of cat seahub-db.sql |head -n 2
DROP TABLE IF EXISTS `IF`;
CREATE TABLE IF NOT EXISTS `IF` NOT EXISTS `django_content_type` ( ...
May the problem seams to be the double-quote of the table names of the django tables which I can't see in output of dump from ccnet and seafile sqlite databases.