Difference between revisions of "Migrating mediawiki from MySQL to SQLite"

From Linuxintro
imported>ThorstenStaerk
imported>ThorstenStaerk
Line 5: Line 5:
 
* the articles' revisions
 
* the articles' revisions
 
* the images and other files
 
* the images and other files
 +
* users and passwords
 
* mediawiki's access statistics
 
* mediawiki's access statistics
 
* special mediawiki extensions you have
 
* special mediawiki extensions you have

Revision as of 10:53, 7 September 2013

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