phpMyAdmin - Export & Import

Discussion in 'Databases' started by edhan, Sep 24, 2007.

  1. #1
    Hi

    Changing new Server so I am exporting existing database (containing different languages format - chinese, japanese, etc). Using phpMyAdmin to export as SQL and save as myfile.sql.

    After I have exported, I go to my new Server to use phpMyAdmin to import the database - myfile.sql with the charset as UTF-8.

    When I finished importing, I check my new site but discover that all other languages are showing as garbage except the standard English.

    I did experiment it with importing as Latin-1 and it still shows garbage but when I copied the html source code and ran it on my local computer, it is showing correctly. But in the website, it is showing as garbage.

    I have already set my html as:

    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

    Appreciate if anyone can let me know how I can resolve this?

    Thank you.
     
    edhan, Sep 24, 2007 IP