Jump to: navigation, search

838 bytes added, 05:14, 30 June 2018
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
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
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

Navigation menu