Backup commands: Difference between revisions
From Knot Atlas
Jump to navigationJump to search
No edit summary |
No edit summary |
||
| (One intermediate revision by the same user not shown) | |||
| Line 3: | Line 3: | ||
*To backup the SQL database |
*To backup the SQL database |
||
mysqldump -u wikiuser -p<password> wikidb > wikidb-backup-<yymmdd>.sql |
mysqldump -q -u wikiuser -p<password> wikidb > wikidb-backup-<yymmdd>.sql |
||
gzip -9 wikidb-backup-<yymmdd>.sql |
gzip -9 wikidb-backup-<yymmdd>.sql |
||
| Line 10: | Line 10: | ||
*To create a backup of the web directory, login as wiki and then |
*To create a backup of the web directory, login as wiki and then |
||
cd /www/html/w; tar cvzf web-backup-<yymmdd>.tar.gz |
cd /www/html/w; tar cvzf web-backup-<yymmdd>.tar.gz . |
||
Latest revision as of 10:29, 19 September 2006
The current script runs in /home/backup
- To backup the SQL database
mysqldump -q -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 .
