Backup commands

From Knot Atlas
Revision as of 10:19, 2 September 2005 by Drorbn (talk | contribs)
Jump to navigationJump to search
  • To backup the SQL database
mysqldump -u <username> -p <password> <nameofyourdatabase> > wikidb-backup-<yymmdd>.sql
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 then
cd /www/html/w
tar cvzf web-backup-<yymmdd>.tar.gz *
Retrieved from "https://katlas.org/index.php?title=Backup_commands&oldid=44076"