On Tue, 25 Oct 2011 11:13:11 +0200 Dimitri Gourdon <dgour...@itool.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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
