Script to convert and add sqlite3 database into a mysql/mariadb database
This script is used to convert a sqlite3 .db file into a running mysql/mariadb 5.x+ instance. It was adapted from the code posted at http://www.redmine.org/boards/2/topics/12793?r=24999 . I've mostly simply altered it to make the effort of use minimal.
The script works as a layer between sqlite and mysql to format the sqlite dump, create a new user and database in mysql, and restore all the tables and data in one shell line.
A running flavor of MySQL (eg, MariaDB).
Python 2.7 / Python 3
$ sqlite3 filename.db .dump | ./sqlite3-to-mysql.py -u new_user -p new_password -d new_database | mysql -u root -p --default-character-set=utf8
That's it! Log into mysql database with your new user and your tables should be there and populated!
There isn't any forseeable reason for this not to work on Windows using sqlite.exe and mysql.exe, etc. I have not testing this.
As always, use your common sense and backup your data before attempting this. If you pick a database name that already exists in your mysql instance, expect the data to be overwritten.
Enjoy!
