#!/bin/bash
#
# import/export script for pathway database
#
host=127.0.0.1
user=root
pass=password
db=database
while :
do
clear
echo "*************************"
echo "  * PathwayOTD *     "
echo "*************************"
echo "  * [I] Import *"
echo "  * [B] Backup *"
echo "  * [C] Clean  *"
echo "  * [N] Character/logon structure *"
echo "  * [U] Update to latest revision *"
echo "  * [O] Open Changelog *"
echo "********************************************"
echo "Enter your menu choice [a-0]: "
echo
echo "REMEMBER: Clean assumes you RUN ONE DATABASE FOR CHARACTER/LOGON/WORLD."
echo
echo "Before running this script please take the time to edit it."
echo
read yourch
case $yourch in
I) echo starting to import Pathway of the Damned DB
sudo apt-get -y --force-yes -f install mysql-client libmysqlclient15
for file in database/*.sql
do
echo $file
mysql -u $user --password=$pass -h $host $db < $file
done
echo done ;;
B) echo starting backup
sudo apt-get -y --force-yes -f install mysql-client libmysqlclient15
mysql -u $user --password=$pass -h $host $db > Backup/pathway.sql
done
echo done ;;
C)
0) exit 0;;
*) echo "Error";
echo "Press Enter to continue. . ." ; read ;;
esac
done