MySQL Forums
Forum List  »  PHP

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

Written By
MySql table disappears at random after multiple TRUNCATE queries
September 23, 2014 05:45PM

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.