seafile icon indicating copy to clipboard operation
seafile copied to clipboard

sqlite2mysql.sh creates corrupt sql for seahub

Open britiger opened this issue 3 years ago • 0 comments

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.

britiger avatar Oct 27 '21 19:10 britiger