Upgrading phpMyAdmin from an Older Version

In order to upgrade phpMyAdmin from an older version, copy the /config.inc.php from the previous installation into the new version. You may need to modify the configuration files from the old version since some options have changed or would have been removed. Case in point, the definition of $cfg[‘AttributeTypes’] would have changed so it must be removed from the file so that one can use the default file. For compatibility with PHP6, remove reference to the set_magic_quotes_runitme(0) function, a statement that may exist at the end of your configuration file.

It is important to not copy libraries/config.default.php over config.inc.php since the default configuration file is version specific. If you upgrade your MySQL server from a version previous to 4.1.2 to version 5.x or newer you should run the SQL script found in scripts/upgrade_tables_mysql_4_1_2+.sql if you use the phpMyAdmin configuration storage.

The upgrade_tables_mysql_4_1_2+.sql file is meant for use with MySQL 4.1.2 and above. If one runs MySQL 4.1.0 or 4.1.1, it is recommended to create the tables using create_table.sql before using this script. Don’t forget to set up the table names in the config.inc.php file. The file will alter the ‘pma_bookmark’ table by doing one of many things: changing the ‘db_name’ column. If the table ‘pma_designer_coords’ does not exist the upgrade_tables_mysql_4_1_2+.sql database will create the table. There will be two primary keys of ‘db_name,’ and ‘table_name’ in addition to four integer variables: two defined as INT while the others are defined as TINYINT. This table also uses the ‘MyISAM’ engine.

Sources
http://www.phpmyadmin.net/documentation/
http://isp-control.net/ispcp/browser/branches/openSUSE-11.3/gui/tools/pma/scripts/upgrade_tables_mysql_4_1_2%2B.sql?rev=3516&desc=1

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s