Dear Jérôme Blion,

In message <57d402d951b7313f52d27fca670c707f AT imap.free DOT fr> you wrote:
>
> >> Say what?  mysqldump doesn't produce a valid backup?
...
> http://dba.stackexchange.com/questions/6363/consistent-logical-backup-of-databases-that-use-myisam-and-innodb-engines
> http://dev.mysql.com/doc/refman/5.5/en/mysqldump.html#option_mysqldump_single-transaction

Well, this states:

         It's also worth mentioning that the default options will make
         sure your backup is safe, you don't need to turn any special
         flag on.


> And another reason not to use mysqldump on production systems: the 
> nightmare begins when you have to restore a huge dump.

OK, but poor performance (while still bad) is a completely different
thing than inconsistent data.

> (that's why I use other tools like mylvmbackup and mydumper when I can 
> afford to loose some records)

I don't understand you.  You complain that mysqldump was unreliable
(and causing inconsistent backup data), which is apparently not true,
and then you recommend some other tools which may "loose some records"?

This makes little sense to me.

Best regards,

Wolfgang Denk

-- 
DENX Software Engineering GmbH,     MD: Wolfgang Denk & Detlev Zundel
HRB 165235 Munich, Office: Kirchenstr.5, D-82194 Groebenzell, Germany
Phone: (+49)-8142-66989-10 Fax: (+49)-8142-66989-80 Email: wd AT denx DOT de
In C we had to code our own bugs, in C++ we can inherit them.

------------------------------------------------------------------------------
Master HTML5, CSS3, ASP.NET, MVC, AJAX, Knockout.js, Web API and
much more. Get web development skills now with LearnDevNow -
350+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122812
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users