Best unofficial Apache Server developers community
Username
Forgot password?
Sign in with Twitter account
Sign in with Facebook account

Adding index failed.. now can't view or edit table

⇧
0
⇩
82 views

I was adding an index on a column and the server timed out. Now all other tables in the database work fine, but I am unable to access the table I was adding an index on. It does not allow me to delete its contents or the table. It just hangs while running the queries and nothing happens.

Any ideas on a possible solution?

MySQL 5.1

mysql
asked February 21, 2011 4:29 pm CST
krio
posted via StackOverflow

1 Answer

⇧
2
⇩
 

Try the REPAIR TABLE command. Details at http://dev.mysql.com/doc/refman/5.1/en/repair-table.html

answered February 21, 2011 5:23 pm CST
David Gillen

Your answer

Join with account you already have

Sign in with Twitter account
Sign in with Facebook account
Sign in with Google Friend Connect

Preview
Similar questions
Adding index on large table takes forever
January 4, 2011
CouchDB: Adding fields to "doc" in view
January 12, 2011
Mysql view index
January 24, 2011
Adding "/index.html" to paths in Vim
January 9, 2011
Phpmyadmin or other mysql gui - edit whole table from one screen
October 26, 2010
Create table from select then alter table by adding an auto increment column in mysql
January 11, 2011
Deleting a Table Row with a Table View
January 3, 2011
View current table order
January 30, 2011
How to view a datas in table in android
February 5, 2011
Drop table view, 1051 error
February 17, 2011
Adding a table to a search
February 20, 2011
PHP: fopen failed "HTTP Request Failed", but response header has a status code 200
January 16, 2011
Postfix - User unknown in virtual mailbox table + authentification failed
January 31, 2011
How to optimize MySQL query which contains table and left join of sql view
February 15, 2011
Adding foreign key constraint locks up table
December 28, 2010
Adding ID (auto increment) after table exist?
January 28, 2011
Adding image files to database table
January 4, 2011
MySQL table joins, nested select statements, or create a view?
February 17, 2011
What does the Alter Table syntax look like for adding a DATETIME column?
January 26, 2011
What are the consequences of adding a column to an exiting HIVE table ?
February 21, 2011
Visual Studio Advanced Query Builder MySql adding "def." before table names
January 9, 2011
Visual Studio Advanced Query Builder MySql adding “def.” before the table names
January 20, 2011
Which table column to Index?
February 7, 2011
How to create index in two table mysql?
January 13, 2011
How do I add index to a column in existing table??
February 20, 2011
How to properly index a many-many association table?
January 17, 2011
Index on a table you must fully scan anyway? (MySQL)
January 7, 2011
Innodb add index - table '#sql_...' is full
February 14, 2011
How to set index of a MySql table using WHERE, RANGE and SORT?
January 28, 2011
MySQL: should I reset a table index / optimize after deletion of many rows?
February 4, 2011