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.
1 2 | apt-getupdate apt-getinstallphp5libapache2-mod-auth-mysqlphp5-mysql |
Step 2. Download the latest stable release of phpMyBackupPro.
1 | wgethttp://downloads.sourceforge.net/project/phpmybackup/phpMyBackupPro/phpmyBackupPro%202.4/phpMyBackupPro-2.4.zip |
Unzip the phpMyBackupPro zip file under /opt/ directory:
1 | unzipphpMyBackupPro-2.4.zip-d/opt/ |
Rename the directory to something simpler:
1 | mv/opt/phpMyBackupPro-2.4//opt/phpmybackup |
Setup write permissions for the following files and folder:
1 | chown-Rroot:www-data/opt/phpmybackup/ |
Step 3. Configure Apache web server.
Create new a virtual host apache:
1 2 3 4 5 6 7 8 9 10 | ##nano /etc/apache2/conf.d/phpmybackuppro.conf <IfModulemod_alias.c> Alias/phpmybackuppro/opt/phpmybackup/phpMyBackupPro </IfModule> <Directory/opt/phpmybackup/phpMyBackupPro> OptionsNone Orderallow,deny allowfromall </Directory> |
We need to include the ‘phpmybackuppro.conf’ configuration file in the web server configuration (put the line at the end of the file):
1 2 | ##nano /etc/apache2/apache2.conf Include/etc/apache2/conf/phpmybackuppro.conf |
Step 4. Finally restart Apache service.
1 | serviceapache2restart |
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.
