Hi
My hosts died on me in an ugly way, and I am stuck with a not working watchdog table (all other tables I was able to repair)
This results in not being able to go to /admin (/admin/block etc work) since the logs are presented on the first admin page (if this is needed in the first place is another question)
I tried to repair the table but it fails mysql> repair table watchdog; +----------------+--------+----------+-----------------------------+ | Table | Op | Msg_type | Msg_text | +----------------+--------+----------+-----------------------------+ | willy.watchdog | repair | error | 28 when writing to datafile | | willy.watchdog | repair | error | 28 when writing to datafile | | willy.watchdog | repair | status | Operation failed | +----------------+--------+----------+-----------------------------+
Since watchdog is only used for the admin, I think I can just delete the table and recreate it? Is this the case and if so, could someone give some instructions for a 4.5 instalation?
note, also on http://drupal.org/node/23268
Boerland Bert wrote:
Since watchdog is only used for the admin, I think I can just delete the
table and recreate it? Is this the case and if so, could someone give some instructions for a 4.5 instalation?
note, also on http://drupal.org/node/23268
The following 2 SQL statements should work to delete and recreate the table using MySQL:
DROP TABLE watchdog;
CREATE TABLE watchdog ( wid int(5) NOT NULL auto_increment, uid int(10) NOT NULL default '0', type varchar(16) NOT NULL default '', message longtext NOT NULL, severity tinyint(3) unsigned NOT NULL default '0', link varchar(255) NOT NULL default '', location varchar(128) NOT NULL default '', hostname varchar(128) NOT NULL default '', timestamp int(11) NOT NULL default '0', PRIMARY KEY (wid) ) TYPE=MyISAM;
-- Chris Johnson
-
Boerland Bert -
Chris Johnson