MySQL 5.7 database: Table has crashed and last repair failed

15 pts.
Tags:
Database
MySQL
I have MySQL database, but two days ago, I stumbled upon an issue - Table is crashed and last repair failed. I don't know how to solve this issue. I need to get MySQL recovery tool.
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

You can use only 4 recover steps or apply more variable and effective
solution as https://mysql.recoverytoolbox.com/ Recovery Toolbox for MySQL
it uses different methods for recover mysql databases.

 

Step 1. Log into mysql as administrator

mysql -uroot –p

Step 2. Select the database containing the corrupted table, i.e., ‘use
{database name};’

mysql> use {database name};

Step 3. Show tables your corrupted table should be listed

mysql> show tables;

Step 4. Repair table

mysql> repair table {bad_table_name};

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Subhendu Sen
    First stop MySQL process/service. Then navigate to MySQL data folder / directory & try running this, myisamchk -r yourtablename. There are several parameters but try with simple one first. You can also try with repair command. If there is PHP / PHPMyAdmin then there are more other procedure to repair the same. Also OS is a factor in this regard.
    138,560 pointsBadges:
    report
  • heraturs
    Thank you for suggestion, I hope I will resolve an issue.
    15 pointsBadges:
    report
  • Genderhayes
    Try downloading the innodb recovery tool version 0.3
    10,720 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: