$ErrorActionPreference = "SilentlyContinue"
# CHANGE ME IF DB CHANGES
$server = "10.208.8.48"
$username = "sa"
$password = "password"
#LEAVE ALONE FROM HERE
if (Get-Command mysql -errorAction SilentlyContinue)
{
$passwordcat = "-p" + $password
$olddb = Read-Host 'Drop db:'
if ($olddb) {
echo drop database $($olddb) | mysql -h $($server) -u $($username) $($passwordcat)
} else {
write-host "Database name cannot be empty"
}
}
else
{
write-host "PLEASE INSTALL MYSQL CLIENT AND ADD IT TO YOUR PATH"
}