Backup: Difference between revisions
From Federal Burro of Information
Jump to navigationJump to search
No edit summary |
No edit summary |
||
Line 30: | 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 == | == Also See == | ||
* [[ITSM Backup]] | * [[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