Hey guys. I have a problem with a mysql database for a website. This site is using diacritics (like ă, â, î, ş, etc.) since it's in Romanian, and everything was working fine till it was time to change the host. The admin exported the database (either from cpanel or from phpmyadmin, I don't know exactly) and all the files, but when he imported it to the new sql server, every character on the website was messed up, instead of diacritics it shows weird characters (like ă instead of ă). I thought it was a collation problem (if I open the exported database it says latin1_general_ci), but no matter what I choose, it doesn't fix it. I also tried importing the file via Bigdump, no luck... Is there anything else I can do? There is a LOT of text and manually changing it to the right way is really out of the question... Oh yeah, and there's no access to the original host anymore, so there's nothing I can try there...
Question
TDT
Hey guys. I have a problem with a mysql database for a website. This site is using diacritics (like ă, â, î, ş, etc.) since it's in Romanian, and everything was working fine till it was time to change the host. The admin exported the database (either from cpanel or from phpmyadmin, I don't know exactly) and all the files, but when he imported it to the new sql server, every character on the website was messed up, instead of diacritics it shows weird characters (like ă instead of ă). I thought it was a collation problem (if I open the exported database it says latin1_general_ci), but no matter what I choose, it doesn't fix it. I also tried importing the file via Bigdump, no luck... Is there anything else I can do? There is a LOT of text and manually changing it to the right way is really out of the question... Oh yeah, and there's no access to the original host anymore, so there's nothing I can try there...
Link to comment
https://www.neowin.net/forum/topic/1269048-mysql-database-messed-up/Share on other sites
1 answer to this question
Recommended Posts