Hello.
You may use --default-character-set=charset command line option
for mysqldump. Without this option mysqldump uses UTF8 encoding,
which can cause a problem.
See:
http://dev.mysql.com/doc/mysql/en/mysqldump.html
Javier Ballesteros Correa [EMAIL PROTECTED] wrote:
Hi! I'm learning mysql and I have a problem when i
make a full backup with mysqldump.
I have a lot of table rows written in spanish. In
the backup file (.sql) I have problems with certain
spanish characters like:
? -- ?i
? -- ?¿
? -- ?-
? -- ??
and so many others like that.
However, when I make an incremental backup with the
*.bin-* files I don't have this problem.
I use MySQL 4.1.X with the default character
set(latin1) and the default collation
(latin1_swedish_ci). I?ve tried with the
latin1_spanish_ci and with another character set (utf8
with the utf8_spanish_ci collation). But the problem
doesn?t disappear.
Can anybody help me? Thank you very much.
__
Renovamos el Correo Yahoo!: ?250 MB GRATIS!
Nuevos servicios, m?s seguridad
http://correo.yahoo.es
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]