Migration Error - Unable to reverse engineer

[Steven Wheeler]

Hi All,

Please bear with me, I'm rather new to all of this... Its a learning curve I've just started.

I'm trying to migrate a rather large table (~5gb) from a live production server to my test box. Every table on the database will migrate fine apart from one. Error from message log is as follows:

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)


I've tried to repair the table but to no avail... It was a full 12 hour reindex/rebuild.
It was migrating once before, but the target ran out of space and since I've never been able to get it running again. I have tried to do a manual backup and then restore on the test server but it also failed.

Any ideas would be greatly appreciated.
Thanks!

Steve