Backup commands

From Knot Atlas
Revision as of 10:04, 2 September 2005 by Drorbn (talk | contribs)
Jump to navigationJump to search
  • To backup the SQL database
mysqldump -u <username> -p <nameofyourdatabase> > wikidb-backup-<yymmdd>.sql
<password>
gzip -9 wikidb-backup-<yymmdd>.sql

(for us, username is wikiuser and nameofyourdatabase is wikidb; yymmdd is what it always is).

  • To create a backup of the web directory, login as wiki, and go to /www/html/w and type
tar cvzf web-backup-<yymmdd>.tar.gz *
Retrieved from "https://katlas.org/index.php?title=Backup_commands&oldid=44074"