Mysql Db Restore Problem

[j-s 0]

Hi!I backed-up a forum mysql db and when I try to restore it on another host, the special characters, like the French " ? " or " ? " are replaced with weird characters like "A?~" or question marks. And in the .sql file too the characters are "corrupted". The current charset was latin1-sweedish-ci if I remember it well... (my host on which i had the database is currently down )I know it's about Character encoding and things like that but I can't figure things out.Could someone help me?Thanks in advance.

[jlhaslip 4]

Is it possible to use something like phpadmin at the other Host?It may be required to drop the DB and perform another backup and change the encoding before re-loading the data?

[j-s 0]

Yeah I'm on PHPMyAdmin on both hosts...I backep-up the DB from the CPanel of my first host, then tried to restore it thrgough the PHPMyAdmin of my second host.Could it be the problem?

[jlhaslip 4]

When the backup was done did you backup the 'structure' of the database?I think it is default on phpadmin to save the structure.There will be mysql commands at the front of the backup file which you should be able to modify the settings of the database tables before you re-store the DB on the new host to match the settings from the previous Host?

[CrazyRob 0]

You could try changing the charset in PHPMyAdmin or maby your host does not support the language your using.

[j-s 0]

Well loll seems like it works now...I changed everything I saw was not UTF-8 to UTF-8 in my PHPMyAdmin because I kno my eb apps use UTF-8 character encoding...Thanks anyways.Edit: Oh and I used Import in PHPMyAdmin to restore the DB instead of copying and pasting the file contents like I did the first time... Could have this helped?

Edited September 27, 2006 by j-s (see edit history)

[jlhaslip 4]

Edit: Oh and I used Import in PHPMyAdmin to restore the DB instead of copying and pasting the file contents like I did the first time... Could have this helped?

very definately it could've made a difference, yes.