Posted by Adam on 11/21/06 11:59

On Mon, 20 Nov 2006 16:49:27 +0100, J.O. Aho wrote:

>Adam wrote:
>> 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?
>
>No, you install the mysqldump on the cPanel host, but as you seem to have
>found another script that works, better to stick with that than try to do
>something that cPanel didn't want you to do.

I think I'm a bit more with you now. I work from home, so I thought
you meant my server at home LOL.!

But - yes - you're right, I'll probably stick with mysqlphpbak ;-)

Thanks for the help, though.

Adam.

[Back to original message]