[prev in list] [next in list] [prev in thread] [next in thread] 

List:       bacula-users
Subject:    Re: [Bacula-users] =?utf-8?q?PostgreSQL_-_how_to_exclude_bacula_datab?=
From:       Wolfgang Denk <wd () denx ! de>
Date:       2012-12-28 14:01:07
Message-ID: 20121228140107.D04CC200F79 () gemini ! denx ! de
[Download RAW message or body]

Dear Jérôme Blion,

In message <57d402d951b7313f52d27fca670c707f@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: wd@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


[prev in list] [next in list] [prev in thread] [next in thread]