Recreate table

[Andreas]

Unfortuatenly, there is no way to delete all those tables with one query.

You could do some trickery with information_schema though:
http://stackoverflow.com/questions/1...es-with-prefix

Alternatively you could run a simple script:

PHP Code:

require('./global.php');

$tables = $db->query_read("SHOW TABLES LIKE 'taggregate\_temp\__%'");
while ($table = $db->fetch_row($tables))
{
    $db->query_write("DROP TABLE `$table[0]`");
} 


No guarantees whatsoever, eg. you should be prepared to have a backup ready if anything goes wrong