mysql db restore problem

mysql db restore problem

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:

Re: mysql db restore problem

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

Re: mysql db restore problem

Posted by: Eli Baskin
Posted on: 2007-01-03 14:32:00

Is there a way to convert to UTF?

Re: mysql db restore problem

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

Re: mysql db restore problem

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.

Re: mysql db restore problem

Posted by: sdayman
Posted on: 2007-01-04 05:45:00

I'm glad it finally worked out.

-Scott

Re: mysql db restore problem

Posted by: Eli Baskin
Posted on: 2007-01-04 09:17:00

Thank you very much for your help!!!

Tags: sql syntaxsyntax checkgodaddydreamhostweb interfacemysql servermysql dbserver versionline 1sshcomputer