Re: [Bacula-users] Re: The table 'File' is full

2006-02-02 Thread Daniel Holtkamp
Hi ! Roger wrote: What will happend to the MyISAM file, will it be converted, or just left behind an I need to start my backups from scratch? I think the MyISAM files got converted and deleted. Actually i`m pretty sure about that :) Best regards, -- Daniel HoltkampRiege

[Bacula-users] Re: The table 'File' is full

2006-02-01 Thread Roger
mysql select count(*) from File; +--+ | count(*) | +--+ | 47405618 | +--+ 1 row in set (0.00 sec) Frank Sweetser wrote: On Wed, Feb 01, 2006 at 03:37:11PM +0100, Roger Kvam wrote: 27-Jan 00:45 alexandria-dir: LogicBackupAvr32.2006-01-27_00.05.10 Fatal error:

[Bacula-users] Re: The table 'File' is full

2006-02-01 Thread Roger
What will happend to the MyISAM file, will it be converted, or just left behind an I need to start my backups from scratch? Roger Kvam Daniel Holtkamp wrote: Hi ! Roger Kvam wrote: My MySQL database is 6.8G, while the File.MYD is 4.0G You ran into a mysql-limit there. The File Table

Re: [Bacula-users] Re: The table 'File' is full

2006-02-01 Thread Dominic Marks
Roger wrote: mysql select count(*) from File; +--+ | count(*) | +--+ | 47405618 | +--+ 1 row in set (0.00 sec) Perhaps InnoDB should be the default MySQL database format in the next Bacula release, Kern? Frank Sweetser wrote: On Wed, Feb 01, 2006 at 03:37:11PM

Re: [Bacula-users] Re: The table 'File' is full

2006-02-01 Thread Frank Sweetser
On Wed, Feb 01, 2006 at 05:06:38PM -, Dominic Marks wrote: Perhaps InnoDB should be the default MySQL database format in the next Bacula release, Kern? And if so, perhaps also consider enabling foreign key constraints? This would eliminate 90% of the work that dbcheck currently has to