Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

SQL Server 2008 had a new feature called "SQL Server 2008 Change Tracking".

Is there a MySQL equivalent?

I'm after any kind of change tracking (to keep a separate MS SQL Server in sync) that does not need schema changes (triggers, extra column, etc).

share|improve this question
Hehehe SQL 2008 isn't "New" anymore. ;) Perhaps you could edit your question to explain the features of SQL's Change Tracking that's you'd like to find in MySQL? Which features have you already found to exist in your MySQL version? Which one have you not (yet) found? It'll help the people who know MySQL but not MS SQL be able to provide you and answer without going and studying. – Ƭᴇcʜιᴇ007 Nov 9 '12 at 15:18
Is my question really worthy of a -1? It was new to SQL Server 2008. That is what I meant. – Pete Oakey Nov 9 '12 at 15:23
It was worth a -1 (IMO) because you hadn't bothered to show any research effort (Have you actually installed MySQL and checked for it? Have you looked through the MySQL documentation for similar features?), nor did you explain what it is you are actually looking for. You fixed that (by making it less vague) so I'll take my -1 back. ;) – Ƭᴇcʜιᴇ007 Nov 9 '12 at 15:31

The obvious answer to me would be MySQL replication logs.

These logs track all changes made to the database necessary to replicate it onto another server, although simply storing them locally forever is also an option.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.