Migrating a database from mysql to sqlite

From Linuxintro
Revision as of 13:03, 7 September 2013 by imported>ThorstenStaerk
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

I migrated my mediawiki's MySQL database 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 | sqlite3 test.sqlite

See also

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