not sure if this should be here or in the scripts section but here goes.
I have to backup a linux server each night and would like to acheive the following:
A full copy backup of the /usr/var/www/*.* folder
A full copy backup of each mysql database on the server
A full copy backup of the /usr/var/moodledata folder
The contents of the above should be copied into /var/backups/[date]/ with the file structure of each remaining intact and an additional folder being created for the MySQL_DataBackup.
Once the above has completed I need it to be FTP'd of to another server which will then be burned to DVD hopefully.
Any pointers on where to start or if anyone has anything like this would be great.