{"id":13416,"date":"2019-04-02T02:13:28","date_gmt":"2019-04-02T02:13:28","guid":{"rendered":"http:\/\/www.appservgrid.com\/paw92\/?p=13416"},"modified":"2019-04-02T02:13:28","modified_gmt":"2019-04-02T02:13:28","slug":"phpmybackuppro-a-web-based-mysql-backup-tool-for-linux","status":"publish","type":"post","link":"https:\/\/www.appservgrid.com\/paw92\/index.php\/2019\/04\/02\/phpmybackuppro-a-web-based-mysql-backup-tool-for-linux\/","title":{"rendered":"phpMyBackupPro \u2013 A Web Based MySQL Backup Tool for Linux"},"content":{"rendered":"

phpMyBackupPro<\/strong>\u00a0is an open source very easy to use web based\u00a0MySQL<\/strong>\u00a0backup application, written in\u00a0PHP<\/strong>language released under the\u00a0GNU GPL<\/strong>. It allows you to create\u00a0schedule backups<\/strong>,\u00a0restore<\/strong>\u00a0and\u00a0manage<\/strong>\u00a0them,\u00a0download<\/strong>,\u00a0email<\/strong>, or upload backups to any\u00a0FTP<\/strong>\u00a0server and lot more. It also takes\u00a0File directories<\/strong>\u00a0backup and upload them on a\u00a0FTP Server<\/strong>.<\/p>\n

It supports three compression levels of backups (No compression<\/strong>,\u00a0zip<\/strong>\u00a0or\u00a0gzip<\/strong>\u00a0compression). It also supports two alternative security login methods,\u00a0HTTP<\/strong>\u00a0or\u00a0HTML<\/strong>\u00a0authentication.<\/p>\n

Features<\/h3>\n

Following are some major key features of \u201cphpMyBackupPro<\/strong>\u201c.<\/p>\n

    \n
  1. Single or Multiple database backup support with or without\u00a0data<\/strong>,\u00a0table structure<\/strong>.<\/li>\n
  2. Three level of compression supported are\u00a0no compression<\/strong>,\u00a0gzip<\/strong>\u00a0or\u00a0zip compression<\/strong>.<\/li>\n
  3. Create scheduled backups without\u00a0cron jobs<\/strong>\u00a0using small\u00a0PHP<\/strong>\u00a0script.<\/li>\n
  4. Upload backups directly onto\u00a0FTP<\/strong>\u00a0server and posting of backups by\u00a0email<\/strong>.<\/li>\n
  5. Only\u00a0Apache<\/strong>\u00a0and\u00a0PHP<\/strong>\u00a0needed to run on\u00a0 platforms like\u00a0Linux<\/strong>,\u00a0Mac<\/strong>\u00a0or\u00a0Windows<\/strong>.<\/li>\n
  6. Shell<\/strong>\u00a0interface to take backups manually or by using cron script.<\/li>\n
  7. Whole\u00a0File directory backup<\/strong>\u00a0and move them to any\u00a0FTP<\/strong>\u00a0server.<\/li>\n
  8. Take databases backup from different\u00a0accounts<\/strong>\u00a0on several\u00a0MySQL<\/strong>\u00a0servers.<\/li>\n
  9. Two\u00a0security authentication<\/strong>\u00a0methods supported\u00a0HTTP<\/strong>\u00a0or\u00a0HTML<\/strong>\u00a0login authentication.<\/li>\n
  10. Friendly interface and very easy to install and setup.<\/li>\n
  11. Multiple\u00a0language<\/strong>\u00a0supported.<\/li>\n<\/ol>\n

    Taking\u00a0MySQL backups and restoring<\/a>\u00a0them from command line is always a good practice, but if what when you don\u2019t have physical access to server. In that, situation\u00a0phpMyBackupPro<\/strong>\u00a0tool comes in handy.<\/p>\n

    How to Install phpMyBackupPro in RHEL\/CentOS\/Fedora and Debian\/Ubuntu<\/h3>\n

    For installing\u00a0phpMyBackupPro<\/strong>\u00a0application, you must have running\u00a0Apache<\/strong>\u00a0web server and\u00a0PHP<\/strong>\u00a0installed on the server. Let\u2019s install these required packages on the server.<\/p>\n

    Install Apache and PHP<\/h5>\n

    Install on\u00a0Red Hat<\/strong>\u00a0based systems using\u00a0yum<\/strong>\u00a0command.<\/p>\n

    # yum install httpd \r\n# yum install php php-mysql\r\n# service httpd start<\/pre>\n
    Install on\u00a0Debian<\/strong>\u00a0based systems using\u00a0apt-get<\/strong>\u00a0command.<\/p>\n
    # apt-get install apache2 \r\n# apt-get install php5 libapache2-mod-auth-mysql php5-mysql\r\n# service apache2 start<\/pre>\n
    The newest\u00a0phpMyBackupPro<\/strong>\u00a0version can be downloaded from\u00a0phpMyBackupPro website<\/a>\u00a0or you may use following \u201cwget<\/strong>\u201d command to download.<\/p>\n
    # cd \/usr\/share\r\n# wget http:\/\/kaz.dl.sourceforge.net\/project\/phpmybackup\/phpMyBackupPro\/phpmyBackupPro%202.4\/phpMyBackupPro-2.4.zip<\/pre>\n
    Unzip the\u00a0phpMyBackupPro<\/strong>\u00a0zip file under\u00a0\/usr\/share\/<\/strong>\u00a0directory.<\/p>\n
    # unzip phpMyBackupPro-2.4.zip<\/pre>\n
    For security reasons, it\u2019s better to place the content of the folder under\u00a0\/usr\/share\/phpmybackup<\/strong>\u00a0directory.<\/p>\n
    # cd phpMyBackupPro-2.4\r\n# mv phpMyBackupPro\/ \/usr\/share\/phpmybackup\r\n# mv documentation\/ \/usr\/share\/phpmybackup\/<\/pre>\n
    Next go to Apache \u201cconf.d<\/strong>\u201d directory and create a file named \u201cphpmybackup.conf<\/strong>\u201d under it. For\u00a0Red Hat<\/strong>\u00a0based systems path should be (\/etc\/httpd\/conf.d\/<\/strong>) and for\u00a0Debain<\/strong>\u00a0(\/etc\/apache2\/conf.d<\/strong>).<\/p>\n
    # vi phpmybackup.conf<\/pre>\n
    Append the following lines to it. Save and close. The below rules by default enable access to all, if you want to restrict the access to specific\u00a0IP<\/strong>. Replace \u201call<\/strong>\u201d with your\u00a0IP<\/strong>\u00a0address\u201d. For example, the line should be \u201callow from 172.16.25.125<\/strong>\u201c.<\/p>\n
    Alias \/phpmybackup \/usr\/share\/phpmybackup\r\n<Directory \/usr\/share\/phpmybackup>\r\n   Options None\r\n   Order allow,deny\r\n   allow from all<\/strong>\r\n<\/Directory><\/pre>\n
    Restart\u00a0Apache<\/strong>\u00a0service.<\/p>\n
    # \/etc\/init.d\/httpd restart (On Red Hat<\/strong> systems)\r\n\r\n# \/etc\/init.d\/apache2 restart (On Debian<\/strong> systems)<\/pre>\n
    On some systems, certain files must have write permissions for the file \u201cglobal_conf.php<\/strong>\u201d and for the \u201cexport<\/strong>\u201d directory.<\/p>\n
    # cd \/usr\/share\/\r\n\r\n# chown -R root:apache phpmybackup (On Red Hat systems)\r\n\r\n# chown -R root:www-data phpmybackup (On Debian systems)\r\n\r\n# cd \/usr\/share\/phpmybackup\/\r\n# chmod 0777 global_conf.php\r\n# chmod 0777 export<\/pre>\n
    Now you are almost ready to start\u00a0phpMyBackupPro<\/strong>. Navigate to the browser and load the\u00a0config.php<\/strong>\u00a0file like this.<\/p>\n
    http:\/\/localhost\/phpmybackup\/config.php\r\nOR\r\nhttp:\/\/ip-address\/phpmybackup\/config.php<\/pre>\n
    In the configuration tab insert your\u00a0MySQL<\/strong>\u00a0details, like\u00a0hostname<\/strong>,\u00a0username<\/strong>,\u00a0password<\/strong>\u00a0and\u00a0database name<\/strong>. If you would like to setup\u00a0FTP<\/strong>\u00a0to save\u00a0backup<\/strong>s, enter\u00a0FTP login<\/strong>\u00a0details as shown below.<\/p>\n
    \n
    \"phpMyBackupPro<\/a><\/p>\n
    Configuration Panel<\/p>\n<\/div>\n
    Next, click on \u201cbackup<\/strong>\u201d tab to see list of your\u00a0MySQL<\/strong>\u00a0database and select the database name that you wish to take backup.<\/p>\n
    \n
    \"phpMyBackupPro<\/a><\/p>\n
    Backup Panel<\/p>\n<\/div>\n
    Schedule backup has two popular ways to schedule backups:<\/p>\n
      \n
    1. By including the\u00a0schedule script<\/strong>\u00a0into existing application.<\/li>\n
    2. By using a\u00a0hidden frame<\/strong>\u00a0in a HTML frameset.<\/li>\n<\/ol>\n
      To schedule a backup, you must first create a schedule script. Go to \u201cschedule backup<\/strong>\u201d tab.<\/p>\n
      \n
      \"phpMyBackupPro<\/a><\/p>\n
      Schedule Backup<\/p>\n<\/div>\n
      Select how often you want a backup to be generated. Then you have to choose the directory of that\u00a0PHP<\/strong>\u00a0script which will include the schedule script later. After that select the\u00a0name of the database<\/strong>\u00a0to backup,\u00a0enter a comment<\/strong>, select\u00a0compression<\/strong>\u00a0type and finally click on \u201cShow script\u201d<\/strong>\u00a0button. On the next page you will see the newly created schedule script.<\/p>\n
      Instead of copying generated code to new file, you can save the code by giving a filename like \u201cschedule_backup.php<\/strong>\u201d in the text box and click on \u201cSave data<\/strong>\u201d to save. For more information read \u201cSCHEDULED_BACKUPS.txt<\/strong>\u201d file under documentation directory.<\/p>\n
      \n
      \"phpMyBackupPro<\/a><\/p>\n
      Backup Script<\/p>\n<\/div>\n
      The \u201csql queries<\/strong>\u201d tab build to run simple\u00a0sql queries<\/strong>\u00a0to the databases or import databases from the local computer.<\/p>\n
      \n
      \"phpMyBackupPro<\/a><\/p>\n
      SQL Query Shell<\/p>\n<\/div>\n
      The \u201cstart<\/strong>\u201d tab display your current\u00a0Apache<\/strong>,\u00a0PHP<\/strong>\u00a0and\u00a0MySQL<\/strong>\u00a0version information.<\/p>\n
      \n
      \"phpMyBackupPro<\/a><\/p>\n
      Version Information<\/p>\n<\/div>\n
      phpMyBackupPro<\/strong>\u00a0is by far the easiest backup solution for\u00a0MySQL<\/strong>. If you are handling\u00a0MySQL<\/strong>\u00a0server, then\u00a0pMB<\/strong>P is a must needed application that can help you to save your precious data with minimum effort.<\/p>\n
      Reference Links<\/h3>\n
      phpMyBackupPro Homepage<\/a><\/p>\n
      Source<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
      phpMyBackupPro\u00a0is an open source very easy to use web based\u00a0MySQL\u00a0backup application, written in\u00a0PHPlanguage released under the\u00a0GNU GPL. It allows you to create\u00a0schedule backups,\u00a0restore\u00a0and\u00a0manage\u00a0them,\u00a0download,\u00a0email, or upload backups to any\u00a0FTP\u00a0server and lot more. It also takes\u00a0File directories\u00a0backup and upload them on a\u00a0FTP Server. It supports three compression levels of backups (No compression,\u00a0zip\u00a0or\u00a0gzip\u00a0compression). It also supports two alternative … <\/p>\n
      Continue reading “phpMyBackupPro \u2013 A Web Based MySQL Backup Tool for Linux”<\/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-13416","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\/13416","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=13416"}],"version-history":[{"count":1,"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/posts\/13416\/revisions"}],"predecessor-version":[{"id":13417,"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/posts\/13416\/revisions\/13417"}],"wp:attachment":[{"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/media?parent=13416"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/categories?post=13416"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/tags?post=13416"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}