On 10/25/11 21:36, Dan Langille wrote:
> 
> On Oct 25, 2011, at 5:13 AM, Dimitri Gourdon wrote:
> 
>> 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 believe the best practice is what you said.  mysqldump, backup the 
> resulting files.

It's certainly by far the simplest for small-to-moderate-sized DBs.  The
main problem with it is that for sufficiently large databases, it fails
because mysqldump just physically takes too long to complete the dump.


-- 
  Phil Stracchino, CDK#2     DoD#299792458     ICBM: 43.5607, -71.355
  alaric AT caerllewys DOT net   alaric AT metrocast DOT net   phil AT 
co.ordinate DOT org
  Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater
                 It's not the years, it's the mileage.

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