March 2009
5 posts
Translating a database from MySQL to SQLite
I needed to translate some data from MySQL to SQLite on OSX today, and it proved to be a little more work than I thought. This is the procedure I went through to get it done:
Used CPAN to install SQLFairy with the command:
sudo cpan -i SQL::Translator
exported the MySQL database schema with no data in it
mysqldump -u username -p database --no-data > database.sql
translate it into...
5 tags
