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 few clicks. You can also schedule your backups, manage, download, restore the backups and a lot of more. PMBP also supports three compression levels of backups (No compression, zip or gzip compression). It also supports two alternative security login methods, HTTP or 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 through the step by step installation phpMyBackupPro in Ubuntu 14.04 server.
Install phpMyBackupPro on Ubuntu 14.04
Step 1. First, Install Apache and 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.
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 write 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 Apache service.
service apache2 restart
Step 5. Access phpMyBackupPro.
Now you will be able to access phpMyBackupPro from your browser with 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.
Congratulation’s! 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 web site.