Re: mysqldump character set
If you create all your databases and tables with utf8,then every thing is fine. On Mon, Apr 28, 2008 at 1:43 AM, Velen [EMAIL PROTECTED] wrote: Hi, I'm storing some ascii codes in a table. When I do a dump using mysqldump from the server and then restoring it on another station, the ascii codes in the table has changed. But if i'm accessing the table from another station the code is good. Even if I insert it from a station, it goes fine in the server. Anyone knows why it changes when using mysqldump? How can I prevent this problem to happen in the future? Regards, Velen -- I'm a mysql DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn
mysqldump character set
Hi, I'm storing some ascii codes in a table. When I do a dump using mysqldump from the server and then restoring it on another station, the ascii codes in the table has changed. But if i'm accessing the table from another station the code is good. Even if I insert it from a station, it goes fine in the server. Anyone knows why it changes when using mysqldump? How can I prevent this problem to happen in the future? Regards, Velen
mysqldump : Character set '#33' is not a compiled character set
Hi It's my first time using mysqldump. [EMAIL PROTECTED] mysql]$ mysqldump -uroot --all-databases backup_test.sql mysqldump: File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2) mysqldump: Character set '#33' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index' file [EMAIL PROTECTED] mysql]$ [EMAIL PROTECTED] mysql]$ mysqldump -uroot --character-sets-dir=/usr/local/mysql/share/mysql/charsets --all-databases --default-character-set=utf8 backup_test.sql mysqldump: Character set 'utf8' is not a compiled character set and is not specified in the '/usr/local/mysql/share/mysql/charsets/Index' file [EMAIL PROTECTED] mysql]$ What can I do? Thanks Regards, Gu Lei --
Re: mysqldump : Character set '#33' is not a compiled character set
hi, look at : usr/bin/mysqldump --defaults-extra-file=/.../backup-credentials.cnf in http://dev.mysql.com/doc/mysql/en/mysqldump.html add the port, protocol,password mathias Selon Gu Lei [EMAIL PROTECTED]: Hi It's my first time using mysqldump. [EMAIL PROTECTED] mysql]$ mysqldump -uroot --all-databases backup_test.sql mysqldump: File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2) mysqldump: Character set '#33' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index' file [EMAIL PROTECTED] mysql]$ [EMAIL PROTECTED] mysql]$ mysqldump -uroot --character-sets-dir=/usr/local/mysql/share/mysql/charsets --all-databases --default-character-set=utf8 backup_test.sql mysqldump: Character set 'utf8' is not a compiled character set and is not specified in the '/usr/local/mysql/share/mysql/charsets/Index' file [EMAIL PROTECTED] mysql]$ What can I do? Thanks Regards, Gu Lei -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqldump : Character set '#33' is not a compiled character set
Hello. What version of MySQL do you use? Complete support for utf8 exists only in 4.1.xx and 5.x versions. Gu Lei [EMAIL PROTECTED] wrote: [-- text/plain, encoding 7bit, charset: us-ascii, 23 lines --] Hi It's my first time using mysqldump. [EMAIL PROTECTED] mysql]$ mysqldump -uroot --all-databases backup_test.sql mysqldump: File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2) mysqldump: Character set '#33' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index' file [EMAIL PROTECTED] mysql]$ [EMAIL PROTECTED] mysql]$ mysqldump -uroot --character-sets-dir=/usr/local/mysql/share/mysql/charsets --all-databases --default-character-set=utf8 backup_test.sql mysqldump: Character set 'utf8' is not a compiled character set and is not specified in the '/usr/local/mysql/share/mysql/charsets/Index' file [EMAIL PROTECTED] mysql]$ What can I do? Thanks Regards, Gu Lei -- 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]
Re: mysqldump : Character set '#33' is not a compiled character set
Hello Gleb Paharenko Version is 4.1.10-max Regards Gu Lei Gleb Paharenko : Hello. What version of MySQL do you use? Complete support for utf8 exists only in 4.1.xx and 5.x versions. Gu Lei [EMAIL PROTECTED] wrote: [-- text/plain, encoding 7bit, charset: us-ascii, 23 lines --] Hi It's my first time using mysqldump. [EMAIL PROTECTED] mysql]$ mysqldump -uroot --all-databases backup_test.sql mysqldump: File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2) mysqldump: Character set '#33' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index' file [EMAIL PROTECTED] mysql]$ [EMAIL PROTECTED] mysql]$ mysqldump -uroot --character-sets-dir=/usr/local/mysql/share/mysql/charsets --all-databases --default-character-set=utf8 backup_test.sql mysqldump: Character set 'utf8' is not a compiled character set and is not specified in the '/usr/local/mysql/share/mysql/charsets/Index' file [EMAIL PROTECTED] mysql]$ What can I do? Thanks Regards, Gu Lei
Re: mysqldump : Character set '#33' is not a compiled character set
[EMAIL PROTECTED] : hi, look at : usr/bin/mysqldump --defaults-extra-file=/.../backup-credentials.cnf in http://dev.mysql.com/doc/mysql/en/mysqldump.html add the port, protocol,password mathias Selon Gu Lei [EMAIL PROTECTED]: Hi It's my first time using mysqldump. [EMAIL PROTECTED] mysql]$ mysqldump -uroot --all-databases backup_test.sql mysqldump: File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2) mysqldump: Character set '#33' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index' file [EMAIL PROTECTED] mysql]$ [EMAIL PROTECTED] mysql]$ mysqldump -uroot --character-sets-dir=/usr/local/mysql/share/mysql/charsets --all-databases --default-character-set=utf8 backup_test.sql mysqldump: Character set 'utf8' is not a compiled character set and is not specified in the '/usr/local/mysql/share/mysql/charsets/Index' file [EMAIL PROTECTED] mysql]$ What can I do? Thanks Regards, Gu Lei -- Hi Thanks. What does --defaults-extra-file mean? I've seen http://dev.mysql.com/doc/mysql/en/mysqldump.html. But I don't know what should --defaults-extra-file be set. Regards Gu Lei --
Re: mysqldump : Character set '#33' is not a compiled character set
Gu Lei ??: [EMAIL PROTECTED] ??: hi, look at : usr/bin/mysqldump --defaults-extra-file=/.../backup-credentials.cnf in http://dev.mysql.com/doc/mysql/en/mysqldump.html add the port, protocol,password mathias Selon Gu Lei [EMAIL PROTECTED]: Hi It's my first time using mysqldump. [EMAIL PROTECTED] mysql]$ mysqldump -uroot --all-databases backup_test.sql mysqldump: File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2) mysqldump: Character set '#33' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index' file [EMAIL PROTECTED] mysql]$ [EMAIL PROTECTED] mysql]$ mysqldump -uroot --character-sets-dir=/usr/local/mysql/share/mysql/charsets --all-databases --default-character-set=utf8 backup_test.sql mysqldump: Character set 'utf8' is not a compiled character set and is not specified in the '/usr/local/mysql/share/mysql/charsets/Index' file [EMAIL PROTECTED] mysql]$ What can I do? Thanks Regards, Gu Lei -- Hi Thanks. What does --defaults-extra-file mean? I've seen http://dev.mysql.com/doc/mysql/en/mysqldump.html. But I don't know what should --defaults-extra-file be set. Regards Gu Lei -- Sorry , it's my fault. There are two version of mysql on the same machine and I used the wrong one. Reagards, Gu Lei -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqldump : Character set '#33' is not a compiled character set
Gu Lei : Hello Gleb Paharenko Version is 4.1.10-max Regards Gu Lei Gleb Paharenko : Hello. What version of MySQL do you use? Complete support for utf8 exists only in 4.1.xx and 5.x versions. Gu Lei [EMAIL PROTECTED] wrote: [-- text/plain, encoding 7bit, charset: us-ascii, 23 lines --] Hi It's my first time using mysqldump. [EMAIL PROTECTED] mysql]$ mysqldump -uroot --all-databases backup_test.sql mysqldump: File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2) mysqldump: Character set '#33' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index' file [EMAIL PROTECTED] mysql]$ [EMAIL PROTECTED] mysql]$ mysqldump -uroot --character-sets-dir=/usr/local/mysql/share/mysql/charsets --all-databases --default-character-set=utf8 backup_test.sql mysqldump: Character set 'utf8' is not a compiled character set and is not specified in the '/usr/local/mysql/share/mysql/charsets/Index' file [EMAIL PROTECTED] mysql]$ What can I do? Thanks Regards, Gu Lei Sorry , it's my fault. There are two version of mysql on the same machine and I used the wrong one. Reagards, Gu Lei -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]