Jump to content
Sign in to follow this  
Bill C

MySQL - Corrupt Information_Schema DB Problem

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

Share this post


Link to post
Share on other sites
Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...