I am in need of a way to automatically backup a MySql Database on a shared Linux server and then automatically have it send/upload to a Rackspace Cloud Files storage account.
I do not have shell or root access to the server so I will need this to be done in PHP or something that does not require administrator permission.
I can make ConJobs schedules if needed.
You will have to create your own Rackspace Cloudfiles account (which is free until you use it) and test everything on your server. I will add in an addtional $5.00 (max) for your cloudfiles testing storage costs.
Please make the installation easy and provide full instructions.
Please make the system secure and you must encrypt the backups. You must also provide a way to restore/decrypt the backup from Rackspace Cloudfiles as well.
I should be able to determine the backup schedule.
The backups should not overwrite eachother and the file names should include the date and time of the backup.
If you use a temp directory on the source server, please make sure I can empty it from time to time or have the system automatically empty the temp folder.
Once you are done, you will need to show me that it is working on your server (because I will not have access to my server until next month) and I will release 75% of the escrow. Once you send me the files and instructions I will release the remaining 25%.
The backup format can be in CSV, or any basic MySQL backup format, as long as it can be encrypted and easily recovered (if needed).
Also, Rackspace clouldfiles does not accept FTP, they use an API to communicate.
As a side note, I have already looked at Duplicity and the tutorial that someone else put together on this subject but both of those require root access (which I do not have).
Duplicity Tutorial: http://blog.jtclark.ca/2010/02/backup-mysql-to-rackspace-cloud-files-with-duplicity
Thank you
