Results 1 to 4 of 4

Thread: How to repair MySQL table using MySQLCheck

  1. #1
    Join Date
    May 2015
    Posts
    1

    How to repair MySQL table using MySQLCheck

    How can I repair MySQL table using MySQLCheck when server is not running?

  2. #2
    Join Date
    May 2015
    Posts
    19
    As your server is not running then follow these steps:
    To check MySQL Table
    #mysqlcheck –c database-name table-name –u root –p
    Enter password:
    database-name.table-name OK

    To Repair MySQL Table
    # mysqlcheck –r database-name table-name –u root –p
    Enter password:
    database-name.table-name OK

    *** Link removed by Staff so it doesn't look like you're spamming us ***
    Last edited by SpywareDr; 11-22-2017 at 09:35 AM.

  3. #3
    Join Date
    Jan 2021
    Posts
    7
    After you back up your databases, you are ready to start troubleshooting. The mysqlcheck program enables you to check and repair databases while MySQL is running. This feature is useful when you want to work on a database without stopping the entire MySQL service.

    Additionally, mysqlcheck works on tables that use the MyISAM or InnoDB database engines.

  4. #4
    Join Date
    Feb 2021
    Posts
    2
    Thx you for your suggestions. Faced with a similar problem.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •