MyBB Community Forums

I'm trying to convert from SQLite on 1.8.7 to MySQL on 1.8.15 using Merge.
I assume this is possible!


Result is:


MyBB has experienced an internal SQL error and cannot continue.
SQL Error:0 - QueryQLSTATE[HY000]: General error: 1 near "KEY": syntax error
Please contact the MyBB Group for technical support.

I am not sure Merge tool would be the best option for this, try to upgrade your forum. That should work fine.

I don't know if it could work, but

Admin CP admin/index.php?module=tools-backupdb&action=backup lets you create backups.

In a fresh MySQL install, create a "structure only" backup.

In your SQLite forum, create a "data only" backup.

(MyBB version should be identical for both.)

In a new MySQL database, restore structure, then restore data. With any luck, that should feed SQLite data into the MySQL structure.

Most syntactic changes are in the structure part of the backup.