Solved

mysql - delete a table

Posted on 2014-10-23
2
377 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 45

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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Php Sql Query 7 29
STDEVP in SQL 2 34
SQL Help joining two tables 7 33
How to simplify my SQL statement? 10 11
Introduction Hopefully the following mnemonic and, ultimately, the acronym it represents is common place to all those reading: Please Excuse My Dear Aunt Sally (PEMDAS). Briefly, though, PEMDAS is used to signify the order of operations (http://en.…
Composite queries are used to retrieve the results from joining multiple queries after applying any filters. UNION, INTERSECT, MINUS, and UNION ALL are some of the operators used to get certain desired results.​
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

707 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now