When under 5.0 you need to export your data doing a character set translation to latin1 or iso-8859-1. You also need to adjust the export for compatibilty with older versions (some SQL verbs used in 5.0 are not understood by older versions)
Jacques Brignon You can do that either with mysqldump or the lates versions of phpmyadmin Selon Sandeep Raul <[EMAIL PROTECTED]>: > Hi, > > Need your help in restoring mysqldump from version 4.1 to 5.0 > > We wanted to update our mysql server from version 4.1.0 to version 5.0, we > took the mysqldump and upgraded it to version 5.0. But, when we tried to > restored the database dump, it just cannot restore it back. > > We searched on the net and came to know that the problem could be of > character set, something we need to change from latin1 to utf8. We tried all > possible solutions from various links, but still the problem persist. > > It would be really great of you, if you could help us out in this problem. > > Awaiting for the reply. > > > > > Regards, > Sandeep Raul > -- Jacques Brignon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]