MySQL Version Control

Question

I am wanting to do some basic version control with my mysql database structure. I am not worried about the contents of the database, I just want to track any new tables added, tables altered, and tables deleted.

Is there a simple application that could do this all automagically? (Needs to run on a Linux envirnment)

I have looked at a few, such as PHPMyVersion, but it is no longer being developed, and not quite what I was looking for.

Thanks

Possible duplicate of : http://stackoverflow.com/questions/1783834/mysql-version-control-subversion — nc3b, Sep 06 '10 at 07:21
Had a look at that already, but it's not quite what I am looking for — Skippy, Sep 06 '10 at 07:48

score 4 · Accepted Answer · answered Sep 06 '10 at 07:22

4

Maybe something like MySQLdiff is what you want.

answered Sep 06 '10 at 07:22

reko_t

55,302
10
87
77

Brilliant. This is exactly what I have been looking for. Thank you very much :) – Skippy Sep 06 '10 at 07:53
Just got Navicat Premium and saw that it is able to do it too. Very nice easy to interface. A+ – Skippy Sep 21 '10 at 10:11
We use a program called ORM Designer to create our model and we generate our doctrine 2 classes from this model. It works great. This model is just XML so you can put it in SVN, GIT, what have you. – ladieu Feb 18 '14 at 18:52

MySQL Version Control

1 Answers1