Dan Langille wrote:
> Daniel Wedewardt wrote:
>> Hi,
>>
>> I've got a serious problem with my bacula backup. Sometimes it happens,
>> that a backup fail with the following error message:
>>
>> 23-Apr 10:43 backup-dir JobId 4873: Fatal error: Can't fill Filename
>> table Query failed: INSERT INTO Filename (Name) SELECT a.Name FROM
>> (SELECT DISTINCT Name FROM batch) AS a WHERE NOT EXISTS (SELECT Name
>> FROM Filename AS f WHERE f.Name = a.Name): ERR=Incorrect key file for
>> table './bacula/Filename.MYI'; try to repair it

The 'try to repair' message means that your tables are corrupted, and you need 
to start a repair operation on them.

http://dev.mysql.com/doc/refman/5.0/en/repair.html

-- 
Frank Sweetser fs at wpi.edu  |  For every problem, there is a solution that
WPI Senior Network Engineer   |  is simple, elegant, and wrong. - HL Mencken
     GPG fingerprint = 6174 1257 129E 0D21 D8D4  E8A3 8E39 29E3 E2E8 8CEC

-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference 
Don't miss this year's exciting event. There's still time to save $100. 
Use priority code J8TL2D2. 
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users