To resolve Utf-8 encoding problem that you experience when you restore a MySQL database, here is a quick and easy fix.
You will first need to make sure that appropriate encoding/collation (eg: utf8_bin, latin1_swedish_ci, etc) is being used for your database and tables before you attempt the following steps.
1. Open your MySQL dump file in a text editor (eg: Notepad++)
2. Add <meta http-equiv="content-type" content="text/html;charset=utf-8"> at the beginning of the file
3. Save the file as "mysqldump.html"
4. Open mysqldump.html in a web browser (I use Firefox)
5. View source of the file (Shortcut in Firefox: Ctrl+U), and copy the entire content except for the first line <meta http-equiv="content-type" content="text/html;charset=utf-8">
6. Paste it into MySQL query window of your new database (You can use phpMyAdmin's Query Window) and run the queries
[tags]mysql, database, restore, utf8, encoding, unicode[/tags]
Thanks a lot
this works fine on my Indian (Devnagari) fonts also.
but I have some doubts
How could I use this for mysql source command or Restore option for Mysql Administrator Tool