mySQL database table disappears but leaves reference in PHPmyAdmin navigation panel
I have been having an ongoing battle with Go Daddy regarding tables disappearing from a database but still leaving the reference to the table in the PHPmyAdmin navigation panel (Note: The table was not deleted by me.). If I click the hyperlink for the table, I receive an error: #1146 – Table ‘cps_db_sa.bdls’ doesn’t exist. This happened two months ago and because I felt the database must've been corrupted in some way I rebuilt a brand-new database from scratch (NOT using a backup restore). It has been running smoothly for two months but this morning the same thing happened although it was a different table that disappeared. Because this is a development database no other user has access; I have not created any 'write' queries as of yet (e.g., INSERT) so the only queries are fetch (e.g., SELECT). We are also on a shared hosting platform.
Go Daddy is telling me it must be something I'm doing but because this database was running smoothly for many weeks and the fact that I was not even in the database yesterday, it seems odd to now have a table just disappear like this. Have any of you experienced this phenomenon? Thank you for any input you can provide.
Subject
Views
Written By
Posted
mySQL database table disappears but leaves reference in PHPmyAdmin navigation panel
1799
July 13, 2020 01:49PM
534
July 13, 2020 02:42PM
477
July 13, 2020 02:57PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.