Migration from 4.1 to 5.0 version issue

[Manuel Alejandro Ramos]

I need to move my database from one server to another. This implicates moving from version 4.1 to version 5.0 in linux.

I already did a MySQL Dump with the SQLyog tool, and restored the database on the new server, but I got this issue:

In the server with the version 4.1, I got no problem to consult my database. But in the new server the language doesn't correspond to the original. I got the charset=latin1, but this send me an error about SQL syntax error, How should I define this part??, I have reviewed the manual and it declares it as charset=language.

Finally, in my table I got a longblob column, where I store images. Those images are lost when I export the database, how can I accomplish that??

Thanks in advance!!



Edited 1 time(s). Last edit at 11/26/2007 09:16AM by Manuel Alejandro Ramos.