./export-csv-coordinates.sh: line 49: warning: here-document at line 18 delimited by end-of-file (wanted `EOFMYSQL')
./export-csv-coordinates.sh: line 50: syntax error: unexpected end of file

#!/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