[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

[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]

[Author]

Posts