Hi there, I had a backup go horribly bad the other day. I believe it was because of a lost connection during the backup. Since then, I have not been able to do backup. I have tried using both dbcheck and myisamchk to repair the databases, but this has not helped. I am afraid my knowledge of mysql is extremely limited, and I am not sure what to do. The errors just keep piling up. Here is an example:
05-Feb 22:25 billie-dir JobId 3931: Fatal error: sql_create.c:894 Fill File table Query failed: INSERT INTO File (FileIndex, JobId, PathId, FilenameId, LStat, MD5)SELECT batch.FileIndex, batch.JobId, Path.PathId, Filename.FilenameId,batch.LStat, batch.MD5 FROM batch JOIN Path ON (batch.Path = Path.Path) JOIN Filename ON (batch.Name = Filename.Name): ERR=Table './bacula/File' is marked as crashed and last (automatic?) repair failed Judging from other, plentiful error messages, it appears most of the tables are marked as crashed. How do I repair these problems? thanks, maria ------------------------------------------------------------------------------ Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
