History: GEnDB

-=General information=-
^DB type: MySQL
Server version: 5.0.18
TCP port: 3306
DSN: mysql://gen@yerphi.jlab.org/e02013^
-=Backup=-
The database backuped up by user nerses using crontab job run every night from ifarml2. The scipt launched by cron is /work/halla/e02013/disk1/GEn/db/dump_e02013.sh. Back-ups are collected in the same directory (/work/halla/e02013/disk1/GEn/db).

Backed up databases include:
{DL()}e02013:GEn database, accessed by user gen and gen_admin
tikiwiki:database used by ((GEn)) wiki
tikicustomdata:database also used by GEn wiki, but contains non-standard tables (like list of ((GEnDocEpics|epics variables))){DL}

{CODE(caption=>/work/halla/e02013/disk1/GEn/db/dump_e02013.sh)}
#!/bin/bash

# Author nerses@jlab.org
# do backups in this directory
cd /work/halla/e02013/disk1/GEn/db

function db_dump(){
# Usage:
# db_dump <user> <password> <database>
OUTPUT=${3}_`date +%Y%m%d`.sql
/apps/bin/mysqldump -h yerphi -u $1 --password=$2 $3 > $OUTPUT
bzip2 -q $OUTPUT
}

db_dump gen '' e02013
db_dump tikiuser '********' tikiwiki
db_dump tikiuser '********' tikicustomdata
{CODE}
-=Accessing DB=-
There are 2 mysql user accounts for accessing e02013 database:
{DL()}gen_admin: used to fill the database with data (password protected)
gen: used for read only access of data could be accessed using the following command{CODE()}mysql -h yerphi -u gen{CODE}{DL}