How do I change the database name using MySQL?

mysql

Solution

I don't think it's possible.

You can use `mysqldump` to dump the data and then create a schema with your new name and then dump the data into that new database.

Problem

How can I change the database name of my database? I tried to use the rename database command, but on the documents about it it is said that it is dangerous to use. Then what should I need to do to rename my database name? For example, if I want to rename my database to this. ``` database1 -> database2? ```

Original source

Related problems