MySQL Forums
Forum List  »  MySQL Administrator

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?

Options: ReplyQuote


Subject
Written By
Posted
Re: binlog file deleted accidentally
August 29, 2012 10:03AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.