Re: mysql backup quesiton

["Fred @ Planetary Server" <user=1474@nabble.blu.org>]

 Tom Metro wrote: 
> Dan Ritter wrote: 
>> Stephen Adler wrote: 
>>> I need to make sure that on a 24 hr interval, some kind of snap 
>>> shot is made of the database... 
>> 
>> I don't think you'd have any problems...shutting down 
>> the database, running mysqldump, gzipping the output and 
>> rsyncing it to two or three places. 
>> 
>> Sometimes the simple solutions are best. 
> 
> I agree with Dan that replication is not warranted for this 
> application.  mysqldump dump is trivial to set up, and it provides 
> abundant options for controlling what gets dumped and whether logs are 
> flushed and tables locked before/during the dump.