Convert a MySQL dump to SQLite3

Sometimes it’s great when you find a tiny tool that does one thing and one thing pretty good. Currently I’m doing a fair bit of back-end development in Django. I usually run with a small sqlite3 database locally instead of having a separate MySQL database. This enables me to quickly copy the file to another computer if needed.

However the production database is a lot more complete than my tiny SQLite database (a lot of people have added content into it). So I needed a way to get all the content into my development database. After some browsing I found a shell script called mysql2sqlite which worked wonders. It takes a mysql dump and converts it into a sqlite3 database file using awk.

Leave a Reply

Your email address will not be published. Required fields are marked *


This site uses Akismet to reduce spam. Learn how your comment data is processed.