Difference between revisions of "Migrating a database from mysql to sqlite"
From Linuxintro
imported>ThorstenStaerk (Created page with " mysqldump wikidb -u wikiuser -p > dump.sql") |
imported>ThorstenStaerk |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| + | 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 | 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 = | ||
| + | * [[migrating mediawiki from mysql to sqlite]] | ||
Latest revision as of 13:03, 7 September 2013
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
