HOW TO FIX DELETING A TABLE THAT DOESN’T EXISTMarch 19, 2019 / by Marco / Categories : Business
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.
- Advertise Me Pty Ltd
Digital Signage Solutions
Limit to 5 sponsors.
OTHER ARTICLES YOU MAY LIKE
Digital signage is an innovative way to display dynamic digital content. For those of you who don’t know what it is, basically think of the screens that you have seen in retail stores and shopping centres that display advertisements. That is digital signage! Here’s an example: There are three main components that make up a […]read more
Are you looking for the best form builder for WordPress? We have the answer for you and it’s called WPForms. As the name of the product clearly indicates it’s a WordPress Forms builder. There are many form builders out there for WordPress but WPForms is one of the best because it has such an easy […]read more