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=3Dgcdmg-mysql [at] m.gmane.org

------=_Part_10162_32010968.1143824574999
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

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 [at] 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=3Dkjalleda [at] gmail.co=
m
>
>

------=_Part_10162_32010968.1143824574999--