If the mysql database is populated with gnizr data, running the 'loadsch.sh' script should warn the user that the existing db data will be lost.

Comment deleted

Comment deleted

Based on rick's suggestion (may 29, 08),

http://code.google.com/p/gnizr/wiki/SetupGnizrDatabase

I modified his script and added the following:

rows=mysql -u $USER -p${PASS} -e "show tables" $DB |wc -l if [ $rows -gt 0 ] then echo "Looks like the gnizr has already been installed." echo "Enter YES to continue (ALL EXISTING DATA WILL BE LOST!): " read input if [ "$input" != "YES" ] then echo "Quit! No changes are made." exit 1 fi fi