ETICS Backups @ CERN

MySQL DB Backup

Marian has setup nightly cron jobs for MySQL database dumps. The backups are kept:

1) locally (etics/etics-test nodes) under the dirs: /home/eticsbld/org.etics/org.etics.database-dump/etics /home/eticsbld/org.etics/org.etics.database-dump/etics-test

2) On afs under dirs: /afs/cern.ch/project/etics/builds/org.etics/org.etics.database-dump/etics /afs/cern.ch/project/etics/builds/org.etics/org.etics.database-dump/etics-test

The access rights has been set accordingly, so they are not publicly visible. Please verify you can read it properly. If not please let me know which account you are using.

Currently two different types of the backups are performed:

  • Full database backup (stored in the file e.g. DBBackup_FULL_BACKUP-20061027-0404.sql.gz)
  • Etics database backup (stored in the file e.g. eticsDBBackup-200611027-0404.sql.gz)

The full backup is performed with the command mysqldump --single-transaction --all-databases.

The backups can be accessed:

1) from AFS as described under: http://consult.cern.ch/qa/0948. You may want a while or more for the tapes mount should you need backup from 1+ days ago.

2) from ADSM using dsmj as described: http://service-backup.web.cern.ch/service-backup/

Both scenarios has been exercised and have proven to work.

The recovery of the data requires the actions as follows:

  • Dropping the existing database tables:
  1. mysql -u root -p
  2. drop database etics;
  3. quit;
  4. gunzip -d eticsDBBackup-200611027-0404.sql.gz
  5. mysql -u root -p < eticsDBBackup-200611027-0404.sql

-- Main.couvares - 14 Nov 2006

Edit | Attach | Watch | Print version | History: r3 < r2 < r1 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r3 - 2006-11-14 - unknown
 
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    ETICS All webs login

This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2020 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback