Posted by: Eli Baskin
Posted on: 2007-01-03 11:03:00
I just moved from godaddy.com, and backed up my db to an sql file on my computer.
I am trying to restore this db to dreamhost. I have created the database with the same name, but when I try to import the data, I get the following message:
Posted by: sdayman
Posted on: 2007-01-03 11:35:00
I would guess that your old database wasn't in UTF format for the foreign characters. A Google search led me to this, but I don't know if it'll help:
Google Search
-Scott
Posted by: Eli Baskin
Posted on: 2007-01-03 14:32:00
Is there a way to convert to UTF?
Posted by: sdayman
Posted on: 2007-01-03 14:53:00
One of the results on that Google search was called Converting MySQL Database to UTF-8.
-Scott
Posted by: Eli Baskin
Posted on: 2007-01-04 02:38:00
In the end it didn't help me, so I had to upload the whole DB via SQL query, one statement at a time. Took me about 20 minutes.
In addition, I had to add
mysql_query("SET NAMES 'utf8'");
as they suggested on wordpress forum.
Posted by: sdayman
Posted on: 2007-01-04 05:45:00
I'm glad it finally worked out.
-Scott
Posted by: Eli Baskin
Posted on: 2007-01-04 09:17:00
Thank you very much for your help!!!