Newer
Older
Import / projects / Gameloft / bne_lib / tools / SolarDB / DropDB.ps1
@John John on 29 Dec 2020 576 bytes bulk import from macbookpro checkouts
$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"
}