Migrating mediawiki from MySQL to SQLite

From Linuxintro
Revision as of 10:53, 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
  • users and passwords
  • 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