How to best backup & control subversion & restore on hosted websites, databases, files, scripts, etc
Ok I'm a tiny website developer company that is using iPage as hosting service in a Win PC environment at home and Linux on host . Typical websites are composed of Joomla, Wordpress, phpBB, WikiMedia, so the usual suspects. So there are media files, MySQL databases, php, etc.
There is a backup service for a fee that can do daily backups of the system files but not any database files. Could be ok but don't know if it's best solution for iteration development and restore.
For MySQL I found php backup scripts that could help:
http://www.phpclasses.org/search.html?words=backup&x=0&y=0&go_search=1

"Also worth considering if it's MySQL on Linux is sourceforge.net/projects/automysqlbackup -- this again can be triggered by cron, and uses mysqldump, but it stores daily, weekly and monthly backup cycles in a nice structure and is quite configurable. – Matt Gibson Jul 16 '10 at 9:01 
Pasted from <http://stackoverflow.com/questions/3263189/back-up-a-database> "

I'm thinking that someone has figured a clean and easy way using open source software for iteration development with the ability to restore to any point (or at least daily) in a clean easy to understand state of all those files. 
It would also be nice not to have huge amounts of data always having to be downloaded from host as this could cause provider to shut down service for "abuse of bandwidth" (yes that has happened to me) so if nothing has changed on host then no need to download again. I'm terrified of having to backup 100+ websites if just a few are sucking up time.
Subversion programs such as TortoiseSVN seem promising but how could that work? I could have it on my local machine but doubt I can install on host server but maybe I don't have to. I have looked here on stackoverflow but still a bit confused on best way: http://stackoverflow.com/questions/27292/what-is-the-best-solution-for-maintaining-backup-and-revision-control-on-live-we 

So to recap, if a client calls and says hey I busted my website and I need to restore just say the Joomla install and keep the rest as is, how can I prepare and then do those types of things.

I have another question but I think I'll start a new thread but if you want to advise please do. How best to organize the folders and files of what I'm doing (webdev) on the host and on my local? I say this now because of how things are going to be backed up and some installs will have files nicely in their folders but also in the root directory so things can get messy and then local machine is not the same as host and then ahhh chaos! 

Thank you in advance for any comments and please end this pain lol

How to best backup & control subversion & restore on hosted websites, databases, files, scripts, etc
===

Ok I'm a tiny website developer company that is using iPage as hosting service in a Win PC environment at home and Linux on host . Typical websites are composed of Joomla, Wordpress, phpBB, WikiMedia, so the usual suspects. So there are media files, MySQL databases, php, etc.
There is a backup service for a fee that can do daily backups of the system files but not any database files. Could be ok but don't know if it's best solution for iteration development and restore.
For MySQL I found php backup scripts that could help:
http://www.phpclasses.org/search.html?words=backup&x=0&y=0&go_search=1

"Also worth considering if it's MySQL on Linux is sourceforge.net/projects/automysqlbackup -- this again can be triggered by cron, and uses mysqldump, but it stores daily, weekly and monthly backup cycles in a nice structure and is quite configurable. – Matt Gibson Jul 16 '10 at 9:01 
Pasted from <http://stackoverflow.com/questions/3263189/back-up-a-database> "

I'm thinking that someone has figured a clean and easy way using open source software for iteration development with the ability to restore to any point (or at least daily) in a clean easy to understand state of all those files. 
It would also be nice not to have huge amounts of data always having to be downloaded from host as this could cause provider to shut down service for "abuse of bandwidth" (yes that has happened to me) so if nothing has changed on host then no need to download again. I'm terrified of having to backup 100+ websites if just a few are sucking up time.
Subversion programs such as TortoiseSVN seem promising but how could that work? I could have it on my local machine but doubt I can install on host server but maybe I don't have to. I have looked here on stackoverflow but still a bit confused on best way: http://stackoverflow.com/questions/27292/what-is-the-best-solution-for-maintaining-backup-and-revision-control-on-live-we 

So to recap, if a client calls and says hey I busted my website and I need to restore just say the Joomla install and keep the rest as is, how can I prepare and then do those types of things.

I have another question but I think I'll start a new thread but if you want to advise please do. How best to organize the folders and files of what I'm doing (webdev) on the host and on my local? I say this now because of how things are going to be backed up and some installs will have files nicely in their folders but also in the root directory so things can get messy and then local machine is not the same as host and then ahhh chaos! 

Thank you in advance for any comments and please end this pain lol
