How to monitor Web Based Mysql backup - Phpmybackuppro

To monitor Web Based Mysql backup - Phpmybackuppro

PhpMyBackupPro is very easy to use, free and web-based MySQL backup application, licensed under the GNU GPL. It is used to create scheduled backups, manage and restore them, download or email them and lot more.
We can take backup of MySQL databases from the command line itself, incase if you don’ t have direct access to the server, then this tool help you to backup/restore MySQL databases via web browser.

Features

• Backup of one or several databases with or without data, table structure.
• Scheduled backups without SSH or cron by a small PHP script which must be included in your website
• Backup directly onto FTP server and sending of backups by email
• One installation can be used for all MySQL users of one MySQL server to be used by webhosters
• Highest security through two alternative login methods HTTP or HTML authentication
• Easy to install and to use.

First install the HTTP and PHP package.

[root@linuxhelp Desktop]# yum install httpd php php-mysql
Loaded plugins: aliases, changelog, fastestmirror, kabi, presto, refresh-packagekit, security, tmprepo, verify,
              : versionlock
Loading support for CentOS kernel ABI
Setting up Install Process
Loading mirror speeds from cached hostfile
* base: centos.excellmedia.net
* extras: centos.excellmedia.net
* updates: centos.excellmedia.net
.
.
.
.
Installed:
  httpd.x86_64 0:2.2.15-47.el6.centos.4     php.x86_64 0:5.3.3-46.el6_7.1     php-mysql.x86_64 0:5.3.3-46.el6_7.1    

Complete!

Start the Apache service

Once the package is installed, the apache service is to be started.

[root@linuxhelp Desktop]# service httpd start
Starting httpd:                                            [  OK  ]

To download the phpmybackuppro package

Now download the phpmybackuppro package using wget command.

[root@linuxhelp ~]# cd /usr/share
[root@linuxhelp share]# wget http://sourceforge.net/projects/phpmybackup/files/phpMyBackupPro/phpmyBackupPro%202.4/phpMyBackupPro-2.4.zip
--2016-05-10 18:16:40--  http://sourceforge.net/projects/phpmybackup/files/phpMyBackupPro/phpmyBackupPro%202.4/phpMyBackupPro-2.4.zip
Resolving sourceforge.net... 216.34.181.60
.
.
.
HTTP request sent, awaiting response... 200 OK
Length: 145336 (142K) [application/octet-stream]
Saving to: “ phpMyBackupPro-2.4.zip” 

100%[============================================================================> ] 145,336     49.0K/s   in 2.9s    

2016-05-10 18:16:48 (49.0 KB/s) - “ phpMyBackupPro-2.4.zip”  saved [145336/145336]

To Extract the downloaded package

Extract the downloaded zip package using unzip command.

[root@linuxhelp share]# unzip phpMyBackupPro-2.4.zip
Archive:  phpMyBackupPro-2.4.zip
   creating: phpMyBackupPro-2.4/
   creating: phpMyBackupPro-2.4/documentation/
  inflating: phpMyBackupPro-2.4/documentation/GNU GPL.txt  
  inflating: phpMyBackupPro-2.4/documentation/HISTORY.txt
.
.
.
.
   creating: phpMyBackupPro-2.4/phpMyBackupPro/stylesheets/
  inflating: phpMyBackupPro-2.4/phpMyBackupPro/stylesheets/standard.css  
  inflating: phpMyBackupPro-2.4/phpMyBackupPro/sys_vars.inc.php  
  inflating: phpMyBackupPro-2.4/README.txt

To enter into extracted directory

Now enter into extracted directory

[root@linuxhelp phpMyBackupPro-2.4]# ls
documentation  phpMyBackupPro  README.txt

Move the phpMyBackuppro and documentation directories into /usr/share/backuppro location for security purpose.

[root@linuxhelp phpMyBackupPro-2.4]# mv phpMyBackupPro /usr/share/backuppro
[root@linuxhelp phpMyBackupPro-2.4]# mv documentation /usr/share/backupro

[root@linuxhelp backuppro]# vim /etc/httpd/conf.d/backup.conf

[root@linuxhelp backuppro]# service httpd restart
Stopping httpd:                                            [  OK  ]
Starting httpd:                                            [  OK  ]

Again go to /usr/share location and change the ownership for backuppro directory

[root@linuxhelp share]# chown -R root:apache backuppro

Now go to backuppro directory and change the following permission for the global_conf.php file and export directory.

[root@linuxhelp backuppro]# chmod g+w /usr/share/backuppro/global_conf.php
[root@linuxhelp backuppro]# chmod g+w /usr/share/backuppro/export

To use phpmybackuppro package from browser

Now you will be able to access phpMyBackupPro from your browser with following URL

http://< ip-address> /backuppro/config.php

or

http://< domain-name> /backuppro/config.php

Now the phpMyBackupPro was successfully open in the browser. Go to configuration page and give username, password and other details and logout the page now.

Now login phpMyBackupPro with your assigned password and username.

Go to start up page it shows about phpMyBackupPro details.

Click on the Backup tab. Select the database you want to take backup and Click Backup. The selected database backup is completed and sent to the mail that you have configured earlier.

Click on the Schedule backup tab. Select the backup period, the directory where the php file will be placed and then select the database to backup followed by the compression method etc. Click on Show script button.

If you want to know the database information click database info.

To view inserted SQL query, click SQL Query menu.