Jump to content

MySQL - Corrupt Information_Schema DB Problem


Bill C
 Share

Recommended Posts

Hi,

 I'm just posting this in the hope it might save someone else a little time one day. I went to do a database backup using SQLyog Community version. I hit an error which said  'tables used by Event Scheduler were found damaged at server start' . It took me a bit of Googling before I found a fix. I was just about to run an upgrade on MySQL in the hope of fixing the problem and one last Google came up with the solution. Love it. Anyway, the fix was to run this command from the command prompt ( In Windows) : mysql_upgrade -u root -h localhost -p --verbose --force

Found the fix here : https://serverfault.com/questions/562282/mysqldump-error-1557-corrupt-event-table/562303    

 

  • Like 3
Link to comment
Share on other sites

 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...