Troubleshooting

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

[tags]mysql, database, restore, utf8, encoding, unicode[/tags]

One thought on “Utf-8 encoding problem with MySQL restore

  1. 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

Comments are closed.