The following has been tested on a Cloud9 server with the following versions:
There is a bug in this version, and when ones trying to export, the following error appears :
Fatal error: Cannot 'break' 2 levels in /usr/share/phpmyadmin/export.php on line 864
In newer versions of phpMyAdmin, the problem is solved, but I don't have enought space on
my server to upgrade Ubuntu thanks to apt-get upgrade
. So I explain on this page
how to upgrade only phpMyAdmin.
First, change diretory for /usr/share/ and backup previous version of phpMyAdmin (just in case ...):
cd /usr/share/
sudo mv phpmyadmin/ phpmyadmin-4.0.10/
Download and extract the last version of phpMyAdmin. I my case, I uploaded version 4.7.7 which is not the newest, but is the version installed on my production server:
sudo wget https://files.phpmyadmin.net/phpMyAdmin/4.7.7/phpMyAdmin-4.7.7-all-languages.zip
sudo unzip phpMyAdmin-4.7.7-all-languages.zip
Set the downloaded version as current version:
# Symbolic link:
sudo ln -s phpMyAdmin-4.7.7-all-languages phpmyadmin
# OR folder copy:
sudo mv phpMyAdmin-4.7.7-all-languages phpmyadmin
Now set the proper permissions on files (not sure this mandatory for an upgrade), from How to Install and Secure PhpMyAdmin on Linux using Source Archive:
### Debian based system
sudo chown -R www-data:www-data /usr/share/phpmyadmin
sudo chmod -R 755 /usr/share/phpmyadmin
### Redhat based system
sudo chown -R apache:apache /usr/share/phpmyadmin
sudo chmod -R 755 /usr/share/phpmyadmin
Restart Apache, your new version is installed.
sudo service apache2 restart