Difference between revisions of "Migrating mediawiki from MySQL to SQLite"
From Linuxintro
imported>ThorstenStaerk |
imported>ThorstenStaerk |
||
| Line 1: | Line 1: | ||
| − | I | + | 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/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 | server:/srv/www/htdocs/staerk/thorsten3 # php maintenance/importDump.php ThorstensHome-2013-09-07.xml | ||
Revision as of 10:42, 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
- 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
