Error On Export Data

[dcha]

Receiving error message “Exporting table account… Binlog Closed, cannot reset master”.

Any ideas?

[peterlaursen]

You are exporting from a MySQL server being the slave in a replication chain.

Am I right ?

The replication feature of the MySQL roughly works this way that the Slave Server compares it's own binary log with the one of the master Server. What is in the Master's log and not in it's own is what needs to be done.

Is it “export table as SQL” form SQLyog you are trying to use ?

You are not very informative. The more precise information you give, the more precise answers you'll get, I guess …

[dcha]

Sorry, first post here. I am NOT using a slave in a replication chain. I have a mysql DB on a remote host and trying to backup onto my localhost DB. Trying to use backup wizard in 4.07 version. Mysql version is 4.020a. Ran it once successfully, but when tried to restore had an error so tried to backup again changing some of the settings. Received the error on the subsequent try. Tried shutting down and restarting mysql on both ends.

peterlaursen wrote on Aug 4 2005, 09:11 PM:

You are exporting from a MySQL server being the slave in a replication chain.

Am I right ?

The replication feature of the MySQL roughly works this way that the Slave Server compares it's own binary log with the one of the master Server.  What is in the Master's log and not in it's own is what needs to be done.

Is it “export table as SQL” form SQLyog you are trying to use ?

You are not very informative.  The more precise information you give, the more precise answers you'll get, I guess …

[post=”6768″]<{POST_SNAPBACK}>[/post]

[peterlaursen]

Quote:

Trying to use backup wizard in 4.07 version

The “backup wizard” will NOT backup to a MySQL database to another MySQL database, but to a text-file containing SQL-statements.

Shall I understand you so that you “backed up” or “dumped” your remote database to a textfile and tried to import that on your local and had an error?

Quote:

had an error

Which error ?

Quote:

changing some of the settings

Very much looks like you have told your server that it is part of a replication chain. Have you being changing the MySQL configuration file ?

I am sorry but I still don't understand.

[Ritesh]

Uncheck Flush master log and Flush slave log.

[dcha]

Ritesh wrote on Aug 5 2005, 01:28 AM:

Uncheck Flush master log and Flush slave log.

[post=”6776″]<{POST_SNAPBACK}>[/post]

THe uncheck worked. Some how must have quickly been going thru things and checked those not fully understanding what it was.

thx

[Author]

Posts