As far as I can see, FastHostsfeyd wrote:most hosts have backup systems, which you can often schedule to keep a copy in your document tree..
I've just been given the task of finding a way to automatically back up all the databases we have with Fasthosts on a weekly basis. (I currently back them up one by one manually.) They all seem to be on the same db server, so that's one bit of good news I suppose.
I need to back them up to a machine in our office or one of the fasthost web servers since backing them on the db server we have no access to would be pointless.
So far all the scripts I have seen that would do what I need rely on cron jobs (logically). The only other way I think I can do it is to purchase DBManager Enterprise edition which I think allows me to access the backup tool via a windows command line and then I guess I just have to schedule a batch file to run using windows.
If I have shell access to one of the Fasthost web servers could I run a script from there that could back up the required databases on the database servers? If so how? I'm new to this kind of thing.
Any advice is helpful.... thanks