Backup: Difference between revisions

From Federal Burro of Information
Jump to navigationJump to search
No edit summary
 
(2 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 h:\
*** desitnation H:\desktop\piccolo\david


== Data Stores ==
== Data Stores ==
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 ==
* [[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

Data Stores

  1. DOCS
  2. Archive
  3. 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


Also See