Open main menu

frontyard β

Changes

Wiki.frontyardprojects.org

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
 
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