From: Michael Dykman
Date: October 14 2010 5:56pm
Subject: Re: Backing up MySQL using PHPMyAdmin problem with UTF-8
List-Archive: http://lists.mysql.com/mysql/223332
Message-Id: <AANLkTim2hUptdNr5V35jNZT+sKLBYEhCmYnBi1UxZ=2t@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

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.tompkins@stripped> wrote:
> Hi,
>
> I'm using PHP MyAdmin to backup my MySQL database. =C2=A0The database is =
of
> type InnoDB
> and encoding used is utf8_unicode_ci. =C2=A0The variables are set as foll=
ows :
>
> *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 =C4=83=C3=BF=C4=87=
 etc are being
> backed up as scrambled non-readable characters. =C2=A0Any ideas why this =
is
> happening ?? =C2=A0Are there any other variables I need to check/set ?
>
> Cheers
> Neil
>



--=20
=C2=A0- michael dykman
=C2=A0- mdykman@stripped

=C2=A0May the Source be with you.