Backup commands

From Knot Atlas
Revision as of 17:41, 16 September 2005 by Scott (talk | contribs)
Jump to navigationJump to search

The current script runs in /home/backup

  • To backup the SQL database
mysqldump -u wikiuser -p<password> wikidb > wikidb-backup-<yymmdd>.sql
gzip -9 wikidb-backup-<yymmdd>.sql

(with the obvious substitutions).

  • To create a backup of the web directory, login as wiki and then
cd /www/html/w; tar cvzf web-backup-<yymmdd>.tar.gz *