Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

mysql - delete a table

Posted on 2014-10-23
2
391 Views
Last Modified: 2014-10-23
I have a table in a database in MySQL.  The table has stopped responding to queries and will no longer return any data.  It has 42000 records and no index.  I have tried to delete the data (I have a copy I can get the data back from), add an index, drop the table all no no avail.  My requests run for about an hour and twenty minutes and then time out.

Can anyone suggest how I can get rid of this table.  I have MySQL Workbench and Toad for MySQL available.
0
Comment
Question by:Nemetona
2 Comments
 
LVL 48

Accepted Solution

by:
Vitor Montalvão earned 250 total points
ID: 40399256
TRUNCATE TABLE YourTableName
0
 
LVL 7

Assisted Solution

by:Stampel
Stampel earned 250 total points
ID: 40399265
Use mysqlcheck to check database
and finally
DROP Table Table_Name
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

If you find yourself in this situation “I have used SELECT DISTINCT but I’m getting duplicates” then I'm sorry to say you are using the wrong SQL technique as it only does one thing which is: produces whole rows that are unique. If the results you a…
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

838 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question