1
mrphilong
Unreadable text in mysql database
  • 2012/11/15 23:33

  • mrphilong

  • Quite a regular

  • Posts: 351

  • Since: 2006/7/14


Due to moving to a new hosting provider, I need to import the database back into my new hoster. After importing text on my new hoster is unreadable and having a look into the database the text is the same.

New hoster:
Text on website: Danh sách di dân theo tay nghề
Text in mysql database: Danh sách di dân theo tay nghề

Old hoster:
Text on website: Danh sách di dân theo tay nghề <<readable and correct!
Text in mysql database: Danh sách di dân theo tay nghề

anyone come across this issue could you please share how to fix it.


2
irmtfan
Re: Unreadable text in mysql database
  • 2012/11/16 3:28

  • irmtfan

  • Module Developer

  • Posts: 3419

  • Since: 2003/12/7


Quote:

anyone come across this issue could you please share how to fix it.

Yes many people have this issue!
you should get the backup with the same collation
for example if it is utf-8 you should not change it to latin1
i dont know how do you get the db backup. but i recommend using cpanel backup.

3
mrphilong
Re: Unreadable text in mysql database
  • 2012/11/21 13:57

  • mrphilong

  • Quite a regular

  • Posts: 351

  • Since: 2006/7/14


For those having the same issue;

Using phpMyAdmin export the tables module by module
1. edit the .sql file with Notepad++
2. copy and convert "Encode to UTF-8 without BOM"
3. paste back in the original file and save.
4. import.

Login

Who's Online

275 user(s) are online (147 user(s) are browsing Support Forums)


Members: 0


Guests: 275


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Mar 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits