Once time I needed to dump a database from mysql 4 to mysql 5. First, I tried phpmyadmin’s backup, but it doesn’t suport charset configuration. And, now? Who will help us? Mysqldump will. The command line is:
mysqldump –user=USER –password=PASSWORD –set-charset=CHARSET –default-character-set=CHARSET DATABASE
Replace CHARSET for the charset that you want.
