Trying to migrate from MySQL v4.0 -> v5.0 - Errors.

[Ian Tuck]

Hi there, I'm undertaking a migration of our databases from v4.0 to v5.x using the migration toolkit.

When I run the migration tool, I get two different sets of errors.

The first is "display width out of range for column 'XXXXX' (max=255). I get a number of these. This means that the target tables are not created at all.

the second is that I get a javaHeap error that seems to indicate the heap is too small.

Finally, I can't find anywhere what the AddAutoIncrement parameter does when migrating - A search of that term on the entire MySQL site comes up empty.

EDIT: I should mention I'm attempting to update a MyISAM to a MyISAM database.

Thanks.
Ian



Edited 1 time(s). Last edit at 04/03/2006 07:58PM by Ian Tuck.