PhpMyAdmin Upgrade from 2.10.2 to 2.11.6

From The Uniform Server Wiki
Jump to navigation Jump to search

MPG UniCenter

PhpMyAdmin Upgrade from 2.10.2 to 2.11.6

Uniform Server 3.5-Apollo.

On the forum an interesting question was asked, how to add another language to phpMyAdmin? The answer is to download a full version of phpMyAdmin and copy required language to Uniform Server 3.5-Apollo. Unfortunately older versions (2.10.2 as used on 3.5-Apollo) of phpMyAdmin are not archived on the phpMyAdmin download site.

The above is not a viable solution hence take the opportunity and upgrade to a full version of phpMyAdmin. Sounds complicated in reality it only takes a few steps describe on this page. For portable applications the only down side it increases phpMyAdmin from 5M to 14M however if you require only a single language this can be reduced significantly.

Note: The following installation allows you to revert back to the original installation of phpMyAdmin if the upgrade does not meet your requirements.

Preparation

The changes only affect phpMyAdmin and are easily reversible hence this upgrade may be performed on a clean or current installation of Uniform Server 3.5-Apollo.

  1. Rename the following folder: *\Uniform Server\udrive\home\admin\www\phpMyAdmin
    To:
    *\Uniform Server\udrive\home\admin\www\phpMyAdmin_2
  2. Create a new folder: *\Uniform Server\udrive\home\admin\www\phpMyAdmin
  3. Copy file config.inc.php from folder phpMyAdmin_2 to folder phpMyAdmin


Note: The new version of phpMyAdmin will be copied to folder phpMyAdmin the folder phpMyAdmin_2 will allow you to easily switch back to original configuration (i.e. delete folder phpMyAdmin and rename phpMyAdmin_2 back to phpMyAdmin)

Top

Download and install

Installation is straightforward download, extract and copy the full version as follows:

  1. Go to PhpMyAdmin Downloads
  2. Download the following file: all-languages.zip
    MD5: 2bfac1aab1e5834d8841512341a11c7b
    save to any folder of your choice.
  3. Unzip (right click, extract all) to any folder of your choice.
  4. You will find two folders named: phpMyAdmin-2.11.6-all-languages
    Open the last one and copy all (folders and files) its content to folder
    *\Uniform Server\udrive\home\admin\www\phpMyAdmin

Top

Test

Run Uniform Server, from apanel run phpMyAdmin make sure you can access your MySQL server, that’s it.

Top

Reduce footprint

Having all language files installed will increase Uniform Server’s footprint this can be reduced by deleting any languages you do not require. If you only require English open the folder:

*\Uniform Server\udrive\home\admin\www\phpMyAdmin\lang

Delete all files in this folder with the exception of:

  • english-iso-8859-1.inc.php
  • english-iso-8859-15.inc.php
  • english-utf-8.inc.php

This reduces the footprint by about 8.7M note the files with the extension .sh are Unix shell files and can be safely removed on Windows machines.

Alternatively download english.zip reduces download time and the effort of deleting files.

Note: Once you are happy with your new version of phpMyAdmin to further reduce Uniform Server’s footprint delete folder phpMyAdmin_2.

Conclusion

This upgrade is relatively quick and painless well worth the time and effort.

Top


Ric