How do I repair a database table?

Question

How to Repair a Corrupted MySQL table Open a command prompt on your Windows server and enter the following: (replace the values with your MySQL username, password, and database name) mysqlcheck -u -p –databases mysql -u -p use ; REPAIR TABLE ``;

How do you repair a MySQL database table?

On the left, select Hosting Features > MySQL > PhpMyAdmin. Select the correct database from the list on the left. Select the check box corresponding to the corrupted table, and from the With selected list, click Repair table.

How do you fix a broken database?

Automatically compact and repair a database when it closes1Select File > Options.2In the Access Options dialog box, select Current Database.3Under Application Options, select the Compact on Close check box.4Select OK.5Close and reopen the database for the option to take effect.

What is repair table?

If you use the QUICK option, REPAIR TABLE tries to repair only the index file, and not the data file. This type of repair is like that done by myisamchk --recover --quick. If you use the EXTENDED option, MySQL creates the index row by row instead of creating one index at a time with sorting.

How do I reindex a table in MySQL?

Luckily, it's easy for MySQL to optimize index data for MyISAM tables. You can use the OPTIMIZE TABLE command to reindex a table. In doing so, MySQL will reread all the records in the table and reconstruct all of its indexes. The result will be tightly packed indexes with good statistics available.

Expert · Answer