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]
