MySQL Forums
Forum List  »  Quality Assurance

mySQL database table disappears but leaves reference in PHPmyAdmin navigation panel
Posted by: Neil Dempster
Date: July 13, 2020 01:49PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
mySQL database table disappears but leaves reference in PHPmyAdmin navigation panel
66
July 13, 2020 01:49PM


Sorry, only registered users may post in this forum.

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.