18 Feb
2009
18 Feb
'09
4:09 p.m.
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