MySQL Forums :: PHP :: MySql table disappears at random after multiple TRUNCATE queries


Advanced Search

MySql table disappears at random after multiple TRUNCATE queries
Posted by: A I ()
Date: September 23, 2014 05:45PM

I have a dozen of tables that get emptied with TRUNCATE table every 10-20 seconds or so with my php script running in shell from XAMPP local machine.

For unknown reason, every couple hours a random table disappears and as a result my script stops. There are not queries in the script that would drop/delete the table

Whats interesting, is that the table gets deleted in main view, but I still can see it in the sidebar on the left.

When I try to recreate the deleted table, I get "no such table" mysql error. The way I managed to recreate it is by copying table ".frm" file from identical table, it would allow me to drop the old one via sql and recreate it again.

Did anyone ever encountered such behaviour or knows the explanation? This been driving me nuts for the past few days...

Options: ReplyQuote


Subject Written By Posted
MySql table disappears at random after multiple TRUNCATE queries A I 09/23/2014 05:45PM
Re: MySql table disappears at random after multiple TRUNCATE queries Peter Brawley 09/23/2014 09:25PM
Re: MySql table disappears at random after multiple TRUNCATE queries Rick James 09/23/2014 10:15PM
Re: MySql table disappears at random after multiple TRUNCATE queries A I 09/23/2014 10:29PM
Re: MySql table disappears at random after multiple TRUNCATE queries Rick James 09/24/2014 12:13AM
Re: MySql table disappears at random after multiple TRUNCATE queries A I 09/23/2014 10:19PM


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.