tags:

views:

32

answers:

1
Q: 

Repairing table in mysql

hi guys,

i tried to repair a table in mysql .... but it returned an error like ..

The storage engine for the table doesn't support repair

plz try to help..

+1  A: 

Check which storage engine the table is using:

SHOW TABLE STATUS LIKE 'tablename';

REPAIR TABLE only works for the MyISAM, ARCHIVE and (lately) CSV storage engines, according to the documentation. For other storage engines your best bet is to restore the table from backup.

Emil Vikström  2010-01-05 05:55:07

related questions

Updating a table within a select statement
How do I make an expression inside a select statement without it being returned as column?
Updating multiple rows with a value calculated from another column
How to perform grouped ranking in MySQL
MySql : UNION is not getting executed when executed as a view
MySql Union not getting executed in a view
Removing an Appended " In front of Every Column
Best way to prevent a value from going negative in mysql
Copy MySQL structure across servers via PHP
How can I query from 2 dates ranges (mysql)
MySQL function to insert record if update fails?
Rather difficult mySQL problem ...
PHP / MySql Verbosity VS over the wire
SQL to search and replace in mySQL
How to Avoid Throwing An Error When SQL Select Returns Nothing
MySQL permissions issue - should be non-issue
mysql stored procedure question
Mysql efficient "select id else insert" query
MySQL - A difficult INSERT...SELECT on the same table [MySQL 5.051]
Can I concatenate multiple MySQL rows into one field?
search question
Checking if mysql_query returned anything or not
How can I create a MySQL JOIN query for only selecting the rows in one table where a certain number of references to that row exist in another table?
MySQL Query: LIMITing a JOIN
Multiple Updates in MySQL