Re: Help! Japanese text garbled in backups! [SOLUTION]

[jefurii]

The problem was that mysqldump for 4.1 was encoding everything in utf-8. The tables in the database are still in latin1, so when they were backed up they received an extra layer of encoding, which garbled the Japanese text.

The solution was to force mysqldump to use latin1 encoding. I also read somewhere in the forums or in the docs that the '>' redirect (mysqldump ... > dumpfile.sql) affected encoding, so I'm now using the -r option.

These options seem to work:

$ mysqldump -p -u root --default-character-set=latin1 -r dumpfile.sql databasename