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:
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 ...
Get Mastering phpMyAdmin 3.4 for Effective MySQL Management now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
