MySQL Bugs: #64363: Exporting data over SSL connections

Bug #64363	Exporting data over SSL connections
Submitted:	17 Feb 2012 13:45	Modified:	9 Aug 2012 5:04
Reporter:	Markku Laine	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Workbench: Administration	Severity:	S2 (Serious)
Version:	5.2.35, 5.2.37, 5.2.38	OS:	MacOS
Assigned to:		CPU Architecture:	Any
Tags:	data, export, SSL, workbench

Description:
The data export (and most probably import, too) function does not work over SSL connections in the Admin view. After clicking the Start Export button I get the following error message:
"13:24:18 Dumping my_schema
Running: /Applications/MySQLWorkbench.app/Contents/Resources/mysqldump --defaults-extra-file="/var/folders/mY/mYHw9ALZHAi63oZemNVbr++++TI/-Tmp-/tmpDGdhBL/extraparams.cnf"  --no-create-info=FALSE --order-by-primary=FALSE --force=FALSE --no-data=FALSE --tz-utc=TRUE --flush-privileges=FALSE --compress=FALSE --replace=FALSE --host=my.mysql.host --insert-ignore=FALSE --extended-insert=TRUE --user=my_username --quote-names=TRUE --hex-blob=FALSE --complete-insert=FALSE --add-locks=TRUE --port=3306 --disable-keys=TRUE --delayed-insert=FALSE --create-options=TRUE --delete-master-logs=FALSE --comments=TRUE --default-character-set=utf8 --max_allowed_packet=1G --flush-logs=FALSE --dump-date=TRUE --lock-tables=TRUE --allow-keywords=FALSE --events=FALSE --databases "my_schema"
mysqldump: Got error: 1045: Access denied for user 'my_username'@'my_ip_address' (using password: YES) when trying to connect

Operation failed with exitcode 2
13:24:18 Export of /data/my_data_dump.sql has finished with 1 errors"

The server version is 5.1.49-3 Linux/Debian.

How to repeat:
Allow only SSL connections to the MySQL server. Open MySQL Workbench and try to export (and import) the data from the database. Fails to complete the command.

Suggested fix:
SSL related parameters are probably left out from the command shown in the Description section.

Please, check if the same problem still happens with a newer version, 5.2.37.

Hi Valeriy,

I updated MySQL Workbench to the version (5.2.37) you suggested but the problem still remains. If I remember correctly, I tried to export data on a Windows machine with the latest version of MySQL Workbench and failed to complete the task as well.

Br,
+Markku

Please try version 5.2.38. Thanks.

Hi,

Thanks for the new version. I tried it (v5.2.38) on Mac OS X 10.6.8 (did not try either on Windows or the import command). Unfortunately, the new version failed to complete the export data command over an SSL connection. I just kept on getting the same error message (see below) every second and could not stop the exporting process using the Stop button.

------------------- 8< -----------------
Operation failed with exitcode 2
08:02:20 Dumping my_schema (my_table_1, my_table_2, etc.)
Running: /Applications/MySQLWorkbench.app/Contents/Resources/mysqldump --defaults-extra-file="/var/folders/mY/mYHw9ALZHAi63oZemNVbr++++TI/-Tmp-/tmpTIaAc8/extraparams.cnf"  --user=my_username --max_allowed_packet=1G --host=my_host --port=3306 --default-character-set=utf8 "my_schema" "my_table_1" "my_table_2" etc.
mysqldump: Got error: 1045: Access denied for user 'skunkadmin'@'etesian.tml.hut.fi' (using password: YES) when trying to connect
------------------- 8< -----------------

Br,
+Markku

the extraparams.cnf file has password, but no --ssl* options. 5.2.35, revision 5753, Mac OS X.

Very cool tool!

Thanks!
Fred

Verified, SSL connection support is not yet supported for dump/import

Duplicate of bug #59249