Databases Reference
In-Depth Information
Configuring a basic tracking mechanism
In
config.inc.php
, for a specific MySQL server's configuration, the
$cfg['Servers'][$i]['tracking']
should contain the name of the tracking table;
the suggested name is
pma_tracking
to match the default value inside
scripts/
create_tables.sql
.
If this directive is left blank, no tracking is possible on this
server (we won't see any
Tracking
menu).
By default, tracking must be activated per table. If we prefer that the tracking
mechanism be switched on automatically for all future tables and views, the
$cfg['Servers'][$i]['tracking_version_auto_create']
can be set to
TRUE
.
Please note that this is only for future tables and views—we still need to activate
tracking for existing tables.
The advantage of using automatic creation is that we don't have to think about it;
tracking is done from the birth of a table. An inconvenient side effect of this is that
we don't have the possibility of choosing which statements will be tracked; these will
be taken from the default list (refer to the
Choosing the statements to be tracked
section
later in this chapter).
Other configuration directives will be discussed in the section that relates to them.
Principles
This section defines important principles on which the tracking mechanism is based:
versioning, snapshot, and the archiving issues of tracking information.
Versioning
Using version numbers is something we are familiar with; for example, this topic
describes phpMyAdmin version 3.4.x. However, at this point we must understand
exactly why we use version numbers.
A good reference on software versioning is located
in Wikipedia at
http://en.wikipedia.org/wiki/Sof
tware_versioning
. This article mentions
that version names can be used, but version numbers are more common. More
importantly, it states that version numbers "correspond to new developments in
the software".
Search WWH ::
Custom Search