Utf-8 encoding problem with MySQL restore
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
Technorati Tags: mysql, database, restore, utf8, encoding, unicode
Other similar posts that you might be interested in:
- Framebar (like diggbar) example in html and css with no javascript
- Code to embed Google Map and Street View
- Display a download dialog for pdf in PHP
- Embed a YouTube video iframe in a phonegap app
- 15 tips on optimising MySQL databases and MySQL queries
- How to ‘Post on Facebook Wall’ on iPhone and Android using PhoneGap plugins
- Sun acquired MySQL for $1 billion
Hello! Welcome to Web development blog! My name is Ei Sabai and on this blog, I write about web development, mobile app development, latest web technologies and the likes. Read more 
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