---
title: "How can we repair a MySQL table?"  
description: "How can we repair a MySQL table?"  
author: "Anonymous User"  
published: 2012-05-04  
updated: 2020-09-15  
canonical: https://www.mindstick.com/interview/1438/how-can-we-repair-a-mysql-table  
category: "php"  
tags: ["php"]  
reading_time: 1 minute  

---

# How can we repair a MySQL table?

The syntax for repairing a MySQL table is:\
\
REPAIR TABLE tablename\
REPAIR TABLE tablename QUICK\
REPAIR TABLE tablename EXTENDED\
\
This command will repair the table specified.\
If QUICK is given, MySQL will do a repair of only the index tree.\
If EXTENDED is given, it will create index row by row.

## Answers

### Answer by Anonymous User

The syntax for repairing a MySQL table is:\
\
REPAIR TABLE tablename\
REPAIR TABLE tablename QUICK\
REPAIR TABLE tablename EXTENDED\
\
This command will repair the table specified.\
If QUICK is given, MySQL will do a repair of only the index tree.\
If EXTENDED is given, it will create index row by row.


---

Original Source: https://www.mindstick.com/interview/1438/how-can-we-repair-a-mysql-table

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.