8000 GitHub - bleenco/sqlite2mysql: SQLite3 dump to MySQL dump converter · GitHub
[go: up one dir, main page]

Skip to content

About

SQLite3 dump to MySQL dump converter

Resources

Stars

10 stars

Watchers

3 watching

Forks

Latest commit

 

History

5 Commits

Folders and files

NameName
Last commit message
Last commit date
 
 A762  
 
 
 
 
 
 
 
 
 
 

Repository files navigation

sqlite2mysql

SQLite3 dump to MySQL dump converter.

Exporting from SQLite3 and importing to MySQL

First, make a dump of SQLite3 database:

sqlite3 db.sqlite .dump > db.sql

Then, run sqlite2mysql.pl script to convert dump to MySQL format:

./sqlite2mysql.pl db.sql > mysql-db.sql

Hopefully, everything went smooth, now:

Open additional terminal instance, run below two commands and leave it open during import:

mysql -u username -p
set global net_buffer_length=1000000;
set global max_allowed_packet=1000000000;

and now on first terminal instance:

mysql -u username -p database_name < mysql-db.sql

About

SQLite3 dump to MySQL dump converter

Resources

Stars

10 stars

Watchers

3 watching

Forks

Releases

Packages

Contributors

Languages

0