Backup commands: Difference between revisions
From Knot Atlas
Jump to navigationJump to search
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
*To backup the SQL database |
*To backup the SQL database |
||
mysqldump -u <username> -p <nameofyourdatabase> > wikidb-backup-<yymmdd>.sql |
mysqldump -u <username> -p <password> <nameofyourdatabase> > wikidb-backup-<yymmdd>.sql |
||
<password> |
|||
gzip -9 wikidb-backup-<yymmdd>.sql |
gzip -9 wikidb-backup-<yymmdd>.sql |
||
Revision as of 10:19, 2 September 2005
- 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 *
