Synchronizing Data and Supporting Replication - Mastering phpMyAdmin 3.4 for Effective MySQL Management - page 229

As depicted in the upper part, the red S icon triggers structure synchronization,
whereas the green D icon is for data synchronization. Then, for each table, we get a
rundown of the differences. The central Difference column would be empty in the
case of identical structure and data for the corresponding table. Here we see a red S
and a green D for both tables, but the reason is not the same for each table.
The middle part shows the actions that are scheduled as part of the synchronization
process (there are currently none, as can be seen in the following screenshot):
The lower part contains a checkbox ( Would you like to delete all the previous
rows from target tables? ) and two action buttons. We will see their purpose in the
following sections:
Please note that the topic table has a plus sign ( + ) next to it on the Source side, to
show that this table is in the source database but not in the target database. We even
see a not present comment for this table on the Target side. If a table was in the
target database but not in the source one, it would be marked with a minus sign (-)
on the Target side.
At this point, we can decide that we are satisfied with the comparison and don't
want to proceed further; in this case, we would just have to continue in
phpMyAdmin by picking a database and resuming our work. We also have
the opportunity of synchronizing the databases in one sweep ( complete
synchronization ) or to make changes in a more granular way ( selective
synchronization ). Let us examine both methods.