If your host allows it, you can use your own workstation and program a
script that periodically does something like

mysqldump -C --host DB_HOSTNAME -u USERNAME -p PASSWORD DB_NAME >
mysdump.sql

over the network.

Your mysql needs to be reachable from outside the server.

My host used to allow it and it was a very convenient and quick (owing
to the C option) way to backup a database remotely.

There can be security hazards though (but sending the dump via email
too).

Guillaume
http://cherryonthe.popnews.com


On 12 nov, 10:21, technicaltitch <[EMAIL PROTECTED]> wrote:
> surely it is easier to concatenate a string in PHP than change my
> host?! i'm keen to hear of workarounds, but mostly hoping for help
> with the string handling.
>
> our hosting is US$11 per year which is incredibly competitive, we are
> very happy with their service (faultless in several years) and
> familiar with the setup - and every single cent makes a difference in
> bolivia. ( they are bargainvault.com and the website i'm replacing 
> iswww.intiwarayassi.org)
>
> On Nov 11, 9:55 pm, Steve Boyd <[EMAIL PROTECTED]> wrote:
>
> > then changes your host.  there is incredibly cheap hosting everywhere
> > (well within the USA anyhow) that allows you cron jobs + all the other
> > bells and whistles
>
> > On Nov 12, 8:37 am, technicaltitch <[EMAIL PROTECTED]> wrote:
>
> > > because it's for a bolivian volunteer organization we're using
> > > incredibly cheap hosting which doesn't allow us cron jobs. i thought
> > > this would be trivial.
>
> > > On Nov 11, 5:21 pm, AD7six <[EMAIL PROTECTED]> wrote:
>
> > > > On Nov 11, 1:33 pm, technicaltitch <[EMAIL PROTECTED]> wrote:
> > > > <snip>
>
> > > > Why would you not use mysqldump and a cron job?
>
> > > > AD- Hide quoted text -
>
> > - Show quoted text -


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake 
PHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to