Dear Jérôme Blion,
In message <57d402d951b7313f52d27fca670c7...@imap.free.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: w...@denx.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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
