Posted by Adam on 11/20/06 10:43

On Mon, 20 Nov 2006 07:53:14 +0100, J.O. Aho wrote:

>Adam wrote:
>> After having deleted a complete database when I thought I was removing
>> just one table, I thought it really was high time I implemented a
>> decent MySQL backup script on my remote servers.
>>
>> I googled around a fair bit and found a bewildering array of pretty
>> *complex* looking scripts that I'm struggling to compare. Some weird
>> ones out there - like a CRON verison that only works by *emailing* the
>> file. A 300Mb e-mail would bring my NZ "broadband" to its knees ;-)
>>
>> I need to be able to set up and run *fairly simple* backups on my
>> clients' sites. Either CRON or manual. I don't have access to EXEC
>> functions on most of these sites - just the usual cPanel thing.
>>
>> Anyone know of a decent backup script?
>
>
>I have used mysqlphpbak, it allows simple backups and recoveries, stores the
>database on local hard drive (local as same as the web server is run on).

Thanks for that - not one I'd previously seen (I *did* look -
honest!).

This one appears to need to have access to mysqldump (in /bin) -
which I don't have on these cheapo cPanel type hosting arrangements.
Is there any way round this?

Adam.

[Back to original message]