| Bug #54067 | Unable to export database with MySQL workbench | ||
|---|---|---|---|
| Submitted: | 28 May 2010 14:24 | Modified: | 11 Jun 2010 10:57 |
| Reporter: | Jean Bonnot | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Workbench: Administration | Severity: | S3 (Non-critical) |
| Version: | 5.2.21, 5.2.22 | OS: | Windows (XP x86) |
| Assigned to: | Mike Lischke | CPU Architecture: | Any |
| Tags: | workbench win32 exports database sql script wb_admin_export.py | ||
[4 Jun 2010 8:00]
Susanne Ebrecht
Verified by looking into the source code. Quotes are missing there.
[4 Jun 2010 9:11]
Mike Lischke
Fixed in repository, thanks for the patch.
[4 Jun 2010 17:48]
Johannes Taxacher
fix confirmed in repository
[11 Jun 2010 10:57]
Tony Bedford
An entry has been added to the 5.2.23 changelog: Export of database failed due to a faulty path in the command line: 15:42:52 Dumping rma3 (etat_produit) Running: "mysqldump.exe" --defaults-extra-file=c:\docume~1\user\local settings\temp\tmp9ypdhd --no-create-info=FALSE --order-by-primary=FALSE --force=FALSE --no-data=FALSE --tz-utc=TRUE --flush-privileges=FALSE --compress=FALSE --replace=FALSE --host=127.0.0.1 --insert-ignore=FALSE --extended-insert=TRUE --user=root --quote-names=TRUE --hex-blob=FALSE --complete-insert=FALSE --add-locks=TRUE --port=3306 --disable-keys=TRUE --delayed-insert=FALSE --delete-master-logs=FALSE --comments=TRUE --default-character-set=utf8 --flush-logs=FALSE --dump-date=TRUE --allow-keywords=FALSE --create-options=TRUE --events=FALSE "rma3" "etat_produit" Could not open required defaults file: c:\docume~1\user\local Fatal error in defaults handling. Program aborted mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect Operation failed with exitcode 2
Description: Unable to export database with workbench due to a faulty path in command line. Log dump: [code] 15:42:52 Dumping rma3 (etat_produit) Running: "mysqldump.exe" --defaults-extra-file=c:\docume~1\user\local settings\temp\tmp9ypdhd --no-create-info=FALSE --order-by-primary=FALSE --force=FALSE --no-data=FALSE --tz-utc=TRUE --flush-privileges=FALSE --compress=FALSE --replace=FALSE --host=127.0.0.1 --insert-ignore=FALSE --extended-insert=TRUE --user=root --quote-names=TRUE --hex-blob=FALSE --complete-insert=FALSE --add-locks=TRUE --port=3306 --disable-keys=TRUE --delayed-insert=FALSE --delete-master-logs=FALSE --comments=TRUE --default-character-set=utf8 --flush-logs=FALSE --dump-date=TRUE --allow-keywords=FALSE --create-options=TRUE --events=FALSE "rma3" "etat_produit" Could not open required defaults file: c:\docume~1\user\local Fatal error in defaults handling. Program aborted mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect Operation failed with exitcode 2 [/code] How to repeat: juste try to export with "Data Dump" functionality Suggested fix: Solved by moding the script wb_admin_export.py line 90: logstr += "--defaults-extra-file=" + pwdfilename + " " replace by: logstr += "--defaults-extra-file=\"" + pwdfilename + "\" "