Want to drop every table in your mysql database?

Wuoshi · 11-01-2007, 05:05 AM

This script will delete every table in your database, be careful when you use it. I take no responsibility for the loss of data. Enjoy!

<html>

<body>

<?

$username="your_username";
$password="your_password";
$database="your_databse";
$host="your_hostname";

mysql_connect($host, $username, $password);
mysql_select_db($database) or die( "Unable to select database");
????: NamePros.com http://www.namepros.com/code/390831-want-drop-every-table-your-mysql.html

$query = "show tables";

$result = mysql_query($query);

while ($Row = mysql_fetch_array ($result))
{
list ($tables) = $Row;

$query2 = "DROP TABLE $tables";

$result2 = mysql_query($query2) or die(mysql_error());

}

?>

</body>
</html>

Daniel · 11-01-2007, 06:14 AM

Be very careful.

This can make you lose ALL your MySQL records.

- Just thought I'd point it out incase you run it without thought.

Dan

Wuoshi · 11-01-2007, 06:25 AM

Indeed! Only time this would be useful is when you want a clean start and don't want to drop each table manually.

11-01-2007, 05:05 AM	THREAD STARTER #1 (permalink)
Wuoshi NamePros Regular Join Date: Apr 2006 Posts: 254	Want to drop every table in your mysql database? This script will delete every table in your database, be careful when you use it. I take no responsibility for the loss of data. Enjoy! <html> <body> <? $username="your_username"; $password="your_password"; $database="your_databse"; $host="your_hostname"; mysql_connect($host, $username, $password); mysql_select_db($database) or die( "Unable to select database"); ????: NamePros.com http://www.namepros.com/code/390831-want-drop-every-table-your-mysql.html $query = "show tables"; $result = mysql_query($query); while ($Row = mysql_fetch_array ($result)) { list ($tables) = $Row; $query2 = "DROP TABLE $tables"; $result2 = mysql_query($query2) or die(mysql_error()); } ?> </body> </html> __________________ Nook Accessories - Playdough Recipe - Clay Recipe - iPad Accessories - Flap Bag - Super Foods - Alternative Cancer Cure - Chocolate Mousse Recipe - Quartz Countertops - Silly Putty Recipe - How To Cook Spaghetti Squash - Amitriptyline Side Effects

11-01-2007, 06:14 AM	#2 (permalink)
Daniel Danltn.com Join Date: May 2007 Location: Danltn.com / Nottingham, UK Posts: 1,201	Be very careful. This can make you lose ALL your MySQL records. - Just thought I'd point it out incase you run it without thought. Dan __________________ :lala: *VERY CHEAP ADVANCED* BULK DOMAIN-STATISTICS LOOKUP** :kickass: Danltn's Blog - Daniel Neville's Site Spoof your links! Submit your blog NOW! Putting bloggers on the map!

11-01-2007, 06:25 AM	THREAD STARTER #3 (permalink)
Wuoshi NamePros Regular Join Date: Apr 2006 Posts: 254	Indeed! Only time this would be useful is when you want a clean start and don't want to drop each table manually. __________________ Nook Accessories - Playdough Recipe - Clay Recipe - iPad Accessories - Flap Bag - Super Foods - Alternative Cancer Cure - Chocolate Mousse Recipe - Quartz Countertops - Silly Putty Recipe - How To Cook Spaghetti Squash - Amitriptyline Side Effects

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)