Viewing Changes Made During Database Synchronization

[Kyle]

I am trying to find a way to see detailed information of the changes that were made to the data during a database synchronization session. And all that goes into the log file is something simple like this(see below), that only really tells me that 1 thing was updated, but doesn't tell me what it was… Is there any way to get what i'm looking for? Any help would be great, thanks…

`table1` 3643 3643 0 0 0

Sync started at Wed Aug 16 11:43:34 2006

`table1` 3643 3643 0 1 0

[peterlaursen]

SQLyog does not log individual INSERT, UPDATE and DELETE statements.

If you have access to server configuration you can enable the server 'general log' by inserting something like

Code:

log = [full_path_to]mylog.log

in the [mysqld] section of the server configuration file. Don't forget to restart the server.

BTW: I delete the other (identical) post of yours. It is VERY bad 'netiquette' to post dublicate posts! How do you think it is possible to follw a discussin that spreads over several posts?[code]

in the [mysqld] section of the server configuration file. Don't forget to restart the server.

BTW: I delete the other (identical) post of yours. It is VERY bad 'netiquette' to post dublicate posts! How do you think it is possible to follw a discussin that spreads over several posts?

[Kyle]

Yeah, sorry about the duplicate. I didn't notice this section (Data Synchronization and SQLyog Job Agent) until after I posted other one. I went to see if there was a way to remove it, but i didn't see an option.

Thanks for the feedback though. Appreciate it.

[peterlaursen]

OK. you are welcome 🙂

[Author]

Posts