Jump to content
Please Use CODE Tags

mysql 5.7 database

rappers36
By rappers36
in Programming
 Share
Go to solution Solved by jusbancief,

One of the popular and effective methods below, in case it can't help, then mysql database is seriously damaged, I would advise you to apply Recovery Toolbox for MySQL, its features and demo see on https://mysql.recoverytoolbox.com/ it was created for high complicated cases, when other solutions don't work.

 

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};

Posted

Couple days ago I got an issue: Index file is crashed. I opened it second time, but the same error. I don't know the methods of recovery mysql database. Any solutions or advice, please, guys...

Link to comment
Share on other sites
Link to post
Share on other sites
Posted

Where do you get the Error, on the browser, phpmyadmin, web app, when you login to youre mysql database?

Link to comment
Share on other sites
Link to post
Share on other sites
Posted
2 hours ago, rappers36 said:

I got a problem on Oracle Solaris.

Sry have no experiences with that. I mostly use Debian or Ubuntu.

Link to comment
Share on other sites
Link to post
Share on other sites
Posted
  • Solution

One of the popular and effective methods below, in case it can't help, then mysql database is seriously damaged, I would advise you to apply Recovery Toolbox for MySQL, its features and demo see on https://mysql.recoverytoolbox.com/ it was created for high complicated cases, when other solutions don't work.

 

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};

Link to comment
Share on other sites
Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing Programming

×