Cannot Add Events to Scheduler in MySQL

MySQL includes a feature that allows you to schedule and perform tasks. MySQL Event Scheduler, as the name suggests, is responsible for scheduling and executing these events. When you create an event, you are actually creating a named database object that contains few statements to be executed by Event Scheduler at regular intervals of time. But sometimes, you find it unfeasible to add an event to this scheduler for the reason being MySQL database corruption. It is one of the typical symptoms that a corrupt MySQL database shows after getting corrupted. Thus, you require restoring from the most recent data backup. But if backup doesn’t avail you the required results, use MySQL database recovery solutions to repair and restore such databases.

You suffer an unexpected crash on your Webstrendslog server. The next time, when you try to add an event to Event Scheduler, you fail to do so. Additionally, you find that WTRS.exe is not running and you receive an error message that it could not locate the wtlicensemanager.dll file.

Causes

Unexpected crashes cause MySQL Server database to become corrupted and prevent you adding events to scheduler. A MySQL database might also get corrupted due to application code bugs, storage engine issues, virus attack and other similar reasons.

Solution

Consider these methods to recover from such situations:

• If you are using MyISAM storage engine, you need to run mysiamcheck to check database consistency:

mysqlcheck.exe -r --databases wt_sched -u Administrator -p

mysqlcheck.exe -r --databases wtmaster -u Administrator -p

Try to repair the damaged database as:

mysql –u Administrator –p 
use wtmaster 
repair table wt_servicestatus: 
exit

• If you are using InnoDB engine, database tables are automatically diagnosed and repaired after you restart MySQL if you are using innodb_force_recovery option in your config.

• If database corruption remains the same, check if backup is complete and valid. If it is, drop the damaged database and restore from backup.

• While no clean backup availability, you can use MySQL Recovery applications and safely repair your database. These MySQL Database Recovery products perform powerful scan of damaged MySQL databases and repair them as original.

Stellar Phoenix Database Recovery For MySQL is the most powerful MySQL Recovery utility. It supports both MySQL database storage engines – MyISAM and InnoDB. It can completely repair and restore MySQL objects such as tables, primary key(s) and relations. It is compatible with Windows Vista, XP, 2003 and 2000. It supports MySQL 5.x. It also supports Windows based recovery from MySQL database installed on Linux platform.