270
edits
Changes
Add Julian’s backup notes
This wiki is hosted (where?). If you need to ssh into the server to access the actual files that make up the installation, you'll find the files at <code>/var/www/html/mediawiki</code>.
== Backing up this Wiki ==
1. Use mysqldump to make a backup
https://www.mediawiki.org/wiki/Manual:Backing_up_a_wiki#Mysqldump_from_the_command_line
2. You’ll want to save to a different filename every time, e.g.
nice -n 19 mysqldump -u $USER --password=$PASSWORD $DATABASE -c | nice -n 19 gzip -9 > ~/backup/wiki-$DATABASE-$(date '+%Y%m%d').sql.gz
You can skip the “nice -n 19” parts of this command, but the useful part is the date.
3. Test that the backup works
https://www.mediawiki.org/wiki/Manual:Restoring_a_wiki_from_backup
I’m not super clear on how to test.
4. Passwords are hashed and salted, so it’s probably ok. Use scp/sftp to copy, e.g.
scp wikifile.gz remote.server:~/backups/
5. You can put all that in a batch script and then use crontab. See
https://www.mediawiki.org/wiki/User:Flominator/Backup_MW