Restore and character error ! Urgent ! Please help , MySql 4.1.12

[Ken Nguyen]

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.