Posted by Adam on 11/20/06 15:40

On Mon, 20 Nov 2006 14:17:11 +0100, J.O. Aho wrote:

>Adam wrote:
>> 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?
>
>You could install it in your user account, and modify the PHP script to use
>the one in your home rather than the systemwide one.

Now there's a thought. How would I point it though? I don't have a
fixed IP at home. Would I have to go throught DynDNS or something?

Adam.

[Back to original message]