ResumesInn
Welcome  ,
Interview Questions >> PHP >> How can we repair a MySQL table?
Next Question Previous Question

How can we repair a MySQL table?



  Joseph Ranjan wrote ...
we can repair a table by using REPAIR TABLE command.

There exists two Modes ...
1) QUICK :

Ex.
  REPAIR TABLE tablename QUICK

If QUICK is given, MySQL will do a repair of only the index tree.

2) EXTENDED :

Ex.  REPAIR TABLE tablename EXTENDED

If EXTENDED is given, it will create index row by row.


Login to write answer for this question !
Want to place your ads in this website ?
50USD Per Month for single placement. Contact Us
All Rights Reserved . Developed by SJRANJAN