Copying a Database
Since phpMyAdmin 2.6.1, it is possible to do a complete copy of a database, even if
MySQL itself does not support this operation natively.
Summary
In this chapter, we covered the operations we can perform on whole tables or
databases. We also took a look 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.
The Relational System
Welcome to the part of the book where we start to cover advanced features. The
relational system allows users to do more with phpMyAdmin, as we will see
in the following chapters. This chapter explains how to install the linked-tables
infrastructure, which is a prerequisite for the advanced features, and explains how
to define inter-table relations.
Relational MySQL?
When application developers use PHP and MySQL to build web interfaces or other
data manipulation applications, they usually establish relations between tables,
using the underlying SQL queries??”for example, 'get an invoice and all its items'
and 'get all books by an author'.
In the first versions of phpMyAdmin, MySQL was storing information about which
table belonged to which database, but the relational data structure (how tables relate
to each other) was not stored into MySQL.
Pages:
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169