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 AT lists.sourceforge DOT 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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users