110338 - I lost my table "bugs".

Status: RESOLVED INVALID

(Bugzilla :: Bugzilla-General, defect)

Description

[Nadine]

I lost my table "bugs".

After a reboot of the computer that hosts Bugzilla, I received the
following error whenever I moved beyond the index.html page:
	show columns from bugs: Can't find file: './bugs/bugs.frm'
(errno: 13) at globals.pl line 148.
	For help, please send mail to the webmaster
([e-mail]), giving this error message and the time and
date of the error.

After checking the tables in my "bugs" database, an attempt to access
the "bugs" table, using SELECT * FROM bugs;, produced:
	Error 1017: Can't find file: './bugs/bugs.frm' (errno: 13)

I realize that I have lost all the bugs in my database, but how can I
rebuild the "bugs" table (structure), without having to reload mysql?

Are there SQL commands that can help me?  Like "CREATE TABLE bugs,
...(what fields?);

Comment 1

[Dave Miller [:justdave]]

run checksetup.pl again.  It'll recreate any table structure that's missing.

This is probably better asked on the newsgroup/mailing list