删除所有MYSQL数据表的脚本

<?php
$hostname = ' localhost ' ;
$userid = ' user ' ;
$password = ' password ' ;
$dbname = ' dbname ' ;
$connect = mysql_connect ( $hostname , $userid , $password ) ;
mysql_select_db ( $dbname ) ;
$result = mysql_query ( " show table status from $dbname " , $connect ) ;
while ( $data = mysql_fetch_array ( $result )) {
mysql_query ( " drop table $data [Name] " ) ;
}

 

删除空间上的表,由于表太多,网速又慢,无法完成列表显示.不能用PHPMYADMIN删除.一个个删会累死...
用这个文件,一秒搞定,删除所有表.

转载于:https://blog.51cto.com/51you/779335