CODEWITHSUNDEEP
mysqlsqlcomparisondiff
ehime
ehime

Reputation: 8405

Ways to log MySQL Diff?

I'm working on a project right now that required me to use a CMS that makes multiple changes to a database, I'll need those changes later in order to create a post install configuration file to reuse those changes. I know that there are lots of Windows based programs that will show you MySQL Diffs, but what about Linux? I would like the ability to keep an appending log of my changes so I know what exactly is going on under the hood.

The ideal scenario would be that I can capture a post and current state, compare them, and aggregate the output. Does anyone know a way to do this?

Upvotes: 0

Views: 335

Answers (1)

Ike Walker
Ike Walker

Reputation: 65567

If these are the only changes made to your database then one way to do this is to enable the binary log, and use that as your change log. You can convert it to a SQL script using the mysqlbinlog tool.

Upvotes: 1

Related Questions