Create a database with a similar name ( us_business_db) and move the good stuff into it. Your current database with the corrupt table is called us_businessdb.
![delete mysql database workbench 8 delete mysql database workbench 8](https://downloads.guru/i/win10/MySQL-Workbench_main_window_11868_650x200.jpg)
Then, transfer all the good tables into that other database. If you have a previous mysqldump of that table's data, you could load it into another database. My condolences on this table's detachment. Back in June/July of 2015, I answered 3 questions about a similar situation (where mysqld crashes accessing the table data). That table, us_businessdb.tbl_company may have a broken data dictionary entry. I had just updated about 12 million records so I'm sure it was a setting issue somewhere since my HD has plenty of space.
#Delete mysql database workbench 8 full
This corrupt table originated from a table is full error when I was updating a single column.
![delete mysql database workbench 8 delete mysql database workbench 8](https://i.stack.imgur.com/qqAWC.png)
#Delete mysql database workbench 8 install
Since it's a clean MySQL Server install on Linux, previously I just reinstalled MySQL server to get rid of the error on MySQL startup for missing files where I deleted the db file manually, but this is a pain and I'm sure there is a better way. What do I do to fix this? The only thing I know to do is delete the file manually but then I get errors when MySQL loads and I'm sure there has to be a better way to do this.Īnd also for the record, I have recreated this database several times and this same table which is the main table keeps corrupting (which is another issue in itself that I will reserve for another question). I just want to drop this table and reload it with the original data that I dumped originally.
![delete mysql database workbench 8 delete mysql database workbench 8](https://dev.mysql.com/doc/workbench/en/images/wb-manage-server-connections-connection.png)
When I try to query on the table this is what I get. How do I delete this table from the database? I have a corrupt table and I can't delete it to restore it.