For MyISAM, a similar result can be obtained by
using the MERGE storage engine (which is a collection of identical MyISAM tables) but
if the table is InnoDB, we need to rely on phpMyAdmin's Copy feature.
Multi-Table Operations
In the Database view, there is a checkbox next to each table name and a drop-down
menu under the table list. This enables us to quickly choose some tables and perform
an operation on all those tables at once. Here we select the book-copy and the book
tables, and choose the Check operation for these tables.
We could also quickly select or deselect all the checkboxes with
Check All / Uncheck All.
Table and Database Operations
[ 168 ]
Repairing an "in use" Table
The multi-table mode is the only method (unless we know the exact SQL query to
type) for repairing a corrupted table. Such tables may be shown with the in use flag
in the database list. Users seeking help in the support forums for phpMyAdmin often
receive this tip from experienced phpMyAdmin users.
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.
Chapter 10
[ 169 ]
Renaming a Database
Starting with phpMyAdmin 2.6.0, a Rename database 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.
Pages:
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168