On Tue, 25 Oct 2011 11:13:11 +0200
Dimitri Gourdon <dgourdon AT itool DOT com> wrote:

> 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,...?
Note that to back up these files directly you have to jump through
special hoops: either use mysqlhotcopy or implement what it does (locks
and flushes the tables in a given database) in a special client script,
and then undo these changes in a post-backup client script.
In other words, you can't reliably back up data files of a live
database (with tables not locked and flushed).

> How are you doing it ?
Personally, I'm using mysqldump and a couple of scripts around it.

------------------------------------------------------------------------------
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