Problem in backing and restoring WordPress database

[selfwebhosting]

I find a problem with DA's backup of my non-English WordPress MySQL database. Basically the backup corrupted the non-English characters - in my case it is the Chinese Simplified characters. I have to use phpMyAdmin to manually do both the backup and restore. Click here to see the details of my problems.

Hopefully you have a better solution

 

[rtaylor]

I can confirm this. Any possible solutions?

 

[DirectAdmin Support]

Hello,

I can't really comment on a fix, as I have no experience with any foreign character sets, but this is the code used to backup and restore databases in DA:

Backup:
mysqldump -u[B]da_admin[/B] -p[B]pass[/B] --host=[B]localhost[/B] --add-drop-table --all --extended-insert --quick --quote-names --no-create-db [B]databasename[/B] > [B]/path/file[/B].sql

Restore:
mysql -e "source [B]/path/to/db[/B].sql" --password='[B]pass[/B]' --user=[B]username[/B] --host=[B]localhost[/B] [B]databasename[/B]

if anyone see's any issues or changes with this command that would help, let me know.

Apart from that.. it there is a "default_charset" option that can be set in the /etc/my.cnf ... perhaps change that to see if it helps any.

John