At work, we needed to migrate from MySQL to SQLite. All of this thanks to this cheatsheet we got the migration an easy task. But it didn’t explain many things, just the major part in a step by step process.
Tools :
SQLite Database Browser
MySQL with phpMyAdmin
Text Editor such as TextEdit (we used Fraise)
You can actually follow the step there and just don’t read here but you can also follow this simple steps.
In phpMyAdmin page, go to Export tab and select the tables you want to convert.
Make sure to select the SQL on the radio buttons.
Uncheck all checkboxes besides the Export group but leave the checkboxes besides Structure and Data.
Pick ANSI on SQL compatibility mode and check the save as file then click the Go button. It’s best to put the compression to none. But if you like, you can pick zipped or gzipped (just make sure to extract the file after download).
Open the file with a text editor such as TextEdit or Fraise. Find the CREATE TABLE line inside the text. You have to edit them all if you have more than one.
Edit all the CREATE TABLE codes …