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 <nameofyourdatabase> > wikidb-backup-<yymmdd>.sql |
||
<password> |
|||
gzip -9 wikidb-backup-<yymmdd>.sql |
|||
(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). |
(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 go to /www/html/w and type |
*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 * |
tar cvzf web-backup-<yymmdd>.tar.gz * |
||
Revision as of 11:04, 2 September 2005
- 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 *
