Re: importing data dump from odbc local database

[Bogdan Degtyariov]

The output produced by mysqldump requires special handling. It is not intended to be executed like a normal SQL.
If you want to automate and keep things simple it is best done using a bat file that imports the sql dump through mysql command line like this:

mysql --user=.... -p < sqldump_file.sql

It will only prompt for a password to connect to the database (or a password can even be hardcoded using --password=..., but this is a bad practice because anyone can see the password and it is left in the history of the commands).