mysql into sqlite
I am using mysql now and want to convert to sqlite. Can I just answer_dump_data it and then import it?
Are there any important things to note?
mysql into sqlite
I am using mysql now and want to convert to sqlite. Can I just answer_dump_data it and then import it?
Are there any important things to note?
Theoretically, the sql used by mysql and sqlite should be similar, so you can try to export the sql directly to give it a try. If an error occurs, then modify the SQL according to the error message.
The important thing is to backup your data.