Just checking if this user has "RELOAD PRIVILEGES", as it is needed for the --master-data option which is automatically enabled with --delete-master-logs , does the error duplicate on subsequent attempts ??
Kishore Jalleda http://kjalleda.googlepages.com/projects On 3/31/06, Cody Holland <[EMAIL PROTECTED]> wrote: > > I recently migrated all of our mysql databases from 4.1.X to 5.0.X. > Everything is working properly except my backups. Here is the command > that I am using: > > mysqldump -u user -ppassword --opt -A -F --delete-master-logs | gzip > > $BACKUPFILE`date +%m%d%y`.sql.gz > > This worked on the old database server, but now I'm getting the > following error: > > mysqldump: mysqldump: Couldn't execute 'RESET MASTER': Binlog closed, > cannot RESET MASTER (1186) > > Any insight on what I'm doing wrong would be great! > > Thanks, > Cody > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > >