TikiWiki : 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:

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 epics variables)

/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

Accessing DB

There are 2 mysql user accounts for accessing e02013 database:

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

mysql -h yerphi -u gen

History: GEnDB

Preview of version: 1

History