How to Copy InnoDB from Linux to Windows

[bahakh]

I am trying to copy an InnoDB Database (mysql) from a linux system to a Windows XP machine.. I copied the files under /mysql/data/mydatabase/ files to the same one on my windows machine, and I copied anotehr 3 files from the the /data folder which I read about in mysql.com (indata1, and two log files)...

All the database worked expect for the child tables (that has relation with other tables)..

Did I do anything wrong, or is there another way to transfer the database..

Thanks Alot,
Baha

 

[Bastien]

Are there floats or double data types in those columns?

Try mysql dumping those tables and importing the dumps

Bastien

Cat, the other other white meat