Thank you for the advice, and I read about "mysqlbinlog"
2011/08/15 10:22 -0400, Shawn Green (MySQL)
1) extract the statements from the binary log.
2) get the master to sent you the statements just as if you were a slave.
mysqlbinlog will do either - (again, read the manual on how t
On 8/15/2011 09:06, wrote:
2011/08/10 08:16 +0200, Johan De Meersman
Yes, the MySQL binary log can be read (and thus, re-executed) by the
mysqlbinlog utility.
Yes, but what is the best means of picking up the changes from the instance where there were
changes to the instance that
2011/08/10 08:16 +0200, Johan De Meersman
Yes, the MySQL binary log can be read (and thus, re-executed) by the
mysqlbinlog utility.
Yes, but what is the best means of picking up the changes from the instance
where there were changes to the instance that is a copy? Is it best to
- Original Message -
> From: "Halász Sándor"
>
> Is there a log from which I can get SQL statements that record
> changes from some time, copy that to flash drive, and mark the time
> when I did that, by truncating the log or starting a new one or ...?
Yes, the MySQL binary log can be
I made two copies of one not too big database, wherof the transaction rate is
conveniently noted in inverse weeks. I have been using textfile-differencing to
copy changes, but would like something more automatic for this by-hand
replication, but real automatic replication is out of the question
