Add database backup/restore tasks through Capistrano

[joebew42]

Add capistrano task for pulling and pushing database data. (Backup and restore operations). Maybe can be useful start from this gem https://github.com/sgruhier/capistrano-db-tasks or newer?

[cmrd-senya]

To be useful, https://github.com/sgruhier/capistrano-db-tasks requires to have a local database set up, it's more like mirroring than back up/restore. But it uses sql dumps to do that, so it's not hard to hack the gem in order to download dumps and upload the required. For example, the PR sgruhier/capistrano-db-tasks#50 adds a feature to just dump sql (but only remotely). Itself it is not very useful either.

So, how do you think it is supposed to work?

[joebew42]

So, how do you think it is supposed to work?

We could start by submitting a PR in order to add the functionalty to download the dump sql. What do you think ? If you think that this can be a good starting point I can give a look to capistrano-db-tasks this weekend 👍

[cmrd-senya]

Actually, simple dump&download still requires hacking the capistrano-db-tasks. Which I already did! Here is the PR: sgruhier/capistrano-db-tasks#87.

Later today I'll submit a PR here which adds capistrano-db-tasks in a way to support my PR as well. You can then check, if you are fine with it :)