convert sqlite file into mysql

Question

I have a .sqlite file which I want to convert into mysql. So is there any way to convert it into mysql?I am using ubuntu. So is there any shell script to change it. Any help will be highly appreciable.

possible duplicate of [Quick easy way to migrate SQLite3 to MySQL?](http://stackoverflow.com/questions/18671/quick-easy-way-to-migrate-sqlite3-to-mysql) — p.campbell, Jul 15 '11 at 17:10

xialu · Answer 1 · 2019-07-09T03:05:46.173

4

assuming your sqlite db file is login.db
download this script as sqlite3-to-mysql.sh
this command will tranform your sqlite db file to standard mysql sql file: sqlite3 login.db .dump > sqlite.sql && bash sqlite3-to-mysql.sh sqlite.sql > mysql.sql && rm sqlite.sql
import to mysql: mysql -uuser -ppassword -D database < mysql.sql

edited Jul 09 '19 at 03:05

answered Sep 05 '18 at 04:32

xialu

174
3
11

score 0 · Answer 2 · answered May 06 '20 at 16:20

I've tried this recently and most answers don't work because they're out of date. e.g. python vs python3

A method that worked for me that should never go out of date is to export the tables to CSV and then import them as CSV. I used Sequel Pro which can import a CSV. The downside is that you need to do each table individually. The upside is that this is a very robust method and doesn't require any custom scripts.

Run the following in your database folder changing "thedatabase" and the two occurances of "thetable" to the database name and table name respectively:

sqlite3 -header -csv thedatabase.db "select * from thetable;" > thetable.csv

For Sequel Pro:

Create your database
(Optional: Create table structure. Recommended to have the correct column types) You could get the create statement from an sqlite dump and fix them for mysql.
File > Import
Format: CSV
Check: "First line contains field names"
Check the field mappings and import

Explanation of the command to export:

"sqlite3" is the command line client for sqlite databases.
"-header -csv " sets the output to csv
"thedatabase.db" is the database file
"select * from thetable;" is the query to select all data from the table
" > thetable.csv" redirects the output of the data to thetable.csv file

score -3 · Answer 3 · edited Jun 09 '13 at 11:23

-3

1) Export sqlite database to sql file

sqlite3 sqlite.db .dump > mysql.sql

2) Import mysql.sql file to mysql database using phpmyadmin or other tools.

edited Jun 09 '13 at 11:23

Martin Thoma

124,992
159
614
958

answered Feb 10 '13 at 07:32

ketan

390
3
6

'sqlite3' is not recognized as an internal or external command. – Floris Feb 26 '20 at 15:28
@Floris of course you need to download it and install before – Acuna Jun 02 '20 at 14:26
sqlite dumps are not the same dialect as mysql. – Charaf Aug 11 '22 at 13:07

Nils Werner · Answer 4 · 2013-06-10T10:20:07.403

-3

To directly import it to the database in just one command:

sqlite3 database.db .dump | mysql -uuser -ppassword database

edited Jun 10 '13 at 10:20

answered Jun 09 '13 at 11:28

Nils Werner

34,832
7
76
98

I guess you should delete the whitespace after `-p`. At least on my machine it works without withespace but not with a space between `-p` and my password. – Martin Thoma Jun 09 '13 at 12:29
Good job , Pipeline always make it easy – Feb 24 '17 at 12:17
sqlite dumps are not the same dialect as mysql. – Charaf Aug 11 '22 at 13:08

score -23 · Answer 5 · answered Jul 15 '11 at 17:06

Google "sqlite to mysql" will give you a lot of articles doing that ...

Okay, easiest is to open the .sqlite file using sqlite, .dump to a file, and the file is a text file containing SQL statements.

You shall be able to edit that file and run in your mysql DB thereafter.

convert sqlite file into mysql

5 Answers5