MySQL Bugs: #74967: I got an error message when I try to create a database backup

Bug #74967	I got an error message when I try to create a database backup
Submitted:	22 Nov 2014 6:48	Modified:	4 Feb 2015 2:41
Reporter:	Homero Diaz	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	6.2.4	OS:	Linux (Ubuntu 14.04.1 LTS)
Assigned to:		CPU Architecture:	Any
Tags:	WBBugReporter

Description:
The following error message rises when I try to create a database backup by using Management-Data Export:
Error Unhandled exception: 'builtin_function_or_method' object has no attribute '__getitem__'
this error occurs even if you try to backup a single table

How to repeat:
just try to create a database backup by using Management-->Data Export-->Export to dump project folder and select a table
This error rises after clicking the "Start Export" button

Hello Homero Urueta,

Thank you for the report.

Thanks,
Umesh

// WB version and OS details

MySQL Workbench Community (GPL) for Linux/Unix version 6.2.4  revision 12437 build 2426 (64 bit)
Configuration Directory: /home/ushastry/.mysql/workbench
Data Directory: /usr/share/mysql-workbench
Cairo Version: 1.13.1
OS: Linux 3.13.0-39-generic
CPU: Intel(R) Core(TM)2 Duo CPU     E8400  @ 3.00GHz (2992.790MHz) - 2.94GiB RAM
Distribution: Ubuntu 14.04.1 LTS

## Log

Traceback (most recent call last):
  File "/usr/share/mysql-workbench/libraries/workbench/notifications.py", line 31, in _the_observer
    for obs, nam, obj in self.observers:
  File "/usr/lib/mysql-workbench/modules/wb_admin_export.py", line 1712, in start
    args.append['--skip-triggers']
TypeError: 'builtin_function_or_method' object has no attribute '__getitem__'

Screenshot..

Attachment: 74967.png (image/png, text), 120.76 KiB.

I have the same problem. Is there a workaround for migrating the database to a new machine?

This issue is only related to multiple database and the option 'Export to Dump Project Folder'. You still can backup every database in a single sql file by using 'Data Export' -> 'Export to self-contained file' and choosing your databases/tables and options according to your needs

Apparently, as Umesh says, the problem are the brakets on line 1712. 

I changed the line:
args.append['- skip-triggers'] 

by:
args.append('- skip-triggers') 

and it worked.

I also changed the line 1717: args.append ['- no-create-info'] 
by: args.append ('- no-create-info')

I hope might help :)

This bug makes MySQL Workbench 6.2 unusable.

The replacements of the [] with () worked for me, I am on Windows. the file was located at C:\Program Files\MySQL\MySQL Workbench 6.2 CE\modules\wb_admin_export.py

I have the same bug....

I'm having the same issue on OS X Yosemite 10.10.2, but I can't find the file mentioned (wb_admin_export.py), though running a locate command does find it in /Applications/MySQLWorkbench.app/Contents/PlugIns/, but when I try to open it or cd to that directory, it cannot find it. Can anyone point me to the correct path to that file on OS X? That's the only location it finds it in.

Bug #75448 marked as duplicate of this

The same bug here!

Like Cord Slatton-Valle i make some changes in wb_admin_export.py and change the [] to () 

Line 1712 ['skip-triggers'] to ('skip-triggers') 
Line 1715 ['no-create-info'] to ('no-create-info')

The export now is working!

Mac path = / Applications / MySQLWorkbench.app / Contents / Resources / plugins / wb_admin_export.py

Bug #75618 marked as duplicate of this

Same bug here. I also changed the lines:

Line 1712 ['skip-triggers'] to ('skip-triggers') 
Line 1715 ['no-create-info'] to ('no-create-info')

And it worked for me too.

I guess it`s working only for export, but when i try to import that i just exported it give`s me an error

regarding import: They changed the interface somewhat and now you have to click the checkbox for "include create schema" where you did not have to select that before...at least for me this fixes the problems I get trying to import.

Bug #75711 marked as duplicate of this

Posted by developer:
 
Fixed as of the upcoming MySQL Workbench 6.2.5 release, and here's the changelog entry:

Executing "Data Export" against multiple databases with the "Export to
Dump Project Folder" option enabled would fail and generate an unhandled
exception; "Error Unhandled exception: 'builtin_function_or_method' object
has no attribute '__getitem__'". 

As a workaround, an export with the "Export to self-contained file" 
option functioned properly.

Thank you for the bug report.

http://bugs.mysql.com/bug.php?id=75857 marked as duplicate of this one.

Bug #76005 marked as duplicate of this

I can't edit the file that needs to be changed on Windows 8. It says the file is in use.

quick and dirty solution in linux (Mint 17.1), in synaptic completely remove package mysql-workbench-community and then install package mysql-workbench

http://bugs.mysql.com/bug.php?id=76108 marked as duplicate of this one.

Bug #76183 marked as duplicate of this

Bug #76427 marked as duplicate of this

In windows remember that you need to run your text editor as administrator or you will get an error saying that the file is in use.

I also changed the lines:

Line 1712 ['skip-triggers'] to ('skip-triggers') 
Line 1715 ['no-create-info'] to ('no-create-info')

And it worked for me too.

Screenshot of export error

Attachment: mysql_workbench_export_error.jpg (image/jpeg, text), 106.52 KiB.

I'm using Windows 8 with MySQL Workbench 6.3.6 version installed. Everything works fine - server info, select, import, alter table; except "Data Export" option. When I click on "Data Export" button on the left navigation it popup alert error with following message: "An unhandled exception occurred (global name 'self' is not defined). Please refer to the log files for details."