Migrating from sqlite to mysql fails (official docs/scripts broken yet again)

I followed the current official docs for migrating my 7.0.5 CE from sqlite to Mysql: https://download.seafile.com/published/seafile-manual/deploy/migrate_from_sqlite_to_mysql.md

It seems the scripts/documentation are still broken … migrating sqlite to mysql has been a problem since 2015 if I recall correctly (there are several posts around these forums about this, yet it still isn’t working).

Is there an actually working solution somewhere?

# ./sqlite2mysql.sh
sqlite3 /seafile/server/ccnet/PeerMgr/usermgr.db .dump | python sqlite2mysql.py > ccnet-db.sql
  File "sqlite2mysql.py", line 82
    print(line, end=' ')
                   ^
SyntaxError: invalid syntax
sqlite3 /seafile/server/ccnet/GroupMgr/groupmgr.db .dump | python sqlite2mysql.py >> ccnet-db.sql
  File "sqlite2mysql.py", line 82
    print(line, end=' ')
                   ^
SyntaxError: invalid syntax
sqlite3 /seafile/server/seafile-data/seafile.db .dump | python sqlite2mysql.py > seafile-db.sql
  File "sqlite2mysql.py", line 82
    print(line, end=' ')
                   ^
SyntaxError: invalid syntax
sqlite3 /seafile/server/seahub.db .dump | tr -d '
' | sed 's/;/;
/g' | python sqlite2mysql.py > seahub-db.sql
  File "sqlite2mysql.py", line 82
    print(line, end=' ')
                   ^
SyntaxError: invalid syntax
1 Like

I think, the version in the doc is python 3 only (I do not see any from future import lines ),
while version 7.0.5 should actually uses a python2 compatible script

but as I am not an expert at all, the Devs need to make a statement on this,
but wait, its already 10 days without an answer