Restore and character error ! Urgent ! Please help , MySql 4.1.12
Posted by: Ken Nguyen
Date: May 16, 2006 04:44PM

Hello
Last week my server crash and need to reload OS , i backup my database via mysqldump --u --p data > data.sql . And today my server up online, i'v tried to restore my database via command : mysql --u --p data < data.sql but there are some big problem, a lot of word in my forum become something strange. It got charset error . :( . We are using UTF-8 . This is what i got in my backup.sql :
...
ENGINE=MyISAM DEFAULT CHARSET=latin1;
...
/*!40101 SET NAMES utf8 */;
...

So what i should do now ? My server reload so i have nothing now. Only a backup last week.

Regards,
Ken.



Edited 2 time(s). Last edit at 05/16/2006 04:57PM by Ken Nguyen.

Options: ReplyQuote


Subject
Views
Written By
Posted
Restore and character error ! Urgent ! Please help , MySql 4.1.12
2276
May 16, 2006 04:44PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.