Ok, here is a brief description of a problem that has been troubling me for almost a week now. I've been contacting powweb's support but no one seems to be interested in my problem so I come to seek your advice:
I want a copy of one of my mySQL databases which contains Chinese data. And the dump generated using powweb's phpMyAdmin sucks -- all the Chinese data are messed up. I'm quite sure my data are encoded in utf8 (as WordPress can read and display them correctly) but powweb's phpMyAdmin split my utf8 data into some monster latin1 characters which cannot be converted back.
I tried so many tricks and none works. The closest solution is to use a hacked phpMyAdmin (in which the MySQL charset setting is changed to 'latin1' and installed on my own webspace). I can read all my Chinese data properly using this hacked phpMyAdmin, but when I try to export my database, I get this error message:
export.php: Missing parameter: what (FAQ 2.8)
export.php: Missing parameter: export_type (FAQ 2.8)
The FAQ in the documentation of phpMyAdmin doesn't seem to address my problem as my setting is pretty much a default setting. I wonder if it's a server side problem/ permission?
Have you ever tried to install phpMyAdmin on your own space? If so, can you connect remotely to and properly with powweb's mySQL databases? Any suggestion to solve this? Your advice would be much appreciated. Thanks.
P.S. If you think I should post this thread to the PHP forum, please let me know.