MySQL Forums
Forum List  »  MySQL Workbench

Import data hangs workbench 6:help!
Posted by: Andrew Jonkers
Date: February 16, 2014 01:07AM

Maybe I am doing this all wrong, being a noob, but:

Exported all databases from 5.5 using workbench "Data Export"
Upgraded mysql from 5.5 to 5.6 (workbench 6)

Tried Data Import of the databases - workbench script hangs indefinitely with no disk activity.

I note workbench attempts the import script as follows:
"mysql.exe" --defaults-extra-file="c:\users\andrew\appdata\local\temp\tmptcqnli.cnf" --host=localhost --user=root --port=3306 --default-character-set=utf8 --comments < "Q:\\Capture\\SQLBackupGimli\\20120518dump_analysis_items.sql"

The above script hangs workbench, although I note the .cnf file has been correctly created by workbench AND contains the correct password as follows:
[client]
password="pass"

Finally, I note that if I manually run mysql with a -ppass option, the import works no problem...(but with warning about password in clear)

mysql.exe" --host=localhost --user=root -ppass --port=3306 --default-character-set=utf8 --comments < "Q:\\Capture\\SQLBackupGimli\\20120518dump_analysis_items.sql"

Above script works fine.

Anyone know whats up with the workbench import going wrong????

Options: ReplyQuote


Subject
Views
Written By
Posted
Import data hangs workbench 6:help!
7340
February 16, 2014 01:07AM
1899
February 17, 2014 02:00AM


Sorry, you can't reply to this topic. It has been closed.

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.