Databases Reference
In-Depth Information
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.
Summary
This chapter covered the operations we can perform on entire tables or databases.
It also looked at table maintenance operations for table repair and optimization,
changing various table attributes, table movements (including renaming and moving
to another database), and multi-table operations.
In the next chapter, we will begin to examine advanced features that rely on the
phpMyAdmin coniguration storage, such as the relational system.
Search WWH ::
Custom Search