Bug #25437 The schema could not be reverse engineered for MySQL 3.22

• Submitted: 5 Jan 2007 16:40
• Modified: 5 Jan 2007 23:45
• Reporter: Leo Chan
• Status: Unsupported
• Category: MySQL Migration Toolkit
• Severity: S1 (Critical)
• Version: 1.1.8
• OS: Windows (Windoes XP Pro)
• CPU Architecture: Any

[5 Jan 2007 16:40] Leo Chan

Description:
I tried to migrate a database from MySQL 3.22.32-sun-solaris2.7 to MySQL 5.0.27 
Community Server.
I can connect to the server and select the source schemata.
However, when I proceed, it failed with:

The schema could not be reverse engineered (error: 0).
ReverseEngineeringMysqlJdbc.reverseEngineer :The function ReverseEngineeringMysql:reverseEngineer() returned the following error:
Could not execute SHOW CREATE TABLE statement.
Details: 
com.mysql.grt.Grt.callGrtFunction(Unknown Source)
com.mysql.grt.modules.ReverseEngineeringMysqlJdbc.reverseEngineer(ReverseEngineeringMysqlJdbc.java:87)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
com.mysql.grt.Grt.callModuleFunction(Unknown Source)

How to repeat:
In MySQL Migration Toolkit,
Configuration Type select Direct Migration

Source Database Connection is MySQL Server and set the connection to the MySQL 3.22.32-sun-solaris server

target Database Connection is MySQL Server and set the connection to the MySQL 5.0.27 Community Server for Windows

after connecting to both servers, select the source schemata to be migrated.

Then reverse engineering will fail.

[5 Jan 2007 23:45] MySQL Verification Team

Thank you for the bug report. Sorry but the server version 3.22.32
doesn't support the SHOW CREATE TABLE statement (it was implemented
since 3.23.20) and for this reason you got the error message mentioned.