How to convert Mysql Database to SQLite database?
I have found a simple way to convert the Mysql Database into SQLite database. Following are the steps:
- Open PhpMyadmin on your browser. (eg. http://localhost:8888/phpmyadmin)
- Select database and click on Export.
- Make sure SQL is selected as format and click go.
- Make a copy of the mysqlcode and store in a file db.txt.
- Download DB Browser for SQLite from sqlitebrowser.org .
- Create new Database and create table.
- Navigate to Execute SQL tab and copy the insert statements and execute the sql or import the insert statements from file db.txt and execute the code
- Finally, the SQLite database is ready.
If you have a simplier method to do this please do write in our comments section. Thanks.
Recent Comments