Remove useless @.
[platal.git] / upgrade / account / update.sh
CommitLineData
9d5e1087
FB
1#!/bin/bash
2
3. ../inc/pervasive.sh
4
5###########################################################
d0293d9b
FB
6[ "$DATABASE" != "x4dat" ] || die "Cannot target x4dat"
7
8echo "Setting up new database: target db is \"$DATABASE\", source prefix is \"$DBPREFIX\""
9echo "* press ^D to start import (^C to cancel)"
9d5e1087
FB
10cat
11
d0293d9b 12echo -n "* create database "
aa1f260a 13(echo "CREATE DATABASE IF NOT EXISTS $DATABASE;" | mysql_run) || die "ERROR"
d0293d9b
FB
14echo "OK"
15
9d5e1087 16echo -n "* copying tables "
8600216c 17(./copy_tables.sh | mysql_run) || die "ERROR"
9d5e1087
FB
18echo "OK"
19
aa1f260a 20for sql in ../newdirectory-0.0.1/*.sql *.sql
9d5e1087
FB
21do
22 echo -n "* running $sql "
aa1f260a 23 (cat $sql | mysql_run) || die "ERROR"
9d5e1087
FB
24 echo "OK"
25done
26
27###########################################################
28echo -n "Importing phone numbers "
29
d0293d9b 30../newdirectory-0.0.1/phones.php || die "ERROR"
9d5e1087
FB
31echo "OK"
32
33###########################################################
34echo "Updating birthday dates "
35
36./birthday.php || die "ERROR"
37echo "OK"