I have had this problem with PHPMyAdmin many times, and the only way I know around it, is to go in and do your dump at the console. PHP does not deal with UTF very well.
- michael dykman On Thu, Oct 14, 2010 at 5:48 AM, Tompkins Neil <neil.tompk...@googlemail.com> wrote: > Hi, > > I'm using PHP MyAdmin to backup my MySQL database. The database is of > type InnoDB > and encoding used is utf8_unicode_ci. The variables are set as follows : > > *MySQL connection collation: **utf8_unicode_ci* > *MySQL charset: **UTF-8 Unicode (utf8)* > *character set client: utf8* > *character set connection: utf8* > *character set results: utf8* > *collation connection: **utf8_unicode_ci* > > The problem I have is that the foreign characters like ăÿć etc are being > backed up as scrambled non-readable characters. Any ideas why this is > happening ?? Are there any other variables I need to check/set ? > > Cheers > Neil > -- - michael dykman - mdyk...@gmail.com May the Source be with you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org