MySQL Workbench Migration Wizard python error

Question

There are two bugs in bugs.mysql.com related to this same error (1 and 2). They either provide no solution (#2) or a replacement of the .py that does not solve the problem (#1).

The error:

File "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mysql_re_grt.py", line 288, in wrap_routine_sql

return "DELIMITER $$\n"+sql

TypeError: cannot concatenate 'str' and 'NoneType' objects

So: the line "DELIMITER $$\n"+sql produces the error cannot concatenate 'str' and 'NoneType' objects.

The error is in the line 288 of the file db_mysql_re_grt.py. This is the original .py file from the mysql-workbench's github.

The call to wrap_routine_sql comes from this other line:

sql = result.stringByName("Create Procedure")
grt.begin_progress_step(0.1 + 0.9 * (i / total), 0.1 + 0.9 * ((i+0.5) / total))
grt.modules.MySQLParserServices.parseSQLIntoCatalogSql(context, catalog, wrap_sql(wrap_routine_sql(sql), schema_name), options)
grt.end_progress_step()
i += 0.5

looks like `sql` is `None` - the question is why? Can you please extract minimum subset of your db that issue can be reproduced and show it here? Aleternativly you can fill a bug report at bugs.mysql.com and attach your db privately. — Miłosz Bodzek, Jul 25 '16 at 09:57

score 0 · Answer 1 · edited May 23 '17 at 12:32

(not exactly a fix, but an alternative way to circumvent the error in my own question)

An alternative to the migration is: dump source to files -> import dump to destination db.

From the original info, the steps are:

Open MySQL Workbench
Open source db
Server -> Data Export
Open destination db
Create schema (the import does not create the schema for you)
Server -> Data Import

In case of error “Error querying security information” on Data Export, the solution proposed here was to download the version 6.3.7 of the Workbench (and it worked).

MySQL Workbench Migration Wizard python error

1 Answers1