phpMyAdmin – Display Export Templates

phpmyadmin

phpmyadmin no longer displays the export templates section after an update

Do you know how to display this section?

Current phpmyadmin version
4.9.5deb2

Best Answer

phpMyAdmin can use a special database, called the phpMyAdmin Configuration Storage, to enable a whole range of advanced features, including the export templates. Along with this, there is usually an additional user, the controluser, added to give phpMyAdmin permissions to work with the database in a shared environment. While phpMyAdmin makes efforts to work around any of these through a zero-configuration feature, it's suggested that to use these features, the database and tables must exist, and the controluser and table names must be set in the configuration file, config.inc.php.

Since you are using the Debian packaged version, the installer should have attempted to create (or migrate) all of this for you automatically. Perhaps there was an authentication problem or some other error during installation. You should try to run the post-install script again with dpkg-reconfigure -plow phpmyadmin.

For a user who has installed their own phpMyAdmin outside the package manager, I would suggest following the installation steps from the documentation; create the control user, import the sql/create_tables.sql, and add the configuration directives to config.inc.php. But in this case, the package manager should do all of that for you and attempting to manage things by hand could cause difficulty.

Related Solutions

Cannot use phptheadmin in XAMPP

This appears to be a problem with a recent XAMPP release, my suggestion is to roll back to a previous XAMPP version.

That being said, the phpMyAdmin way of fixing it would be:

Comment out the pma__tracking line in config.inc.php. You may also need to comment out the pma__column_info line as well. This will allow you to start phpMyAdmin without the constant error messages.
Start phpMyAdmin normally
Run the included sql/create_tables.sql (making modifications if needed to match the XAMPP naming scheme)
Remove the comments in config.inc.php

Of course, I can't say whether that will also work for XAMPP.

Mysql – Auto update “TIMESTAMP” column only when a manual phptheadmin edit occurs

The defaults for TIMESTAMP are quite limited. Instead of depending on it, take charge. You should supply values when you need them:

UPDATE tbl  SET
        ...,
        ts = NOW()   -- Include this when you need it; else leave it out.
    WHERE ...