Backup: Difference between revisions
From Federal Burro of Information
Jump to navigationJump to search
No edit summary |
|||
(3 intermediate revisions by the same user not shown) | |||
Line 5: | Line 5: | ||
* machine: piccolo | * machine: piccolo | ||
** source: home dir ( C:\Documents and Settings\David ) | ** source: home dir ( C:\Documents and Settings\David ) | ||
*** desitnation | *** desitnation H:\desktop\piccolo\david | ||
== Data Stores == | == Data Stores == | ||
Line 19: | Line 19: | ||
== Application Data == | == Application Data == | ||
=== EVE === | |||
* Backup scripts http://www.eveonline.com/ingameboard.asp?a=topic&threadID=891332&page=1#1 | * Backup scripts http://www.eveonline.com/ingameboard.asp?a=topic&threadID=891332&page=1#1 | ||
Line 29: | Line 30: | ||
'''restore''' | '''restore''' | ||
zcat wikidb-20110206.sql.gz | nice -n 19 /usr/bin/mysqldump -u root -p wikidb2 -c | 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]] |
Latest revision as of 01:05, 16 April 2024
back up catalogue:
Machines
- machine: piccolo
- source: home dir ( C:\Documents and Settings\David )
- desitnation H:\desktop\piccolo\david
- source: home dir ( C:\Documents and Settings\David )
Data Stores
- DOCS
- Archive
- Backups
- from 320 gb drive to 1 TB drive
- how: sync scripts on cydonia
Application Data
EVE
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