How to Cancel a Repair Process in MySQL

You might want to cancel a repair process on your MySQL server if, for example, the process has stalled and become unresponsive. MySQL incorporates a repair tool that allows developers to run processes aimed at repairing specific tables in a database. You can cancel a repair process by typing two specific commands in your MySQL console.

Instructions

1. Open your MySQL console and log in to it. Alternatively, if your MySQL database is on a virtual private server, open phpMyAdmin and click the "Console" tab.

2. Type the following command in the console:

   show full processlist

   Press the "Enter" key on your keyboard. This command lists the processes that are currently running. Note the ID number and the name assigned to the repair process cluster.

3. Enter the following command in the console:

   stop process X Y

   Replace "X" with the ID number assigned to the repair process cluster and "Y" with its name. Press the "Enter" key on your keyboard. Your MySQL engine will stop that process.

References

• MySQL: Show Processlist Syntax
• MySQL: The stop process Command