Version control for MySQL on the website?

Question

For a site using MySQL. Now doing only backups.
Who faced, how you can implement versioning database ?

Comments

both

---

Data or structure?

Answer 1

In different ways, depending how you want to go:
1) Saperny option is to write procedures, additional tables, etc. total to make version control for MySQL.
2) write a bash script which would copy the structure, and the emergence of new tables, etc. was called a bash script that made a copy of the structure...all the same Saperny option, but easier implemented than 1, and much more flexible.
3) Look for the MySQL forks in which this mechanism is implemented.

Answer 2

And what sobsno problem? put a backup in daddy and Purim in git :)
Although it is not clear what for.

Answer 3

If about changes in the structure of the database is the mechanism of migration in almost all reinforced, if just about data it's just a stupid idea.

Comments

Adamos look at the SQL:2011 temporal features in it. Although it certainly is not about MySQL, but the idea will see

---

Puma Thailand
Oh, and tell us why about data - a stupid idea? I ask in all seriousness, it's important to me.

---

Adamos : well, just logisuite in a separate table with her separate logger in the code.

---

If the database has a table, changes which are important, it is logical to keep these changes for the database (stupidly another table, say). You have in mind or is that a stupid idea?