5 ###########################################################
6 [ "$DATABASE" != "x4dat" ] || die
"Cannot target x4dat"
8 echo "Setting up new database: target db is \"$DATABASE\", source prefix is \"$DBPREFIX\""
9 echo "* press ^D to start import (^C to cancel)"
12 echo -n
"* create database "
13 (echo "CREATE DATABASE IF NOT EXISTS $DATABASE;" |
$MYSQL) || die
"ERROR"
16 echo -n
"* copying tables "
17 .
/copy_tables.php || die
"ERROR"
20 for sql
in ..
/newdirectory-0.0
.1/*.sql
22 echo -n
"* running $sql "
23 (sed -e
"s/#\([0-9a-z]*\)#/${DBPREFIX}\1/g" < $sql |
$MYSQL $DATABASE >/dev
/null
) || die
"ERROR"
29 echo -n
"* running $sql "
30 (sed -e
"s/#\([0-9a-z]*\)#/${DBPREFIX}\1/g" < $sql |
$MYSQL $DATABASE >/dev
/null
) || die
"ERROR"
34 ###########################################################
35 echo -n
"Importing phone numbers "
37 ..
/newdirectory-0.0
.1/phones.php || die
"ERROR"
40 ###########################################################
41 echo "Updating birthday dates "
43 .
/birthday.php || die
"ERROR"