- Wednesday, May 23, 2018, 17:05
- How-to
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 ...
Full story