BAcking up sugar files with scheduler

[aheuermann]

Is it possible to use the scheduler to zip the sugar application files and save it to the server. I know the directory must be writable by sugar ans such but how easy is it to schedule something like this in the sugar scheduler?

[cywolf]

I don't think there's an easy way to do that right now.

The Sugar files don't actually change that often, only when you apply a patch or make layout changes using the studio. You can perform a backup of this data yourself using the built-in backup tool.

Backing up the database at regular intervals is a good idea, but this is probably best implemented outside of Sugar (using a shell script for instance). I think you can probably configure a tool like MySQL Administrator or Navicat to do this for you.

The last thing to worry about is the directory of uploaded files (cache/upload). While you could just zip up the whole thing, a lot of the files are probably compressed already. In this case a tool like rsync might be the most appropriate. This would just copy the new or modified files to another server incrementally, and you could add it to the same shell script you used to back up the database. There are also various other solutions (some commercial) to perform this type of backup.

[Erik Geurts]

A nice little tool to backup database and files using a scheduler can be found here:

http://www.phpmybackuppro.net/

[TKzmanda]

Zmanda just released Zmanda Recovery Manager [ZRM] for MySQL. It is a easy-to-use yet flexible and robust backup and recovery solution for MySQL server that has some great features, including scheduling and reporting.

Check out http://www.zmanda.com/backup-mysql.html

Thanks
tk