How to convert Mysql Database to SQLite database?
- Wednesday, May 23, 2018, 17:05
- How-to
- Add a comment
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.
About the Author
Write a Comment
Gravatars are small images that can show your personality. You can get your gravatar for free today!