php 修改mysql数据库的名称

$setting = array(
    'databaseHost'    => '127.0.0.1',
    'databaseUser'    => 'root',
    'databasePass'    => '',
    'oldDatabaseName' => 'old_database_name',
    'newDatabaseName' => 'new_database_name',
    'execute'         => false,
);
$db      = new PDO("mysql:host={$setting['databaseHost']};dbname={$setting['oldDatabaseName']}", $setting['databaseUser'], $setting['databasePass']);
$result  = $db->query("show tables");
$tables  = $result->fetchAll();
foreach ($tables as $tableCtr) {
    $tablename = $tableCtr['Tables_in_' . $setting['newDatabaseName']];
    $sql       = "ALTER TABLE $tablename RENAME TO " . str_replace('mymps', 'mk_', $tablename);
    $sql       = "RENAME TABLE {$setting['oldDatabaseName']}.{$tablename} TO {$setting['newDatabaseName']}.{$tablename};";
    if ($setting['execute']) {
        if ($db->query($sql)) {
            continue;
        } else {
            exit($db->errorInfo());
        }
    } else {
        echo $sql . PHP_EOL;
    }
}
//该片段来自于http://outofmemory.cn