Hello!

I have almost the same problem with a MySQL-conversion as Howard described in a posting to this mailing list a week ago (see below)...

I have a database that has been downloaded from a Linux 2.2.x running MySQL 3.22.x. I want to use the database on a machine running Windows 2000 with MySQL 3.23.27-beta. The problem is that I can "select" data from all tables that do NOT have columns with some sort of text-type (for example varchar). Tables that only have integer-data can be shown without any problem. A "select *" from a table conatining a column with varchar-data results in a empty set although there is a lot of data in the table.

I guess this is probably a line feed/newline problem, or is it because version difference?

Is there a way to fix this and get the database running under Windows without having to do a SQL-dump?

Best Regards

Kristian

kris...@intelliplan.se

------------

I have a database which was downloaded from a linux machine running 3.22.23b to a win98 machine running 3.23.25-BETA. I can "use" the database and "show" tables and "show" columns but "select *" from any of the tables results in an empty set. Is the version difference the problem or am I missing something. I'm new to mysql. Thanks, Howard hcoo...@coopasso.com