Mysql client prompts "Cannotproceedbecausesystem..." question _ MySQL

The mysql client prompts "Cannotproceedbecausesystem..." problem bitsCN.com

The mysql client prompts "Cannot proceed because system ..."

Problems encountered during database import today:

The client prompts "Cannot proceed because system tables used by Event sched1_were found damaged at server start"

This is because the current MySQL server version is not compatible with all database tables.

Finally, we will summarize the solution:

1. copy the mysql_upgrade.exeand mysqlcheck.exe files to the APMServ5.2.6/MySQL5.1/bin directory.

2. click "Start" --> "run", Enter "cmd", and press "Enter" to Enter the DOS command line window (if our APMServ is placed in the root directory of Zone D) enter "D:", press Enter, then Enter "cd APMServ5.2.6/MySQL5.1/bin", press Enter, and then Enter

Export mysql_upgrade.exe-u root-p "(if your MySQL username is still root), press Enter. at this time, the doscommand line will prompt" Enter password: "and Enter our MySQL password, press Enter to automatically upgrade the system table structure.

3. stop APMserv and restart APMserv once. the problem can be solved.

BitsCN.com