Modify the mysql database name-PHP source code

Modify the mysql database name

1.[PHP] code

$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;}}