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]
