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...
Subject
Written By
Posted
MySql table disappears at random after multiple TRUNCATE queries
September 23, 2014 05:45PM
September 23, 2014 09:25PM
September 23, 2014 10:15PM
September 23, 2014 10:29PM
September 24, 2014 12:13AM
September 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.