#!/bin/bash

DBUSER=root
DBPASS=ver1amt4711

cd wikidumps
gzip -d *.sql.gz
cd ..

#for d in infoserver
#for d in cswiki farm g2mwiki ilwiki infoserver lmscorporate nxcaewiki rwiki samtechwiki systemsynthesiswiki tlwiki twwiki vlwiki
#for d in cswiki farm g2mwiki ilwiki lmscorporate nxcaewiki rwiki samtechwiki systemsynthesiswiki tlwiki twwiki vlwiki
for d in farm rwiki
do
echo "-----------------> Process $d <----------------------"

echo "    - backup images"
rm -rf sites/$d/images.bak
mv sites/$d/images sites/$d/images.bak

echo "    - untar images";
#cp -a wikidumps/images/$d/images sites/$d
#( cd sites; tar xf ../wikidumps/${d}_images.tar.gz)
cp -a wikidumps/images_${d} sites/${d}/images


echo "    - delete old db"
mysql -u${DBUSER} -p${DBPASS} <<END_TEXT
drop database ${d}_1222;
END_TEXT

mysql -u${DBUSER} -p${DBPASS} <<END_TEXT
drop database ${d}_1362;
END_TEXT

echo "    - create new db"
mysql -u${DBUSER} -p${DBPASS} <<END_TEXT
create database ${d}_1362;
END_TEXT

echo "    -load db"
mysql -u${DBUSER} -p${DBPASS} ${d}_1362 < $(echo wikidumps/${d}*.sql)


echo "    - done"
done