Migrating a database from mysql to sqlite

From Linuxintro

Revision as of 12:47, 7 September 2013 by imported>ThorstenStaerk

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

I tried to migrate my wiki's database from MySQL to SQLite. To do this

I created a dump (aka backup aka export) of the database

mysqldump wikidb -u wikiuser -p > dump.sql

I got a MySQL -> SQLite converter

wget https://gist.github.com/esperlu/943776/raw/dd87f4088f6d5ec7563478f7a28a37ba02cf26e2/mysql2sqlite.sh

I started this converter

sh mysql2sqlite.sh -u wikiuser -p wikidb | sqlite test.sqlite

See also

migrating mediawiki from mysql to sqlite

Retrieved from "http://linuxintro.org/index.php?title=Migrating_a_database_from_mysql_to_sqlite&oldid=18746"