1

Is there any version control system for database..

Ofcourse we can keep sql file for mysql db along with our code. Other than that .....

"I mean i want my db backup,
I do not want to do it myself every time,
It should work like pulling code"

Comments
  • 2
    If it's for data, automate a backup process or snapshots on a scheduled task and.. I'm assuming mysql based on profile... just run mysql_dumps and upload them to an external storage.

    I wouldn't put a DB into version control unless it's only structural information/ stored procedures and configurational data that would be used in the event you needed to create a new DB and somehow loose the snapshots.
  • 1
    Lookup the term slowly changing dimensions.
  • 1
    There is a DB designed for this use case. Quite handy IMHO.
    https://github.com/attic-labs/noms
  • 0
    @C0D4
    One by one
    Have you been using any services to

    1. automate a backup process -

    2 .take snapshots on a scheduled task -
  • 0
    @Makenshi I didnt get the context tbh
  • 0
    @rytzpekt Seems good. But i think it does not have any support now
  • 1
    @sandeepbalan not since moving everything to AWS a few years ago which we have private S3 buckets for.

    But before that I had VMWare run daily snapshots of the VMs and I just wrote a php cronjob that exported the database with exec(mysql_dump) on a daily basis, zip it up, and send it to another server, ah the good ol' days.
  • 0
    Harcore solution: You can push your data into a Git repository.
  • 0
    @matste you mean sql file?
Add Comment