ChiliProject is not maintained anymore. Please be advised that there will be no more updates.

We do not recommend that you setup new ChiliProject instances and we urge all existing users to migrate their data to a maintained system, e.g. Redmine. We will provide a migration script later. In the meantime, you can use the instructions by Christian Daehn.

Forums » Develop »

Backup rake task

Added by Matt Connolly at 2011-05-08 11:12 am

I spent a bit of time looking for a rails specific backup solution that would work for any rails database connector (mysql,sqlite,etc). I found one that was for Rails 2.0 and updated it for Rails 2.3 and have checked it with ChiliProject. While it seems to me this would be more useful as a Rails feature for any rails app, if anyone would like it I placed the code from this pastie into "lib/tasks/backup.rake" : http://pastie.org/1877530

I put it in a fork on github too, if anyone's interested: https://github.com/soundevolution/chiliproject


Replies (3)

RE: Backup rake task - Added by Felix Schäfer at 2011-05-08 05:06 pm

This only seems to export the DB tables into the ChiliProject directory structure, doesn't it? A "backup" solution would include DB, uploaded files and config files export to another path/archive, so I'm not sure I'd call that "backup". Might be interesting to have in core though, if labeled correctly, as it could also be a solution for people looking to migrate from one DB type to the other.

Could you open a ticket for it, and test if e.g. exporting data from sqlite to mysql/postgresql works as expected?

RE: Backup rake task - Added by Matt Connolly at 2011-05-08 10:42 pm

Good points. I was originally thinking about database portability, because files are easy to copy / archive. I totally agree that a comprehensive tool for ChiliProject would be better. What I've got so far is hopefully a good starting point for the db component.

I'll check it out with postgres over the next few days. (have tested mysql -> sqlite3).

I created an issue: #386.

RE: Backup rake task - Added by Felix Schäfer at 2011-05-09 07:18 am

Matt Connolly wrote:

I'll check it out with postgres over the next few days. (have tested mysql -> sqlite3).

I created an issue: #386.

Great, thanks!

(1-3/3)