In a recent release of fundamentals I included a new sqlite2mysql cl-tool. The sqlite2mysql tool does exactly what you would expect it to do; it takes the path to a sqlite database file and copies the tables found in the database to a MySQL database of your choosing.
For the usage run sqlite2mysql -h from the command-line:
Take a sqlite database file and copy the tables within it to a MySQL database
Usage:
sqlite2mysql -s <pathToSettingsFile> <pathToSqliteDB> [<tablePrefix>]
Options:
pathToSqliteDB path to the sqlite database file
tablePrefix a string to prefix the table names when copying to mysql database
pathToSettingsFile path to a settings file with logging and database information (yaml file)
-h, --help show this help message
-v, --version show version
-s, --settings the settings file
As usual pathToSettingsFile contains your MySQL database settings (see example at the start of this tutorial). To convert a sqlite databse I could run something like:
sqlite2mysql -s /Users/Me/mydefault_settings.yaml /Users/Me/ebooks.sqlite imported
This command takes the tables in the /Users/Me/ebooks.sqlite database, prepends the names of the tables with ‘imported_’ and imports the tables into the MySQL database whose settings are found in the /Users/Me/mydefault_settings.yaml file. Here are the resulting MySQL database tables as listed in MySQLWorkbench:
As alway, to upgrade fundamentals on you machine run:
pip install fundamentals --upgrade