Backup commands: Difference between revisions
From Knot Atlas
Jump to navigationJump to search
No edit summary |
No edit summary |
||
| (6 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
The current script runs in /home/backup |
|||
*To backup the SQL database |
*To backup the SQL database |
||
mysqldump -u |
mysqldump -q -u wikiuser -p<password> wikidb > wikidb-backup-<yymmdd>.sql |
||
<password> |
|||
gzip -9 wikidb-backup-<yymmdd>.sql |
gzip -9 wikidb-backup-<yymmdd>.sql |
||
(with the obvious substitutions). |
|||
(for us, <tt>username</tt> is <tt>wikiuser</tt> and <tt>nameofyourdatabase</tt> is <tt>wikidb</tt>; <tt>yymmdd</tt> is what it always is). |
|||
*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 |
cd /www/html/w; tar cvzf web-backup-<yymmdd>.tar.gz . |
||
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 .
