Backing up MySQL using PHPMyAdmin problem with UTF-8

--20cf3005dd8acb60f40492909c0c
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

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 ăÿć e=
tc 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

--20cf3005dd8acb60f40492909c0c--

Re: Backing up MySQL using PHPMyAdmin problem with UTF-8

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
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 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 ăÿć=
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
>



--=20
 - michael dykman
 - mdykman@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=3Dgcdmg-mysql-2@m.gmane.o rg

Re: Backing up MySQL using PHPMyAdmin problem with UTF-8

--0016364ec9bcd5c52c0492a49cfe
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Oh this isn't good. Because the database in on a shared server and I don't
think I've got console access ?

On Thu, Oct 14, 2010 at 6:56 PM, Michael Dykman wrote:

> 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
> 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 ăÿÄ=
=87 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
> - mdykman@gmail.com
>
> May the Source be with you.
>

--0016364ec9bcd5c52c0492a49cfe--

Re: Backing up MySQL using PHPMyAdmin problem with UTF-8

--0015175cb8386d03bc0492a530ac
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

I managed to use the older version of MySQL Administrator 1.2.15 and it
appears to back up find using InnoDB online backup.


On Thu, Oct 14, 2010 at 6:56 PM, Michael Dykman wrote:

> 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
> 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 ăÿÄ=
=87 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
> - mdykman@gmail.com
>
> May the Source be with you.
>

--0015175cb8386d03bc0492a530ac--

Fwd: Backing up MySQL using PHPMyAdmin problem with UTF-8

--001636427152e9b7e80492e04e60
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

MySQL Administrator 1.2.15 is fails with the same problem. Do anyone have
any other suggestions ?

---------- Forwarded message ----------
From: Tompkins Neil
Date: Fri, Oct 15, 2010 at 11:21 AM
Subject: Re: Backing up MySQL using PHPMyAdmin problem with UTF-8
To: Michael Dykman
Cc: "[MySQL]"


I managed to use the older version of MySQL Administrator 1.2.15 and it
appears to back up find using InnoDB online backup.


On Thu, Oct 14, 2010 at 6:56 PM, Michael Dykman wrote:

> 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
> 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 ăÿÄ=
=87 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
> - mdykman@gmail.com
>
> May the Source be with you.
>

--001636427152e9b7e80492e04e60--