Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP
Take a sqlite3 sql-dump file and make it mysql readable.
Shell
branch: some_fix

This branch is 2 commits behind athlite:master

Fetching latest commit…

Cannot retrieve the latest commit at this time

Failed to load latest commit information.
README.rdoc
sqlite3-to-mysql

README.rdoc

sqlite3-to-mysql

Simple sed script for attempting to convert Sqlite3 sql to MySql sql.

Usage:

sqlite3-to-mysql filename.sql > filename.new.sql

Notes

Please note that sed needs to be in your $PATH

Not guaranteed to work, but can serve as a starting point.

It worked for my case though.

Decided to make this after trying the yaml_db gem, which I found to be excruciatingly slow for any dataset of considerable size.

Something went wrong with that request. Please try again.