I need a simple backup script to be done for CentOS. Basicly this script must zip all the content in /home directory and export all the mysql databases and than upload it to a remote ftp server. It will be started in by cron and it has to do it for all domains/users in the system (must be flexible, so if I add new domain/user it has to start to make backups automaticly for that user also).
Each time it sends files to that remote ftp server it has to delete all old backup files first (to save space).