A
A
afna2015-09-02 09:51:15
PHP
afna, 2015-09-02 09:51:15

Version control for MySQL on site?

I use MySQL for the website. Now I only make backups.
Who faced how it is possible to implement DB versions?

Answer the question

In order to leave comments, you need to log in

3 answer(s)
P
Puma Thailand, 2015-09-02
@opium

If it’s about changes in the structure of the database, then there is a migration mechanism in almost all frameworks, if it’s just about data, then this is just a stupid idea.

T
TyzhSysAdmin, 2015-09-02
@POS_troi

And what is the real problem? put the backup in the folder and push it to the git :)
Although it's not clear what for.

A
AntonDrelin, 2015-09-03
@AntonDrelin

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

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question