Posted by J.O. Aho on 11/20/06 15:49

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.


//Aho

[Back to original message]