Boston Linux & Unix (BLU) Home | Calendar | Mail Lists | List Archives | Desktop SIG | Hardware Hacking SIG
Wiki | Flickr | PicasaWeb | Video | Maps & Directions | Installfests | Keysignings
Linux Cafe | Meeting Notes | Blog | Linux Links | Bling | About BLU

BLU Discuss list archive

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: mysql backup quesiton

 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. 

BLU is a member of BostonUserGroups
BLU is a member of BostonUserGroups
We also thank MIT for the use of their facilities.

Valid HTML 4.01! Valid CSS!

Boston Linux & Unix /