Backup commands: Difference between revisions

Latest revision as of 10:29, 19 September 2006

The current script runs in /home/backup

mysqldump -q -u wikiuser -p<password> wikidb > wikidb-backup-<yymmdd>.sql
gzip -9 wikidb-backup-<yymmdd>.sql

(with the obvious substitutions).

cd /www/html/w; tar cvzf web-backup-<yymmdd>.tar.gz .

@@ Line 1: / Line 1: @@
+The current script runs in /home/backup
 *To backup the SQL database
- mysqldump -u <username> -p <nameofyourdatabase> > wikidb-backup-05MoDa.sql
+ mysqldump -q -u wikiuser -p<password> wikidb > wikidb-backup-<yymmdd>.sql
-(for us, <tt>username</tt> is <tt>wikiuser</tt> and <tt>nameofyourdatabase</tt> is <tt>wikidb</tt>).
+ gzip -9 wikidb-backup-<yymmdd>.sql
-*To create a backup of the web directory, login as wiki, and go to /www/html/w and type
- tar cvzf web-backup-2005MoDa.tar.gz *
+(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 .