Backup commands: Difference between revisions

Revision as of 20:51, 5 September 2005

mysqldump -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: @@
 *To backup the SQL database
- mysqldump -u <username> -p<password> <nameofyourdatabase> > wikidb-backup-<yymmdd>.sql
+ mysqldump -u wikiuser -p<password> wikidb > 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