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.
- Rename the following folder: *\Uniform Server\udrive\home\admin\www\phpMyAdmin
To:
*\Uniform Server\udrive\home\admin\www\phpMyAdmin_2 - Create a new folder: *\Uniform Server\udrive\home\admin\www\phpMyAdmin
- 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)
Download and install
Installation is straightforward download, extract and copy the full version as follows:
- Go to PhpMyAdmin Downloads
- Download the following file: all-languages.zip
MD5: 2bfac1aab1e5834d8841512341a11c7b
save to any folder of your choice. - Unzip (right click, extract all) to any folder of your choice.
- 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
Test
Run Uniform Server, from apanel run phpMyAdmin make sure you can access your MySQL server, that’s it.
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.
Ric |