MySQL: 002 : Repair corrupted MySQL DB

MySQL: 002 : Repair corrupted MySQL DB

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.

    • Related Articles

    • Migrate v10 Globodox MySQL DB

      Step 1: Backup DB on old machine Follow instructions from the link below to take a backup of the MySQL DB... Note: Make sure you take a backup of all the DBs. Make sure you ...
    • ODBC drivers for MySQL based DB

      If you are using GLOBODOX v9 or below... Please download the ODBC connector for MySQL from the link below... Run the msi file on all the machines on which ...
    • MySQL: 001 : Unknown MySQL server host 'Server_Name'

      Causes :  The error indicates that the logged in Windows user does not have permission to connect to MySQL. This could be due to restricted or limited access on MySQL. Solution : You will have to provide permissions for the MySQL root user, as this ...
    • Find if your GLOBODOX DB is MS Access based, MySQL Server based or MS SQL Server based

      Start GLOBODOX and go to Settings Click on DB List under System Settings Under the column name Type, you will find the type of DB (please refer to the screenshot below) That's it!
    • MySQL : 004 : Can't connect to MySQL server

      Error:              Message:      Failed to connect to database 'MainDB'. (ErrNo:-2147467259       Details:[MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on '(machinename)/(ipaddress)' (10060)) Cause: The error message indicates that GLOBODOX ...