I just wanted to add that when I created the same database with -E
SQL_ASCII on my linux box, the dump was loaded fine. I created another
database without -E and observed the same invalid encoding problem.
On the face value this seems to solve the problem at least superficially.
I'd like to check the data validity, and the easiest way seems to be to
dump the data again from the linux box and compare with the original.
Is there a way to compare between any two databases online? (like running
a script checking row counts and schema) If I run crc on the concat of all
fields in a row, and if the crc matches, would it be reasonably
sufficient? Is there a stronger validation method?
Thanks.
Ben K.
Developer
http://benix.tamu.edu