Backup: Difference between revisions

Latest revision as of 01:05, 16 April 2024

back up catalogue:

machine: piccolo
- source: home dir ( C:\Documents and Settings\David )
  - desitnation H:\desktop\piccolo\david

Backup

nice -n 19 /usr/bin/mysqldump -u root -p wikidb2 -c | nice -n 19 /bin/gzip -9 > ~/backup/wikidb-$(date '+%Y%m%d').sql.gz

restore

zcat wikidb-20110206.sql.gz | nice -n 19 /usr/bin/mysqldump -u root -p wikidb2 -c

nice -n 19 /usr/bin/mysqldump -u wikiuser -p wikidb -c | nice -n 19 /bin/gzip -9 > ~/backup/wikidb-$(date '+%Y%m%d').sql.gz

@@ Line 5: / Line 5: @@
 * machine: piccolo
 ** source: home dir ( C:\Documents and Settings\David )
-*** desitnation h:\
+*** desitnation H:\desktop\piccolo\david
 == Data Stores ==
@@ Line 17: / Line 17: @@
-== APplication Data ==
+== Application Data ==
+=== EVE ===
-'''EVE'''
 * Backup scripts http://www.eveonline.com/ingameboard.asp?a=topic&threadID=891332&page=1#1
+=== Media Wiki ===
+'''Backup'''
+ nice -n 19 /usr/bin/mysqldump -u root -p wikidb2 -c | nice -n 19 /bin/gzip -9 > ~/backup/wikidb-$(date '+%Y%m%d').sql.gz
+'''restore'''
+ zcat wikidb-20110206.sql.gz | nice -n 19 /usr/bin/mysqldump -u root -p wikidb2 -c
+=== 2024 update ===
+ nice -n 19 /usr/bin/mysqldump -u wikiuser -p wikidb -c | nice -n 19 /bin/gzip -9 > ~/backup/wikidb-$(date '+%Y%m%d').sql.gz
+== Also See ==
+* [[ITSM Backup]]