Is backing up a MySQL database in GIT a good idea?
- by wobbily_col
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.