Can't move data from 1 DB to another

[EdLentz]

I have two servers that are running linux with a MySql DB running on each. The old server is running MySql 4.0.20 and the new one is running MySql 4.1.12. What I am trying to do is move all the data from the old to the new. So here is what I have done so far. I used phpmyadmin to dump the data and structure and used it to rebuild the new db. Most all things went alright except for some float fields. Some data that should be 18.75 is 9.99. I have tried to use SQLyog enterprise (trial edition) and got the same results. I look at the structure of the table and in both the DBs it is the same, it is the data that is messed up. Is this a difference in the two MySql versions, and if so how can I fix this?

Thanks

 

[strucnjak79]

Very strange, check source of exported sql files to check are they OK... I mean values in sql files!

 

[EdLentz]

Yeah it is wierd. I will check out one of the Sql files and report back

 

[EdLentz]

Yup the sql file has all the correct information. Anyone else see this before???

Thanks

 

[EdLentz]

I think I figured it out. The old fields in the original database were float 3,2 the info that got screwed up was an entry like 18.75 transformed into 9.99. I changed the new field to float 8,2 just for grins and all the data was inserted just fine. I did need to use the sql code that was generated by the old system, I just changed a couple of those field float values and it all went fine.

Thanks for looking.