From sqlite to mysql without reseting accs

[Rab]

Is there any way possible to change from sqlite to mysql without reseting accounts? Please, answer in the fully way as possible. I'll give you rep+ if it works.

 

[Kavvson]

SQLite ----> MySql

1. Download sqlite3.exe on SQLite Home Page
2. Export the SQLite database with sqlite3.exe and command parameter ".dump" (Nate, ".export" doesn't exist!), an example :
sqlite3 mySQLiteDataBase .dump .quit >> myDumpSQLite
3. Adapt the dump to get it compatible for MySQL
- Replace " (double-quotes) with ` (grave accent)
- Remove "BEGIN TRANSACTION;" "COMMIT;", and lines related to "sqlite_sequence"
- Replace "autoincrement" with "auto_increment"
4. The dump is ready to get imported in a MySQL server

Might work

 

[Rab]

I'll try that. By the way, if there is something you can explain more detailed (any of the steps) it would be of great help since i believe i wasnt borned for programming parts.

 

[Kavvson]

Uhm im sure you can google the topic and you will see tons for solutions..

Converting SQlite to MYSQL