HOW TO FIX DELETING A TABLE THAT DOESN’T EXIST

March 19, 2019   /   by Marco  / Categories :  Business
Business Legions - HOW TO FIX DELETING A TABLE THAT DOESN'T EXIST

In my mySQL database I noticed that there was a table missing from phpmyadmin. I tried creating the table but mySQL reported that it already exist (it was a ghost table). I tried using mysqlcheck to repair the database and it came back saying it the table didn’t exist. I then tried to create the table and mySQL returned an error message saying it already exists. That’s where I was totally CONFUSED!

After some digging around and researching, I checked the /var/lib/mysql/[database]  folder to see if the table name files existed and they were there. I deleted those files and copied them from another database but still had the same issue. After copying the files you need to change the file permissions of the copied files to the mysql service.

 

After a lot of digging around, I managed to work out the solution. I need to instal mysql-utilities and run this command:

After that, the table was fixed. You can then delete it.

 

DO YOU LIKE WHAT YOU'VE READ?
Join our subscription list and receive our content right in your mailbox. If you like to receive some Great deals our Freebies then subscribe now!

Our Sponsors

  • Follow us:

OTHER ARTICLES YOU MAY LIKE


HOW TO CONNECT THE PS3 CONTROLLER TO THE NINTENDO SWITCH

HOW TO CONNECT THE PS3 CONTROLLER TO THE NINTENDO SWITCH

Our family has a Nintendo Switch with only the 2 Joycon controllers that came with the Switch. I decided to look at getting extra controllers but I noticed we had 2 PS3 controllers from the Sony Playstation 3. After some research, I discovered there are Bluetooth dongles that allow the PS3 controllers to connect to […]

read more
HOW TO REMOVE THE GOOGLE CAPTCHA BADGE ON WORDPRESS

HOW TO REMOVE THE GOOGLE CAPTCHA BADGE ON WORDPRESS

I’ve started using the Google Captcha V3 on my websites and started noticing this badge appearing on the right-hand side of the website. The badge looks like this: I found this very annoying to look at so decided to find a way to remove it. The easiest way to remove it on WordPress is to […]

read more

Subscribe

Receive the latest news and awesome deals via email

Like our Page

Social Wall Social Wall