Shell script to import mysql dump file

I hope this helps you . The mysqldump option --compatible=ansi doesn't produce a SQL script that is fully ANSI compatible, it just tries to produce a result that is more ANSI compatible: "Produce output that is more compatible with other database systems or with older MySQL servers."
Unfortunately, the SQL syntax supported by each database is a bit different. SQL is a relatively weak standard, much weaker than Javascript or even C. Some databases support compatibility features like MySQL does, or even compatibility modes (disclaimer: I'm the main author of H2), but even this is not enough sometimes.

Hope this helps cat *.sql | mysql? Do you need them in any specific order?
If you have too many to handle this way, then try something like:

find . -name '*.sql' | awk '{ print "source",$0 }' | mysql --batch

I wish this help you Sql file to mysql database using shell script. I have ten more .sql files. But all of the .sql files are imported into same database. The .sql files are in .gz format. , bash:

for sql_file in *.sql; do mysql db_name < $sql_file; done

I hope this helps . If you will upload it trought ssh, use scp:
scp @:

ftp -n $FTP_SERVER <<End-Of-Session
# -n option disables auto-logon

user anonymous "$FTP_PASS"
binary
cd $FTP_DIR
put "$AKT_DATUM.backup.sql.tgz"
bye
End-Of-Session

 FTP_PASS=password1
 FTP_SERVER=my.ftp.server
 FTP_DIR=/remote/dir/