Rename a database

Warning:

• It is potentially dangerous to rename a MySQL database. We strongly recommend that you perform a backup of the MySQL database before you attempt to rename it.

• When you rename a database, the system terminates all active connections to the database.

• You must manually update configuration files and applications to use the new database name.

• The system requires more time to rename larger and more complex databases.

To rename a database, perform the following steps:

1. In the Current Databases table, click Rename for the desired database.

2. Enter the new database name in the New name text box.

3. Click Proceed.

MySQL does not allow you to rename a database. When cPanel & WHM "renames" a database, the system performs the following steps:

1. The system creates a new database.

2. The system moves data from the old database to the new database.

3. The system recreates grants and stored code in the new database.

4. The system deletes the old database and its grants.

Warning:

• If any of the first three steps fail, the system returns an error and attempts to restore the database's original state. If the restoration process fails, the API function's error response describes these additional failures.

• In rare cases, the system creates the second database successfully, but fails to delete the old database or grants. The system treats the rename action as a success; however, the API function returns warnings that describe the failure to delete the old database or grants.

 

Was this answer helpful?

0 Users Found This Useful