I want to transfer the model of my database and all containing information from MySQL to SQLite. For this purpose I used the mysqldump tool and generated a sql script file.
Then I tried to import this file into my SQLite database and ran in many errors. F.e. there are commands like "KEY", "COMMENT", "LOCK TABLES", "UNLOCK TABLES" or "ON UPDATE" which seems not be supported.
is there any way to generate SQLite conform scripts or is there a possibiility to automatically convert the script later?
Asked
Active
Viewed 209 times
0
altralaser
- 2,035
- 5
- 36
- 55
-
https://stackoverflow.com/questions/5164033/export-a-mysql-database-to-sqlite-database – Honeyboy Wilson May 22 '18 at 11:48
-
just google for "mysql to sqlite converter" - like this one - https://gist.github.com/esperlu/943776 – JosMac May 22 '18 at 12:05