Database operations

The Operations tab in the Database view gives access to a panel that enables us to perform operations on a database taken as a whole as shown in the following screenshot:

Database operations

Renaming a database

A Rename database to dialog is available. Although this operation is not directly supported by MySQL, phpMyAdmin does it indirectly by creating a new database, renaming each table (thus sending it to the new database), and dropping the original database.

Copying a database

It is also possible to do a complete copy of a database, even if MySQL itself does not support this operation natively. The options are similar to those already explained for the table copy.

Copying a database
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.226.88.110