{"id":11570,"date":"2019-03-14T13:00:37","date_gmt":"2019-03-14T13:00:37","guid":{"rendered":"http:\/\/www.appservgrid.com\/paw92\/?p=11570"},"modified":"2019-03-14T13:00:37","modified_gmt":"2019-03-14T13:00:37","slug":"mysqldumper-a-php-and-perl-based-mysql-database-backup-tool","status":"publish","type":"post","link":"https:\/\/www.appservgrid.com\/paw92\/index.php\/2019\/03\/14\/mysqldumper-a-php-and-perl-based-mysql-database-backup-tool\/","title":{"rendered":"MySQLDumper: A PHP and Perl Based MySQL Database Backup Tool"},"content":{"rendered":"

MySQL<\/strong>\u00a0is one of the most popular database in the world. This database can be installed on the\u00a0Microsoft Windows<\/strong>\u00a0platform besides of\u00a0Linux<\/strong>\u00a0platform. Why this database is so popular? It may caused by its powerful feature and its free to use. As a database administrator, a database backup is really crucial to maintain the availability of the data. It will minimize the risk if something happens to our database.<\/p>\n

\n

\"Install<\/a><\/p>\n

Install MySQLDumper in Linux<\/p>\n<\/div>\n

Since\u00a0MySQL<\/strong>\u00a0is a popular database, there are many software that we can use to backup it. From the console mode to the web based software. Now we will give you a look of\u00a0MySQLDumper<\/strong>\u00a0as a tool for backup MySQL Database.<\/p>\n

What is MySQLDumper?<\/h4>\n

MySQLDumper<\/strong>\u00a0is a another open source web based tool for backing up MySQL databases. It built from PHP and Perl and can be easily dump and restore your MySQL data. It is especially suitable for shared hosting, where we don\u2019t have access to Linux shell.<\/p>\n

MySQLDumper Features<\/h4>\n

There are a lot of MySQLDumper features, but here are some features that may interest you.<\/p>\n

    \n
  1. Easy installation; just make sure that you have a working web server and point your browser to MySQLDumper installation file.<\/li>\n
  2. All parameters is shown before the backup is started; so you are sure what you are doing.<\/li>\n
  3. Database-Overview; look at running processes\/<\/li>\n
  4. SQL-Browser: Access to your MySQL-Tables, delete tables, edit or insert data.<\/li>\n
  5. Two type of backup method, using PHP or Perl.<\/li>\n
  6. Complete log files.<\/li>\n
  7. Automatic file-deletion of your old backups.<\/li>\n
  8. Create directory protection.<\/li>\n<\/ol>\n

    Installation of MySQLDumper in Linux<\/h3>\n

    Installing MySQLDumper is so easy. First we can download MySQLDumper from the following link.<\/p>\n

      \n
    1. Download MySQLDumper<\/a><\/li>\n<\/ol>\n

      At the time of writing this article, the latest version is 1.24. So, download latest version under your working web server directory (i.e.\u00a0\/var\/www<\/strong>\u00a0or\u00a0\/var\/www\/html<\/strong>). Once you have it, you can extract\u00a0MySQLDumper1.24.4.zip<\/strong>.<\/p>\n

      $ unzip MySQLDumper1.24.4.zip<\/pre>\n
      Then you will find a \u2018msd1.24.4<\/strong>\u2018 folder. This folder contain all MySQLDumper files. The next step, you just need to point your browser to MySQLDumper installation file. The file is \u2018msd1.24.4\/install.php\u2019<\/strong>. Here are the steps of super easy\u00a0MySQLDumper<\/strong>.<\/p>\n
      1. We need to choose installation\u00a0Language<\/strong>.<\/p>\n
      \n
      \"Select<\/a><\/p>\n
      Select Language<\/p>\n<\/div>\n
      2. We need to fill some credentials such as hostname, user and MySQL password.<\/p>\n
      \n
      \"Database<\/a><\/p>\n
      Database Parameters<\/p>\n<\/div>\n
      3. We can test the connection to the database by clicking\u00a0Connect to MySQL<\/strong>\u00a0button. If it succeed, then we will see a message saying that \u201cDatabase connection was established<\/strong>\u201d.<\/p>\n
      \n
      \"Test<\/a><\/p>\n
      Test Database Connection<\/p>\n<\/div>\n
      4. Once you got the message, click the \u2018Save<\/strong>\u2018 and continue installation button. You will be taken into the home screen.<\/p>\n
      \n
      \"Home<\/a><\/p>\n
      Home Screen<\/p>\n<\/div>\n
      How to use MySQLDumper<\/h3>\n
      As we can guess from its name, MySQLDumper main function is to backup your MySQL database. With this application, backup (and restore) MySQL database is very easy. Let\u2019s start to take a look.<\/p>\n
      Backup Process using PHP<\/h5>\n
      The function menu is located on the panel navigation on the left. First we need to select which database that we want to backup. We can see the option on the left menu.<\/p>\n
      \n
      \"Select<\/a><\/p>\n
      Select Database<\/p>\n<\/div>\n
      In the screenshot above, we choose to backup a database named \u2018employees<\/strong>\u2018.<\/p>\n
      Then we can select \u2018Backup<\/strong>\u2018 menu on the left. Then choose \u2018Backup PHP<\/strong>\u2018 on the top area. We will have a screen like this.<\/p>\n
      \n
      \"Select<\/a><\/p>\n
      Select Backup PHP<\/p>\n<\/div>\n
      Then click on \u2018Start New Backup<\/strong>\u2018. A progress of backup activity will show to you.<\/p>\n
      \n
      \"Database<\/a><\/p>\n
      Database Backup Progress<\/p>\n<\/div>\n
      Once backup progress is finish, we can see the notification.<\/p>\n
      \n
      \"Backup<\/a><\/p>\n
      Backup Done<\/p>\n<\/div>\n
      Backup Process using Perl<\/h5>\n
      Another backup method that is supported by MySQLDumper is \u2018Backup Perl\u2019<\/strong>. With this method, we will use Perl as the backup engine.<\/p>\n
      Please notice that your web server must support \u2018Perl<\/strong>\/CGI<\/strong>\u2018 script before running this backup method. Otherwise, you will see an error like this when you click on Test Perl button.<\/p>\n
      \n
      \"Test<\/a><\/p>\n
      Test Perl Support<\/p>\n<\/div>\n
      Same with PHP backup method, we need to select which database that we want to backup. Then choose Backup menu from the left navigation panel. Then click Backup Perl button.<\/p>\n
      \n
      \"Select<\/a><\/p>\n
      Select Backup Perl<\/p>\n<\/div>\n
      MySQLDumper will show you some active parameters on the bottom area. Then we can click \u2018Run the Perl Cron<\/strong>\u2018 script button. Using this method, we will not see any progress bar appear. The duration of this backup process will be depend on the database which we are going to backup. If no error, then we will see a notification like this.<\/p>\n
      \n
      \"Perl<\/a><\/p>\n
      Perl CronDump Details<\/p>\n<\/div>\n
      Restore Process<\/h5>\n
      Restoring a backup is also easy using MySQLDumper. You can click on \u2018Restore<\/strong>\u2018 menu from the navigation panel in the left. Unlike Backup activity, all backups are available at the bottom area of restore page.<\/p>\n
      \n
      \"Restore<\/a><\/p>\n
      Restore Database Backup<\/p>\n<\/div>\n
      When we need to select a backup, we can choose from there. At the above area is the selected backup which are ready to restore. If you want to do full restore, then click on the \u2018Restore<\/strong>\u2018 button above. While if you want to restore some tables only, click on the \u2018Choose tables<\/strong>\u2018 to be restored above.<\/p>\n
      \n
      \"Restore<\/a><\/p>\n
      Restore Database Tables<\/p>\n<\/div>\n
      Once it done, click \u2018Restore<\/strong>\u2018. Just wait for a moment to complete the restore progress.<\/p>\n
      \n
      \"Restore<\/a><\/p>\n
      Restore Progress<\/p>\n<\/div>\n
      Create a Directory Protection<\/h4>\n
      By default, the home page of MySQLDumper can be accessed by anyone who know its URL. Using Directory Protection, we can create a this home screen protected by password. This Directory Protection utilizes \u2018.htaccess<\/strong>\u2018 function on Apache web server.<\/p>\n
      To create it, just click\u00a0Create directory protection<\/strong>\u00a0button on the home screen.<\/p>\n
      \n
      \"Protect<\/a><\/p>\n
      Protect MySQLDumper<\/p>\n<\/div>\n
      Then you will ask to provide some credential.<\/p>\n
      \n
      \"Enter<\/a><\/p>\n
      Enter Login Credentials<\/p>\n<\/div>\n
      Once you finish with that, click\u00a0Create directory protection<\/strong>\u00a0button. After that, you will have a confirmation page about it.<\/p>\n
      \n
      \"Protect<\/a><\/p>\n
      Protect Confirmation<\/p>\n<\/div>\n
      If there is no error, a success message will be displayed.<\/p>\n
      \n
      \"Protection<\/a><\/p>\n
      Protection Success<\/p>\n<\/div>\n
      Next time you visit the page, MySQLDumper will ask you a password before you see its home screen.<\/p>\n
      \n
      \"Enter<\/a><\/p>\n
      Enter Password<\/p>\n<\/div>\n
      File Administration<\/h4>\n
      This menu is used to maintain all available backups and restore.<\/p>\n
      \n
      \"All<\/a><\/p>\n
      All Database Backups<\/p>\n<\/div>\n
      Here are some activity that can be done in this page.<\/p>\n
        \n
      1. Delete backup(s)<\/b>\u00a0; use the Delete buttons at the top area.<\/li>\n
      2. Download backup(s)<\/b>\u00a0; click the backup name.<\/li>\n
      3. Select backup(s)<\/b>\u00a0; click the Database name in the All Backups area.<\/li>\n
      4. Upload a big backup(s)<\/b>\u00a0to be restored.<\/li>\n
      5. Convert database<\/b>\u00a0into MySQLDumper (MSD) format.<\/li>\n<\/ol>\n
        Note<\/strong>: When we tried to convert database without using any compression, we found that MySQLDumper create a database with \u2018part_1.sql\u2019 name. The size is smaller than the original source.<\/p>\n
        SQL-Browser<\/h4>\n
        If you want to run specific SQL command, you can do it in this SQL-Browser page. But please you should know what you are doing.<\/p>\n
        \n
        \"SQL<\/a><\/p>\n
        SQL Browser<\/p>\n<\/div>\n
        Configuration<\/h4>\n
        All function above can be configured from Configuration menu. Here are some sections that we can configure.<\/p>\n
        General<\/h5>\n
        \n
        \"General<\/a><\/p>\n
        General Configuration<\/p>\n<\/div>\n
        Interface<\/h5>\n
        \n
        \"Interface<\/a><\/p>\n
        Interface Configuration<\/p>\n<\/div>\n
        Autodelete<\/h5>\n
        \n
        \"Autodelete<\/a><\/p>\n
        Autodelete Details<\/p>\n<\/div>\n
        Email<\/h5>\n
        \n
        \"Email<\/a><\/p>\n
        Email Notification<\/p>\n<\/div>\n
        FTP<\/h5>\n
        \n
        \"FTP<\/a><\/p>\n
        FTP Backup Transfer<\/p>\n<\/div>\n
        Cronscript<\/h5>\n
        \n
        \"Crondump<\/a><\/p>\n
        Crondump Settings<\/p>\n<\/div>\n
        Log Management<\/h4>\n
        MySQLDumper<\/strong>\u00a0also provide basic logs for us. So we can know when the backup-restore activity occurred. To access log page, just click \u2018Log\u2019 menu from the navigation panel on the left.<\/p>\n
        There are 3 kind of logs.\u00a0PHP-Log<\/strong>,\u00a0Perl-Log<\/strong>\u00a0and\u00a0Perl-Complete Log<\/strong>.<\/p>\n
        \n
        \"PHP<\/a><\/p>\n
        PHP Log<\/p>\n<\/div>\n
        \n
        \"Perl<\/a><\/p>\n
        Perl Log<\/p>\n<\/div>\n
        \n
        \"Perl<\/a><\/p>\n
        Perl Complete Log<\/p>\n<\/div>\n
        Conclusion<\/h3>\n
        MySQLDumper<\/strong>\u00a0may not the best backup tool for MySQL. But with the ease of use of this application, people may start using this application. Unfortunately, I found that MySQLDumper is not equipped with offline documentation. But still, it is a great alternative tool for backup MySQL database.<\/p>\n
        http:\/\/www.mysqldumper.net\/<\/a><\/p>\n
        Source<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
        MySQL\u00a0is one of the most popular database in the world. This database can be installed on the\u00a0Microsoft Windows\u00a0platform besides of\u00a0Linux\u00a0platform. Why this database is so popular? It may caused by its powerful feature and its free to use. As a database administrator, a database backup is really crucial to maintain the availability of the data. … <\/p>\n
        Continue reading “MySQLDumper: A PHP and Perl Based MySQL Database Backup Tool”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-11570","post","type-post","status-publish","format-standard","hentry","category-linux"],"_links":{"self":[{"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/posts\/11570","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/comments?post=11570"}],"version-history":[{"count":1,"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/posts\/11570\/revisions"}],"predecessor-version":[{"id":11571,"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/posts\/11570\/revisions\/11571"}],"wp:attachment":[{"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/media?parent=11570"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/categories?post=11570"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/tags?post=11570"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}