Table and Database Operations - Mastering phpMyAdmin 3.1 for Effective MySQL Management - page 163

• TRANSACTIONAL , PAGE_CHECKSUM : Applies to the Maria

storage engine. Currently documented at http://dev.mysql.com/doc/
refman/5.1-maria/en/se-maria-tableoptions.html .
auto-

• increment : This changes the auto-increment value. It is shown only if

the table's primary key has the auto-increment attribute.

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 screen) can manipulate a table in two
ways—change 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.

The Copy operation leaves the original table intact and copies its structure or data
(or both) to another table, possibly in another database. Here, the book-copy table
will be an exact copy of the book source table. After the copy, we remain in the Table
view for the book table, unless we select Switch to copied table .

The Structure only copy is done to create a test table with the same structure.