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