Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Export a MySQL Database to SQLite Database

Please help me with exporting a MySQL database into a SQLite database.

like image 233
Devi Avatar asked Mar 02 '11 06:03

Devi


People also ask

Can I export database from MySQL?

Confirm that SQL is selected under format. Click “Go”. Type the file name and select the directory where your exported database is to be saved in the 'Save File' dialogue box on your local computer. Click “Save” and the process of exporting will start.

Can MySQL connect to SQLite?

Method 1: Converting SQLite to MySQL with . The quickest and easiest way to convert SQLite to MySQL is by exporting an SQL Database to a Dump File, and then importing the SQLite Dump into MySQL Database. You can export an SQLite Database to Dump File using the .


1 Answers

There's a fantastic Linux shell script on Github that converts Mysql to an Sqlite3 file. You need both mysqldump and sqlite3 installed on your server. Works great.

like image 189
georgiecasey Avatar answered Oct 20 '22 06:10

georgiecasey