When I say it dropped rows I mean that about 40 million rows never made it to the myisam db.
count(*) doesn’t match on both db’s.
I’m doing it through php right now by selecting one row at a time and inserting it. Should only take me 24 hours or so assuming it works.
With regards to the same charset, I tried it with the same charset and without to no avail.
I’m hopeful that going through php and doing it one select/insert at a time will work even if it is a bit slower )