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

Performing a complete synchronization
If we don't want to ask ourselves too many questions and just need a complete
synchronization, we click on Synchronize Databases . Note that in this case, we don't
have to use any red S or green D icons.
If one of the target tables contains some rows that are not present
in the corresponding source table, these will remain in the target
tables, unless we tick the Would you like to delete... checkbox. This
is a safety net to avoid unintended loss of data. However, we should
select this option if we want an exact synchronization.
After clicking, we obtain the following message: Target database has been
synchronized with source database . In the lower part of the screen, we see the
queries that had to be executed in order to achieve this operation. We also get a
visual confirmation that the databases are now synchronized:
Performing a selective synchronization
If we prefer to be more cautious and receive a preliminary feedback on the actions
that are about to be done, we can synchronize selected tables. This section assumes
that the databases are in the same state as at the end of the Preparing for the
synchronization exercise section, covered previously in this chapter.
If we click on the red S icon on the line describing the author table, this S icon turns
to grey and the middle part of the screen is updated with the actions to be done, as
shown in the following screenshot:
No real action on the data has been done yet! We still can change our mind by
clicking on the same icon which would turn back to red, removing the proposed
changes as depicted in the middle part of the screen.