stojg/remove-tmp-db.php

## remove-tmp-db.php
<?php
/**
 * This script will drop all the databases that contains this string 'tmpdb'.
 * Those databases are likely to be left over from a SilverStripe test run
 * Usage: Make sure you change the db connection string below and run the
 * script like:
 *     php remove-tmp-db.php
 */

// Change this to your db connection
$host = '127.0.0.1';
$user = 'root';
$password = '';

error_reporting(E_ALL | E_STRICT);

$dbConn = mysql_connect($host, $user, $password);
$result = mysql_query('SHOW DATABASES;');
$toDrop = array();
while($row = mysql_fetch_assoc($result)) {
	$schema = $row['Database'];
	if(stristr($schema,'tmpdb')) {
		$toDrop[] = $schema;
	}
}

for($idx=1; $idx <= count($toDrop); $idx++) {
	$schema = $toDrop[($idx-1)];
	echo '[-] '.$idx.'/'.count($toDrop).' Dropping '.$schema.PHP_EOL;
	mysql_query('DROP DATABASE '.$schema);
}

echo '[+] Done, all temporary databases has been dropped.'.PHP_EOL;