In this tutorial, we will show you how to install phpMyBackupPro on Ubuntu 14.04. For those of you who didn’t know, phpMyBackupPro is a great and helpful web-based application for backing up MySQL databases. With this free and PHP-based application, you can create a backup of your database with just a few clicks. You can also schedule your backups, manage, download, restore the backups, and a lot more. PMBP also supports three compression levels of backups (No compression, zip, or gzip compression). It also supports two alternative security login methods, HTTP and HTML authentication.
This article assumes you have at least basic knowledge of Linux, know how to use the shell, and most importantly, you host your site on your own VPS. The installation is quite simple. I will show you the step-by-step installation phpMyBackupPro in Ubuntu 14.04 server.
Prerequisites
- A server running one of the following operating systems: Ubuntu 14.04, and any other Debian-based distribution like Linux Mint.
- It’s recommended that you use a fresh OS install to prevent any potential issues.
- SSH access to the server (or just open Terminal if you’re on a desktop).
- A
non-root sudo user
or access to theroot user
. We recommend acting as anon-root sudo user
, however, as you can harm your system if you’re not careful when acting as the root.
Install phpMyBackupPro on Ubuntu 14.04
Step 1. First, Install Apache and the latest PHP version on your server. Let’s install these required packages on the server.
apt-get update apt-get install php5 libapache2-mod-auth-mysql php5-mysql
Step 2. Download the latest stable release of phpMyBackupPro.
wget http://downloads.sourceforge.net/project/phpmybackup/phpMyBackupPro/phpmyBackupPro%202.4/phpMyBackupPro-2.4.zip
Unzip the phpMyBackupPro zip file under /opt/ directory:
unzip phpMyBackupPro-2.4.zip -d /opt/
Rename the directory to something simpler:
mv /opt/phpMyBackupPro-2.4/ /opt/phpmybackup
Setup writes permissions for the following files and folder:
chown -R root:www-data /opt/phpmybackup/
Step 3. Configure Apache webserver.
Create new a virtual host apache:
##nano /etc/apache2/conf.d/phpmybackuppro.conf <IfModule mod_alias.c> Alias /phpmybackuppro /opt/phpmybackup/phpMyBackupPro </IfModule> <Directory /opt/phpmybackup/phpMyBackupPro> Options None Order allow,deny allow from all </Directory>
We need to include the ‘phpmybackuppro.conf
’ configuration file in the webserver configuration (put the line at the end of the file):
##nano /etc/apache2/apache2.conf Include /etc/apache2/conf/phpmybackuppro.conf
Step 4. Finally, restart the Apache service.
service apache2 restart
Step 5. Access phpMyBackupPro Web UI.
Now you will be able to access phpMyBackupPro from your browser with the URL http://ip-address/phpmybackuppro
or http://domain-name/phpmybackuppro
. Enter your MySQL details, such as MySQL username and password, FTP username and password, etc., and save the changes. After you save the changes, log out from phpMyBackupPro and log in back again using your MySQL username and password.
Congratulations! You have successfully installed phpMyBackupPro. Thanks for using this tutorial for installing phpMyBackupPro on Ubuntu 14.04 systems. For additional help or useful information, we recommend you to check the official phpMyBackupPro website.