Backup commands: Difference between revisions

From Knot Atlas
Jump to navigationJump to search
No edit summary
No edit summary
Line 1: Line 1:
The current script runs in /home/backup

*To backup the SQL database
*To backup the SQL database



Revision as of 17:41, 16 September 2005

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 *