Converting SQLite Database to MySQL

[conceptr980]

When trying to convert sqlite to mysql, i get the following error:

"The mysql script is from a different version. SQLite Version: 172 MySQL Version: 176"

 

Any idea how to solve it ?

Thx

[Dennis]

Your SQLite database is from version 2.0.172.0 of TCAdmin. You're currently trying to convert the SQLite database on version 2.0.176.0.
It seems like you've previously had an installation of TCAdmin where you saved the SQLite database. This database has now been imported into a new TCAdmin installation running a newer version of TCAdmin - and that's why you get the error.

You'll need to install version 2.0.172.0 of TCAdmin, convert the SQLite database to MySQL. Your SQLite database is for an old version of TCAdmin.

[conceptr980]

thank you for your reply.

- If i revert back to 2.0.172.0 then convert to mysql then back to latest version no issues will pop up ??

- once database is mysql instead of sqlite, it will use the latest tcadmin tables and standards. if not how to update to latest sql tables??

 

Thx

 

Update:

Revert back to 2.0.172.0 --> Convert SQLite to MYSQL --> Update tcadmin back to 2.0.177.0 = All Good with no issues

 

Thanks for the Help

Edited March 18, 2022 by conceptr980