#/bin/bash

# Download latest package
wget https://www.phpmyadmin.net/downloads/phpMyAdmin-latest-all-languages.tar.gz -O latest.tar.gz

# Create temp folder
mkdir ./phpmyadmin

# Decompress latest package
tar --extract --file=latest.tar.gz --strip-components=1 --directory=./phpmyadmin

# Backup the config file (if exist)
cp /usr/share/phpmyadmin/config.inc.php ./config.inc.php

# Backup the previous install
sudo mv /usr/share/phpmyadmin /usr/share/phpmyadmin-bkp

# Move to /user/share/
sudo mv ./phpmyadmin /usr/share/phpmyadmin

# Restore the config file (if exist)
cp ./config.inc.php /usr/share/phpmyadmin/ 

# Generate temp folder
mkdir /usr/share/phpmyadmin/tmp

# Change to www-data group
sudo chgrp www-data /usr/share/phpmyadmin/tmp
sudo chmod ug+rwx /usr/share/phpmyadmin/tmp

# Restart services
sudo service apache2 restart
sudo service mysql restart

# If fail, restore backup
# sudo mv /usr/share/phpmyadmin/ /usr/share/phpmyadmin-fail/
# sudo mv /usr/share/phpmyadmin-bkp/ /usr/share/phpmyadmin/
# sudo rm -rf /usr/share/phpmyadmin-fail/

# If success, remove backup folder
# sudo rm -rf /usr/share/phpmyadmin-bkp/