phpMyBackupPro is a great and helpful web-based application for backing up MySQL databases. Using this free PHP based application you can easily create a backup of your database, create scheduled backups, manage, download, restore the backups and a lot more on your CentOS VPS.
In this blog article we will cover the installation of this very useful application on a CentOS VPS. The installation of phpMyBackupPro is pretty fast and simple and can be done in less than 10 minutes.
A web server and PHP version 4.3 or newer are required in order to run phpMyBackupPro on your server.
Before you start with the installation, login to your server as root and make sure that your system is up-to-date.
yum -y update
Download the latest stable release (currently version 2.4) of phpMyBackupPro from the official website
Unpack the downloaded archive to the ‘opt’ directory on your server.
unzip phpMyBackupPro-2.4.zip -d /opt/
This will create a ‘phpMyBackupPro-2.4′ directory. We will rename the directory to something simpler
mv /opt/phpMyBackupPro-2.4/ /opt/phpmybackup
set the correct owner to the phpMyBackupPro’s directory
chown -R apache: /opt/phpmybackup/
The ‘/opt’ directory is not web accessible by default, so we need to create the following file
vi /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’ file in the web server configuration. It can be done by adding the following line to the apache’s configuration file
vi /etc/httpd/conf/httpd.conf Include /etc/httpd/conf/phpmybackuppro.conf
Restart the web server for the changes to take effect:
Now, navigate your favorite web browser to http://YOUR_IP/phpmybackuppro and go to the ‘Configuration’ tab. 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.
That’s all. If you closely followed the instructions, phpMyBackupPro is installed on your server and ready to use. You can start backing up your MySQL databases.