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
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
