Renaming, moving, and copying tables
The Rename operation is the easiest to understand—the table simply changes its name and stays in the same database.
The Move operation (shown in the following screenshot) manipulates a table in two ways—changes its name and also the database in which it is stored.
Moving a table is not directly supported by MySQL. So, phpMyAdmin has to create the table in the target database, copy the data, and then finally drop the source table. This could take a long time depending on the table's size.
The Copy operation leaves the original table intact and copies its structure or data (or both) to another table, possibly in another ...
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.
