Sorry for the delay in the response and thank for you for your assistance. My answers are listed below.
* Program (SQLyog) version (version 5.0)
* MySQL server version(s) (version 5.0)
* Connection type (direct, HTTP or SSH tunnelling) (direct)
* Storage engine(s) – especially when not MyISAM (had similar problem with both MyIsam and InnoDb)
* The platform on which the server runs (WinXP pro)
* Any unusual server configuration (be that a special character set, ANSI-mode or whatever). ( Nothing that I can identify)
I am not sure of the original database manager for the data … I 'suspect' it is Oracle.
On further testing, I can get a reproducible error (similar halt in execution) in one of the tables after about 6 million records imported (out of a little over 9 milliion). When I import directly from the data files (ie within SQLyog), the entire table imports without difficulty.
I would prefer to use the migration tool kit because:
1. I have about 20 CSV tables to import at a time. (and done monthly)
2. On occasion, the data structure may change and I do not necessarily get advance notice. I like how SQLyog migration toolkit maps data and allows modification.
I could send a screen dump, but it really does not list anything except the listing of records imported stopping at about 6 million, and the next button being enabled.
Thanks again for the assistance!!!
