Quick easy way to migrate SQLite3 to MySQL?

migration, mysql, sqlite

Solution

Here is a list of converters (not updated since 2011):

- https://www2.sqlite.org/cvstrac/wiki?p=ConverterTools (or snapshot at archive.org)

An alternative method that would work nicely but is rarely mentioned is: use an ORM class that abstracts specific database differences away for you. e.g. you get these in PHP (RedBean), Python (Django's ORM layer, Storm, SqlAlchemy), Ruby on Rails (ActiveRecord), Cocoa (CoreData)

i.e. you could do this:

- Load data from source database using the ORM class.

- Store data in memory or serialize to disk.

- Store data into destination database using the ORM class.

Problem

Original source

Related problems

• Translating Perl to Python
• How to import a CSV file into a MySQL table
• re.sub not replacing all occurrences
• UTF8 MySQL problems on Rails - encoding issues with utf8_general_ci
• script to convert mysql dump sql file into format that can be imported into sqlite3 db