|
|
Something wrong with while loop
07-02-2010
07-02-2010
Something wrong with while loop
#!/bin/bash
while :
do
clear
echo "Server Name - $(hostname)"
echo "-------------------------------------"
echo " MAIN MENU "
echo "-------------------------------------"
echo "1. Export coordinates as csv file"
echo "2. Import csv file to update database"
echo "3. Exit"
read -p "Enter your choice [ 1 - 3 ]" choice
case $choice in
1)
echo "Exporting coordinates as CSV...please wait!"
sleep 5
mysql -uroot -proot iaf<<EOFMYSQL
SELECT * INTO OUTFILE '/var/lib/mysql/nodecoordinates.csv' FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' FROM sngnms_node_map_coordinate;
EOFMYSQL
echo "CSV created in /var/lib/mysql"
read -p "Press [ENTER] key to continue..."
readEnterKey;;
2)
file="/var/lib/mysql/nodecoordinates.csv"
for f in $file
do
[ -f $f ] && echo "$f file found" || echo "*** Error -$f file not found!"
done
echo ""
echo "Importing CSV file to update database...please wait!"
sleep 5
mysql -uroot -proot iaf<<EOFMYSQL
LOAD DATA INFILE '/var/lib/mysql/nodecoordinates.csv' INTO TABLE sngnms_node_map_coordinate FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n';
EOFMYSQL
/etc/init.d/mysql restart
sleep 5
echo "CSV file updated to current database"
read -p "Press [ENTER] key to continue..."
readEnterKey;;
3)
echo "Bye!"
exit 0;;
*)
echo "Error: Invalid option..."
read -p "Press [ENTER] key to continue..."
readEnterKey;;
esac
done|
|