Repairing a MySQL DB from Windows Command Line
Step 1: Open the Windows Command Line
- Go to Start >> and Search for 'cmd'. Click on 'Command Prompt' once the Search results show up. You can alternatively type in (Windows + R) to open the Run Dialog and then type in 'cmd' in the dialog and press Enter to launch the Command Prompt.
Step 2: Change your Windows Path to MySQL bin folder
- In Command Prompt, at the cursor type cd "C:\Program Files\MySQL\MySQL Server 5.6\bin". The version of MySQL differs as per your installation, as such recommended to confirm the above path from machine Windows Explorer.
- Press Enter.
Your Windows path will be now re-changed as above.
Step 3: Run the MySQL Repair Command
- At the cursor, type mysqlcheck -u root -p --auto-repair --databases [Database Name]. Replace the Square braces Database Name with the name of your database.
for e.g. mysqlcheck -u root -p --auto-repair --databases MainDB
- Press Enter. It will ask you to enter the password, type in the password for root user. By default, the password for MySQL root user is 'root'.
- The Query will execute and repair all or any table if found corrupted.
You can now launch GLOBODOX and start working with your MySQL DB.