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
  • 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
https://linustechtips.com/topic/680336-mysql-57-database/#findComment-8780150
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

×