Re: [Bacula-users] Sizes of database dump?

2009-11-12 Thread Arno Lehmann
Hi, 11.11.2009 21:24, Alan Brown wrote: On Mon, 9 Nov 2009, Alan Brown wrote: Nor can I. 20 billion rows dumped when there should only be only 400 million in there and 3 billion ever written in. Arrgh... Arrgh indeed. To summarise: The file table was corrupt (innodb) and mysqldump

Re: [Bacula-users] Sizes of database dump?

2009-11-11 Thread Alan Brown
On Mon, 9 Nov 2009, Alan Brown wrote: Nor can I. 20 billion rows dumped when there should only be only 400 million in there and 3 billion ever written in. Arrgh... Arrgh indeed. To summarise: The file table was corrupt (innodb) and mysqldump was jumping back about 50 million entries every

Re: [Bacula-users] Sizes of database dump?

2009-11-09 Thread Alan Brown
On Fri, 6 Nov 2009, Cedric Tefft wrote: As a point of reference, I have a 70MB MyISAM database which, when dumped to a text file is about 80MB. That works out to about a 15% larger dump file than the native database. Your dump file is 2300% larger than the database (and counting). I don't