Can I use ALTER DATABASE to rename a mysql database?

php mysql database pdo alter
Xerri picture Xerri · Apr 14, 2010 · Viewed 17.8k times · Source

I am using PDO with PHP to create a new database and then a new user with privileges on that database. In case one of them fails, I want to rename the database and user so that they can be deleted later and the names are available.

Is it possible to rename a mysql database using the ALTER DATABASE?

Answer

Chris J picture Chris J · Apr 14, 2010

Duplicate -- see How do I quickly rename a mysql database (change schema name)

In short, no. MySQL doesn't have a quick/simple way to rename databases. You have to use mysqladmin and mysqldump from the command line. See question above for all the details.

Related questions

PDO get the last ID inserted

I have a query, and I want to get the last ID inserted. The field ID is the primary key and auto incrementing. I know that I have to use this statement: LAST_INSERT_ID() That statement works with a …

Read More
PDO mysql: How to know if insert was successful

I'm using PDO to insert a record (mysql and php) $stmt->bindParam(':field1', $field1, PDO::PARAM_STR); $stmt->bindParam(':field2', $field2, PDO::PARAM_STR); $stmt->execute(); Is there a way to know if …

Read More
MySQL check if a table exists without throwing an exception

What is the best way to check if a table exists in MySQL (preferably via PDO in PHP) without throwing an exception. I do not feel like parsing the results of "SHOW TABLES LIKE" et cetera. There must be some …

Read More