Migrating mediawiki from MySQL to SQLite
From Linuxintro
Revision as of 10:42, 7 September 2013 by imported>ThorstenStaerk
I wanted to migrate my mediawiki installation from the MySQL database to SQLite. Reason was that I am short on memory, and the mysql process was always the process on my server that ate most of the memory.
When migrating a mediawiki you should always take into account:
- the articles
- the articles' revisions
- the images and other files
- mediawiki's access statistics
- special mediawiki extensions you have
server:/srv/www/htdocs/staerk/thorsten # php maintenance/dumpBackup.php --full >ThorstensHome-2013-09-07.xml
server:/srv/www/htdocs/staerk/thorsten3 # php maintenance/importDump.php ThorstensHome-2013-09-07.xml