[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Re: Database backup Problem
From:       "Kishore Jalleda" <kjalleda () gmail ! com>
Date:       2006-03-31 17:02:54
Message-ID: 78aaf6710603310902s796d2f1es94fbc78b286cf8d5 () mail ! gmail ! com
[Download RAW message or body]


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 <cholland@redmoonbroadband.com> 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/mysql?unsub=kjalleda@gmail.com
>
>


[prev in list] [next in list] [prev in thread] [next in thread]