Kurt J. Bosch wrote: > I don't know what SQL statement is sent by mysql-admin. How could I get > that ? The files mysql.err and mysql.log on the server contain nothing > at all. The binary logs contain no entries which have timestamps near > the time when I tried this with mysql-admin. >
Enable logging on mysql-server, restart the service. Then start mysql-admin's backup. Once you get an error, disable logging on mysql-server and restart the service. Then look at the logged queries or send them my way. It will be in the configuration file somewhere like, # * Logging and Replication # # Both location gets rotated by the cronjob. # Be aware that this log type is a performance killer. #log = /var/log/mysql.log #log = /var/log/mysql/mysql.log uncomment it to activate. Not sure, but mysql-admin probably has the option if you run it on the same host as the server. - Adam -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
