Re: MySql table disappears at random after multiple TRUNCATE queries

[A I]

In the main view of Phpmyamin. Anyway, I switched to DELETE instead of TRUNCATE and believe the problem will not be back, I suspect the problem was related to this part of reference manual:

***

Logically, TRUNCATE TABLE is similar to a DELETE statement that deletes all rows, or a sequence of DROP TABLE and CREATE TABLE statements. To achieve high performance, it bypasses the DML method of deleting data. [...] Although TRUNCATE TABLE is similar to DELETE, it is classified as a DDL statement rather than a DML statement. It differs from DELETE in the following ways in MySQL 5.5:

Truncate operations drop and re-create the table, which is much faster than deleting rows one by one, particularly for large tables.


***

So I guess at some point re-creation part of TRUNCATE fails if you abuse it the way I did.