How to drop all tables from db?

[chriss]

Topic

[Barand]

Quickest way is drop database then recreate it.

[chriss]

I understand, but I have no permission to create/drop db.

[Barand]

[php:1:c425fae520]<?php

$db_name = \'your db name\' ;

 

$cnx = mysql_connect(\'host\' , \'user\' , \'pwd\');

mysql_select_db($db_name);

$res = mysql_list_tables($db_name);

while ($row = mysql_fetch_row($res)) {

$table = $row[0];

echo \"Dropping $table <br>\";

mysql_query(\"DROP TABLE $table\");

}

?>[/php:1:c425fae520]

 

hth

[chriss]

Thank You very much!