MySQL Forums
Forum List  »  Connector/ODBC

Re: importing data dump from odbc local database
Posted by: Bogdan Degtyariov
Date: May 04, 2020 04:43AM

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).

Options: ReplyQuote


Subject
Written By
Posted
Re: importing data dump from odbc local database
May 04, 2020 04:43AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.