Bug #59730 Wrong parameter for mysqldump in MySQL Workbench under Mac OS X
Submitted: 25 Jan 2011 22:05 Modified: 16 May 2011 19:07
Reporter: Egor Ushakov Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: Administration Severity:S3 (Non-critical)
Version:5.2.31 OS:MacOS (10.5.x, 10.6.6)
Assigned to: CPU Architecture:Any
Tags: mysqldump, pipe, protocol, socket

[25 Jan 2011 22:05] Egor Ushakov
Description:
MySQL Workbench 5.2.31 Revision 7115 under Mac OS X 10.6.6
No possibility to use Server Administration - Data Dump - Export to Disk because of wrong --protocol=PIPE parameter passed to bundled mysqldump utility

How to repeat:
Chose any scheme and try to export it to disk. You'll see in log window the following output:

01:02:42 Dumping medpred-DEVEL (tasks, contacts_users, securitygroups_records, campaigns_audit, meetings, roles_users, drnt_visitreportsnumbers_cstm, email_addr_bean_rel, securitygroups_message, accounts_cstm, accounts, projects_opportunities, saved_search, drnt_visitreportsnumbers, meetings_cstm, relationships, drnt_visittopics, user_preferences, project_task_audit, accounts_opportunities, folders_subscriptions, contacts_cases, users_password_link, prospect_list_campaigns, emails_email_addr_rel, opportunities, emails, calls_contacts, calls_leads, securitygroups_default, acl_actions, email_cache, drnt_visitreports_audit, email_addresses, roles_modules, releases, accounts_bugs, schedulers, contacts_bugs, schedulers_times, leads_audit, accounts_cases, email_marketing, address_book, fields_meta_data, project_task, meetings_contacts, leads, bugs_audit, meetings_users, roles, email_templates, prospect_lists, notes, versions, opportunities_contacts, project, accounts_audit, projects_bugs, inbound_email_autoreply, meetings_leads, document_revisions, emails_beans, drnt_visitreports_cstm, acl_roles_users, projects_contacts, folders_rel, drnt_visittopics_audit, acl_roles_actions, campaign_log, securitygroups_audit, sugarfeed, calls_users, campaign_trkrs, projects_products, upgrade_history, drnt_visitreports, custom_fields, emails_text, documents, linked_documents, contacts_audit, contacts, import_maps, meetings_drportsnumbers_c, emailman, projects_accounts, tracker, securitygroups, users_last_import, meetings_drvisitreports_c, outbound_email, config, users_feeds, folders, currencies, users, inbound_email_cache_ts, drnt_visitreportsnumbers_audit, email_marketing_prospect_lists, campaigns, meetings_dr_visittopics_c, projects_cases, securitygroups_acl_roles, cases, contacts_cstm, prospects, calls, vcals, securitygroups_users, opportunities_audit, bugs, cases_audit, prospect_lists_prospects, acl_roles, accounts_contacts, users_signatures, inbound_email, cases_bugs, drnt_visittopics_cstm)
Running: "/Applications/MySQLWorkbench.app/Contents/Resources/mysqldump" --defaults-extra-file="/var/folders/5u/5uxza8KZEI4SqW0XFb4x0k+++TI/-Tmp-/tmpmsRygN/extraparams"  --no-create-info=FALSE --order-by-primary=FALSE --protocol=pipe --no-data=FALSE --tz-utc=TRUE --flush-privileges=FALSE --compress=FALSE --replace=FALSE --insert-ignore=FALSE --extended-insert=TRUE --user=root --hex-blob=FALSE --quote-names=TRUE --force=FALSE --complete-insert=FALSE --add-locks=TRUE --allow-keywords=FALSE --disable-keys=TRUE --delayed-insert=FALSE --socket= --delete-master-logs=FALSE --comments=TRUE --default-character-set=utf8 --max_allowed_packet=1G --flush-logs=FALSE --dump-date=TRUE --lock-tables=TRUE --create-options=TRUE --events=FALSE "medpred-DEVEL" "tasks" "contacts_users" "securitygroups_records" "campaigns_audit" "meetings" "roles_users" "drnt_visitreportsnumbers_cstm" "email_addr_bean_rel" "securitygroups_message" "accounts_cstm" "accounts" "projects_opportunities" "saved_search" "drnt_visitreportsnumbers" "meetings_cstm" "relationships" "drnt_visittopics" "user_preferences" "project_task_audit" "accounts_opportunities" "folders_subscriptions" "contacts_cases" "users_password_link" "prospect_list_campaigns" "emails_email_addr_rel" "opportunities" "emails" "calls_contacts" "calls_leads" "securitygroups_default" "acl_actions" "email_cache" "drnt_visitreports_audit" "email_addresses" "roles_modules" "releases" "accounts_bugs" "schedulers" "contacts_bugs" "schedulers_times" "leads_audit" "accounts_cases" "email_marketing" "address_book" "fields_meta_data" "project_task" "meetings_contacts" "leads" "bugs_audit" "meetings_users" "roles" "email_templates" "prospect_lists" "notes" "versions" "opportunities_contacts" "project" "accounts_audit" "projects_bugs" "inbound_email_autoreply" "meetings_leads" "document_revisions" "emails_beans" "drnt_visitreports_cstm" "acl_roles_users" "projects_contacts" "folders_rel" "drnt_visittopics_audit" "acl_roles_actions" "campaign_log" "securitygroups_audit" "sugarfeed" "calls_users" "campaign_trkrs" "projects_products" "upgrade_history" "drnt_visitreports" "custom_fields" "emails_text" "documents" "linked_documents" "contacts_audit" "contacts" "import_maps" "meetings_drportsnumbers_c" "emailman" "projects_accounts" "tracker" "securitygroups" "users_last_import" "meetings_drvisitreports_c" "outbound_email" "config" "users_feeds" "folders" "currencies" "users" "inbound_email_cache_ts" "drnt_visitreportsnumbers_audit" "email_marketing_prospect_lists" "campaigns" "meetings_dr_visittopics_c" "projects_cases" "securitygroups_acl_roles" "cases" "contacts_cstm" "prospects" "calls" "vcals" "securitygroups_users" "opportunities_audit" "bugs" "cases_audit" "prospect_lists_prospects" "acl_roles" "accounts_contacts" "users_signatures" "inbound_email" "cases_bugs" "drnt_visittopics_cstm"
mysqldump: Got error: 2047: Wrong or unknown protocol when trying to connect

Operation failed with exitcode 2
01:02:43 Export of /Users/erop/Documents/adfadf has finished with 1 errors
[25 Jan 2011 22:08] Egor Ushakov
Sorry for not separating tags with commas
[26 Jan 2011 4:18] Valeriy Kravchuk
What exactly do you see in Manage Server Instances > Connection > Connection field for this server instance?
[26 Jan 2011 4:48] Egor Ushakov
Manage Server Instances - Connection - Connection - localhost (default socket/pipe) <Local Socket/Pipe>
[26 Jan 2011 5:04] Egor Ushakov
Data dumping works perfectly when I choose <Standart (TCP/IP)> connection.
[26 Jan 2011 14:35] Valeriy Kravchuk
Verified just as described. Even though I explicitly provided socket path, Workbench still generates --protocol=pipe in the mysqldump command line.
[16 May 2011 19:07] Paul DuBois
Noted in 5.2.34 changelog.

For import and export command operations using a Unix socket file,
Workbench added an incorrect --pipe option to the command.