Difference between revisions of "Wikibackup"

From Teknologisk videncenter
Jump to: navigation, search
m
m (mysqldump)
Line 11: Line 11:
 
mysqldump -u USERNAME -pPASSWORD --default-character-set=latin1 wikidb -c > /home/backup/wikidb120209.dump
 
mysqldump -u USERNAME -pPASSWORD --default-character-set=latin1 wikidb -c > /home/backup/wikidb120209.dump
 
</pre>
 
</pre>
[[category:SQL]][[category:mediawiki]]
+
[[category:Database]][[category:mediawiki]]

Revision as of 11:15, 15 May 2009

Backup of this wiki

Locking the database

During backup, the database will be locked using the $wgReadOnly variable in LocalSettings.php

$wgReadOnly = '<b>Backup operation in progress.</b> Please wait a few minutes.';

mysqldump

example

mysqldump -u USERNAME -pPASSWORD --default-character-set=latin1 wikidb -c > /home/backup/wikidb120209.dump