Re: [Bacula-users] A crashed JobMedia table in MySql.

2007-03-26 Thread Frank Sweetser
On Mon, Mar 26, 2007 at 10:30:33PM -0400, AltGrendel wrote:
 Job.JobTDate DESC LIMIT 1: ERR=Table './bacula/JobMedia' is marked as 
 crashed and should be repaired

You should be able to at least attempt repairing the mysql table before
resorting to reloading the catalog via dbscan.

http://dev.mysql.com/doc/refman/4.1/en/repair-table.html

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

-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT  business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.phpp=sourceforgeCID=DEVDEV
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] A crashed JobMedia table in MySql.

2007-03-26 Thread AltGrendel
Frank Sweetser wrote:

On Mon, Mar 26, 2007 at 10:30:33PM -0400, AltGrendel wrote:
  

Job.JobTDate DESC LIMIT 1: ERR=Table './bacula/JobMedia' is marked as 
crashed and should be repaired



You should be able to at least attempt repairing the mysql table before
resorting to reloading the catalog via dbscan.

http://dev.mysql.com/doc/refman/4.1/en/repair-table.html

  

That cleared up the problem, mysqldump suceeded. And now the solution is 
in the archive too.

Thanks Frank.

-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT  business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.phpp=sourceforgeCID=DEVDEV
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users