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

Reply via email to