Tuesday, February 8, 2011

phpMyAdmin Upgrade Process

  • rename the existing 'phpmyadmin' directory to 'old_phpmyadmin' before creating a new directory with the upgraded version (to permit you to revert to the previous version if you experience any issues after the upgrade)
  • copy the existing .htaccess file used to restrict access to the phpMyAdmin application into the directory with the upgraded version so that authentication to the application will remain unchanged
  • copy the first three connection blocks in the config.inc.php4 file to the new config.inc.php file; if you have more than three connections currently set up in config.inc.php4, you will need to copy those over manually
  • create a new phpMyAdmin directory (named phpMyAdmin-3.3.3-all-languages) with the upgraded version of the application
  • create a symbolic link for this new directory named 'phpmyadmin' so that the URL used to access the application will remain unchanged; this will also permit us to perform future upgrades easily.
To upgrade the version of phpMyAdmin:
  1. Login to your account using an SSH client such as PuTTY.
  2. Move into the directory where your 'phpmyadmin' directory is located. For example, if you have a 'phpmyadmin' directory inside your 'wwws' directory you would move into the wwws directory by typing: cd wwws
  3. To install the most recent version of phpMyAdmin available on Webserve, type the following: install_phpmyadmin
The above command, when run in a directory with no 'phpmyadmin' directory, will result in a completely new installation of phpMyAdmin. For new installations, the config.inc.php file will be blank and a new .htaccess file will be installed which will restrict access to the account name only. Blocks that have been commented out begin with "//". To use these blocks, after you have added the connection information you will need to remove the "//" at the start of each line in order to establish a connection. source  webmaster.iu.edu