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 of more. It 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 on CentOS 6.
Install phpMyBackupPro on CentOS 6
Step 1. First, Install Apache and the latest PHP version on your server.
yum install httpd php php-mysql -y
Step 2. Download the latest stable release of phpMyBackupPro.
Extract the zip file using the command:
unzip phpMyBackupPro-2.4.zip -d /opt/
Rename the directory to something simpler:
mv /opt/phpMyBackupPro-2.4/ /opt/phpmybackup
Set apache as an owner of the directory where the files are extracted:
chown -R apache: /opt/phpmybackup/
Step 3. Configure Apache webserver.
Create new a virtual host apache:
##nano /etc/httpd/conf/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’ the configuration file in the web server configuration (put the line at the end of the file):
##nano /etc/httpd/conf/httpd.conf Include /etc/httpd/conf/phpmybackuppro.conf
Step 4. Finally, restart the Apache service.
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.
Congratulations! You have successfully installed phpMyBackupPro. Thanks for using this tutorial for installing phpMyBackupPro on CentOS 6 systems.