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.

chown -Rv mysql:mysql [database files]

 

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

yum install mysql-utilities

mysqlfrm --diagnostic [table_name].frm

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


QUICK FIX TO CHANGE THE MAX SELL POWER TO LESS THAN 500W ON THE DEYE INVERTER

QUICK FIX TO CHANGE THE MAX SELL POWER TO LESS THAN 500W ON THE DEYE INVERTER

There are many reasons a home owner or installer might want to place a tight cap on how much solar power is exported to the public grid. Some households live under a strict export cap imposed by their local distribution network operator, others want to reduce export to focus on self consumption and battery charging, […]

read more
SUPABASE BACKUP TUTORIAL: USE DBEAVER TO EXPORT YOUR DATABASE SAFELY

SUPABASE BACKUP TUTORIAL: USE DBEAVER TO EXPORT YOUR DATABASE SAFELY

If you are building anything serious on Supabase, whether that is a client portal, a SaaS app, an internal dashboard, or even a small side project that is starting to get traction, having a reliable database backup process is one of those tasks that quickly moves from optional to essential. Supabase makes a lot of […]

read more

Like our Page