How can we repair a MySQL table?

Answer Posted / malkiet

using myisamchk at prompt
or "repair table TBLNAME" command at mysql prompt.

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain triggers and stored procedures?

504


What are slow queries?

486


How can you retrieve a portion of any column value by using a select query?

455


How important is to list the column names when doing an insert?

602


What is mysql and why it is used?

572






How do I insert an image into mysql workbench?

484


What is difference between oracle sql and mysql?

501


What is the use of i-am-a-dummy flag in mysql?

567


What is mysql database server?

498


How can I compare two mysql databases?

497


What could be the reason that the mysql statement 'select avg (salary) from emp' generates an inaccurate output?

503


How can we run batch mode in mysql?

550


What is the difference between b-tree and hash indexes?

460


How to drop an existing index in mysql?

559


How do I edit a table in mysql?

503