Mysql db restore problem

wordpress

#1

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:

[smoothie]$ ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ן»�

It happens with both ssh and web interface. Any help?


#2

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


#3

Is there a way to convert to UTF?


#4

One of the results on that Google search was called Converting MySQL Database to UTF-8.

-Scott


#5

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.


#6

I’m glad it finally worked out.

-Scott


#7

Thank you very much for your help!!!