Re: binlog file deleted accidentally
Posted by:
Raz Salton
Date: August 29, 2012 10:03AM
Hello Scott,
I start getting the following warning message on syslog after fixing of binlog.
'./mydatabase/watchdog' is marked as crashed and should be repaired\nquery: INSERT INTO watchdog\n (uid, type, message, variables, severity, link, location, referer, hostname, timestamp)\n VALUES\n (96985, 'php', '%message in %file on line %line.', 'a:4:{s:6:\\"%error\\";s:12:\\"user warning\\";s:8:\\"%message\\";s:541:\\"Tab
I was going to run "REPAIR TABLE watchdog;" on command line but wanted to backup before run it so when I tried to backup I received the following error message:
mysqldump: Got error: 145: Table './mydatabase/watchdog' is marked as crashed and should be repaired when using LOCK TABLES
Is it safe to run "REPAIR TABLE watchdog;" command without backup of database?