Jump to content
xisto Community
Sign in to follow this  
j-s

Mysql Db Restore Problem

Recommended Posts

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.

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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 by j-s (see edit history)

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.