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 | 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 / webmaster@blu.org