[CentOS] realtime backup

nate centos at linuxpowered.net
Wed Feb 18 16:09:08 UTC 2009


CentOS List wrote:
> Hi,
>
> I had a cfml application running on mysql database. Can some suggest a
> realtime backup solution via ftp say every 5mins without damaging the
> database?

Using ftp every 5 minutes implies a pretty small database, like others
have suggested I would suggest setting up a slave DB, and run
mysqldump against it as often as you need and ftp the results to
the remote host.

nate




More information about the CentOS mailing list