+3 votes
by
For a site using MySQL. Now doing only backups.
Who faced, how you can implement versioning database ?
by
both
by
Data or structure?

3 Answers

0 votes
by
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.
0 votes
by
And what sobsno problem? put a backup in daddy and Purim in git :)
Although it is not clear what for.
+1 vote
by
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.
by
Adamos look at the SQL:2011 temporal features in it. Although it certainly is not about MySQL, but the idea will see
by
Puma Thailand
Oh, and tell us why about data - a stupid idea? I ask in all seriousness, it's important to me.
by
Adamos : well, just logisuite in a separate table with her separate logger in the code.
by
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?
...