Migration of an MySQL Database

Hello,

I have a database on my server with InnoDB and MyISAM engine for
differents tables and data are stored for a part of table in UTF-8 and
for other in ISO 8859-15. I want to copy the database on the server to
my computer and to an other server. I test with PhpMyAdmin but I have
problem with french caracter.

Someone could help me ?
Thank's in advance.

Arno wrote:
> Hello,
>
> I have a database on my server with InnoDB and MyISAM engine for
> differents tables and data are stored for a part of table in UTF-8 and
> for other in ISO 8859-15. I want to copy the database on the server to
> my computer and to an other server. I test with PhpMyAdmin but I have
> problem with french caracter.
>
> Someone could help me ?
> Thank's in advance.
>

mysqldump.

Or check the connection charset with PHPMyAdmin.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

On 29 fév, 02:10, Jerry Stuckle <jstuck...@attglobal.net> wrote:
> Arno wrote:
> > Hello,
>
> > I have a database on my server with InnoDB and MyISAM engine for
> > differents tables and data are stored for a part of table in UTF-8 and
> > for other in ISO 8859-15. I want to copy the database on the server to
> > my computer and to an other server. I test with PhpMyAdmin but I have
> > problem with french caracter.
>
> > Someone could help me ?
> > Thank's in advance.
>
> mysqldump.
>
> Or check the connection charset with PHPMyAdmin.
>

It's possible to export data like binary field with mysqldump ?
Because if I select UTF8, I have pb with ISO 8859-15 and if I select
ISO 8859-15, I have pb with UTF8

Arno wrote:
>
> On 29 fév, 02:10, Jerry Stuckle <jstuck...@attglobal.net> wrote:
>> Arno wrote:
>>> Hello,
>>> I have a database on my server with InnoDB and MyISAM engine for
>>> differents tables and data are stored for a part of table in UTF-8 and
>>> for other in ISO 8859-15. I want to copy the database on the server to
>>> my computer and to an other server. I test with PhpMyAdmin but I have
>>> problem with french caracter.
>>> Someone could help me ?
>>> Thank's in advance.
>> mysqldump.
>>
>> Or check the connection charset with PHPMyAdmin.
>>
>
> It's possible to export data like binary field with mysqldump ?
> Because if I select UTF8, I have pb with ISO 8859-15 and if I select
> ISO 8859-15, I have pb with UTF8
>

Did you look at the MySQL documentation?

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================