Registration/HowToRegister の履歴(No.4)

[How to register database]

1. make a backup

(1) create new backup file on saga

 [backup]% mysqldump --databases saga -u suda -p > bak091001_saga20090902.sql
 rule of filename: bak[date of creating backup]_[database name][date of the last update of database].sql

(1') find a backup file in saga

  saga:/home/suda/public_html/backup/bak090510saga1.sql

(2') rename it (suda@saga)

 [backup]% mv bak090510saga1.sql bak090620_saga20090505.sql

(3) edit to change database name from saga1 to saga20090505 (suda@saga)

 [backup]% vi bak090620_saga20090505.sql

(4) issue commad (suda@saga)

 [backup]% mysql -u suda -p < bak090620_saga20090505.sql

2. copy Retrieval

(1) copy files (dbworker@saga)

 % su dbworker
 [Prev]% mkdir /home/dbworker/public_html/Prev/20090505
 [Prev]% cd ~/public_html/Prev/20090505
 [20090505]% cp -p ../../TableStructure.txt ./
 [20090505]% cp -rp ../../Lib ./
 [20090505]% cp -rp ../../Retrieval ./

(2) change $database_name in db.cgi from saga1 to saga20090505 (dbworker@saga)

 [Retrieval]% vi db.cgi

3. register new database

(1) check Entries in CSVfile (suda@saga)

 [CSVfile]% mv A0134 storage/
 [CSVfile]% mv A0095 storage/
 [CSVfile]% mv A0120 storage/
 [CSVfile]% mv A0173 storage/
 [CSVfile]% mv A9999 storage/

(2) check registration database name and user name (suda@saga)

 Main DB name : saga
 Temporary DB name : suda_tmp
 DB user name : saga_user
 [Lib]% vi settings.txt
   DBname:=saga
   DBuser:=saga_user

(3) confirm required files (suda@saga)

 DBRoot/Tools/html_SIMBAD

(4) register (suda@saga)

 [Registration]% ./regist.sh