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]
