Le 25/10/2011 11:13, Dimitri Gourdon a écrit : > Hi all, > > I have some servers with MySQL databases. I want to know what is the > best way to backup these databases ? > > For now, i think i will do mysqldump on each server to local disk and > after that, backup that files. Is there a better way ? MySQL module for > bacula, backup mysql files (.myd and .myi) directly,...? How are you > doing it ? I use mysqldump and backup my dumps using bacula, just like you. I doubt backing up MyIsam files directly is a good idea, especially if you have big tables, foreign keys and so on... you could endup with tables inconsistencies. Using LVM snapshot would help backing up raw files... but you need to have you mysql datadir on an lvm volume.
> > Thanks in advance. > > Dimitri Gourdon > > ------------------------------------------------------------------------------ > The demand for IT networking professionals continues to grow, and the > demand for specialized networking skills is growing even more rapidly. > Take a complimentary Learning@Cisco Self-Assessment and learn > about Cisco certifications, training, and career opportunities. > http://p.sf.net/sfu/cisco-dev2dev > _______________________________________________ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users -- <http://www.horoa.net> Alexandre Chapellon Ingénierie des systèmes open sources et réseaux. Follow me on twitter: @alxgomz <http://www.twitter.com/alxgomz> ------------------------------------------------------------------------------ The demand for IT networking professionals continues to grow, and the demand for specialized networking skills is growing even more rapidly. Take a complimentary Learning@Cisco Self-Assessment and learn about Cisco certifications, training, and career opportunities. http://p.sf.net/sfu/cisco-dev2dev _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
