Databases Reference
In-Depth Information
It's perfectly possible to pick the same server on both the source and target sides;
however, we would at least choose a source database different to the target one in
this case. Another common case is to pick the current server and some database as
the source, and a remote server with the same database as the target, assuming that
the remote server is the production one and that both servers hold a database with
the same name.
For this exercise, let us pick
Current connection
for both source and target servers;
we can then choose
marc_book
as the source database and
marc_book_dev
as the
target one, as shown in the following screenshot:
After clicking on
Go
, phpMyAdmin attempts to connect to the servers if needed. At
this point, a connection error message may be displayed. However, the connection
should hopefully succeed and the program will start comparing both databases and
then show us the results.
Analyzing comparison results
The comparison results panel contains three sections. The first section displays
the structure and data differences, and contains icons that will be used to initiate a
selective synchronization:
Search WWH ::
Custom Search