Is backing up a MySQL database in GIT a good idea?

Posted by wobbily_col on Programmers See other posts from Programmers or by wobbily_col
Published on 2014-05-26T08:49:51Z Indexed on 2014/05/26 22:00 UTC
Read the original article Hit count: 170

Filed under:
|
|
|

I am trying to improve the backup situation for my application. I have a Django application and MySQL database. I read an article suggesting backing up the database in Git.

On the one hand I like it, as it will keep a copy of the data and the code in synch.

But GIT is a designed for code, not for data. As such it will be doing a lot of extra work diffing the mysql dump every commit, which is not really necessary. If I compress the file before storing it, will git diff the files?

(The dump file is currently 100MB uncompressed, 5.7Mb when bzipped).

Edit: the code and database schema definitions are already in GIT, it is really the data I am concerned about backing up now.

© Programmers or respective owner

Related posts about database

Related posts about git