How to take MySQL database backup - MySQL Dumper

To take MySQL database backup - MySQL Dumper

MySQL Dumper is an open-source web based tool for creating a backup of MySQL databases. With MySQL Dumper you can automate the process of backing up the databases and configure it to send you an email report about whether the backup succeeds. MySQL Dumper is based on PHP and Perl. Installation of MySQL Dumper is explained in this article.

Features

• Faster backups and restore.
• Easy installation.
• Sends backup Emails with or without dumpfile.
• Can send dumpfiles up to 3 different server.
• Also reads dumpfiles in other scripts.
• More secured.
• Displays all the parameters before starting a backup.
• Posibility to do Multipart-Backups.
• Provides access to SQL-Browser.
• Database-Overview is possible.
• Allows own rules to delete old backups.
• Appends Perl Cronscript.
• Complete log files can be viewed.

To install MysqlDumper

Go to Apache document root directory and download the MysqlDumper package.

[root@linuxhelp Desktop]# cd /var/www/html/
[root@linuxhelp html]# wget http://downloads.sourceforge.net/project/mysqldumper/MySQLDumper/MySQLDumper1.24.4.zip
--2016-05-11 15:42:06--  http://downloads.sourceforge.net/project/mysqldumper/MySQLDumper/MySQLDumper1.24.4.zip
Resolving downloads.sourceforge.net... 216.34.181.59
Connecting to downloads.sourceforge.net|216.34.181.59|:80... connected.
.
.
.
HTTP request sent, awaiting response... 200 OK
Length: 659416 (644K) [application/octet-stream]
Saving to: “ MySQLDumper1.24.4.zip” 

100%[=====================================================================================> ] 659,416      196K/s   in 3.3s    
2016-05-11 15:43:19 (196 KB/s) - “ MySQLDumper1.24.4.zip”  saved [659416/659416]

Now extract the downloaded package by using Unzip.

[root@linuxhelp html]# unzip MySQLDumper1.24.4.zip
Archive:  MySQLDumper1.24.4.zip
   creating: msd1.24.4/
  inflating: msd1.24.4/config.php    
  inflating: msd1.24.4/config_overview.php
 .
 .
 .
  inflating: msd1.24.4/tpl/sqlbrowser/sqlbox.tpl  
  inflating: msd1.24.4/tpl/sqlbrowser/sql_record_insert_inputmask.tpl  
  inflating: msd1.24.4/tpl/sqlbrowser/sql_record_update_inputmask.tpl

Now MysqlDumper is installed successfully.

To configure

List the directory and rename the extracted directory.

[root@linuxhelp html]# ls
msd1.24.4 MySQLDumper1.24.4.zip
[root@linuxhelp html]# mv msd1.24.4/ dumper
[root@linuxhelp html]# ls
dumper MySQLDumper1.24.4.zip

Now change the ownership permission for the renamed directory

[root@linuxhelp html]# chown -R apache:apache dumper/

And then start the apache service.

[root@linuxhelp html]# service httpd start

Navigate to ' http://192.168.1.10/dumper/install.php' or ' http://localhost/dumper/install.php'

Now the installation page of mysqldumper appears. Choose the language and click Installation.

Set the credentials like hostname, user and password of the mysql server. Then click Save and continue installation.

Now we have successfully entered into mysqldumper home page.

Select backup tab in left side panel. Choose the type of backup as required and then hit start new backup.

To restore the backup, Select Restore tab in left side panel and click " choose tables to be restored" button to select the particular table.

Here, click the check-box of respective table to be restored and click " Restore"

We have successfully restored the database.

Now move to home page and click " Create directory protection" . Using Directory Protection, we can protect the home screen with password. This option will use ‘ .htaccess‘ function on Apache web server.

Select the type of encryption and click " Create directory protection" .

Click Ok to confirm the protection.

The directory protection is successfully completed.

Now click File administration tab which is used to maintain all available backups and restore.

Go to Sql-browser tab if you want to run specific SQL command.

Click configuration tab. You can configure general settings, email, cron job, and more.

Click log tab to view basic logs. It shows the details such as when the backup was taken, backup restored and much more information about backup logs.