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