1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

[GET] Easy MySQL Backup & Restore

Discussion in 'PHP & Perl' started by phinuss, Aug 23, 2013.

  1. phinuss

    phinuss Newbie

    Joined:
    Mar 1, 2011
    Messages:
    23
    Likes Received:
    32
    Easy MySQL Backup & Restore

    Easy MySQL Backup & Restore is a script which allows you to easily backup, store and restore MySQL Database backups from any number of databases you have access to on your server. A CRON compatible version is also included allowing you to automate your MySQL backups quickly and easily!

    It is ideal for web designers who want to be able to backup all of their clients sites with one click, or for personal use if you have one or more databases you want to be able to backup quickly and easily. It has the following features:

    Quick Backup Quick Backup allows you to backup databases definied in the settings file with a single click. These files are stored on the server with a timestamp for download later if required. You can also choose to email the backup file to the email address specified in the settings file.

    Manual Backup Manual backup allows you to manually backup a database using the hostname, username, password etc. The added feature of the manual backup is that you can choose to backup specific tables only or the entire database. You can also choose to email the backup file to the email address specified in the settings file.

    Compression Backups via the GUI and via CRON can be compressed using ZIP compression.

    List Backups All backups are listed in an easy to navigate structure with their timestamp. Backup files can easily be downloaded to disk or deleted from the server with the click of a button.

    Upload Backups Upload your own SQL backup files to the server which you can then use to restore a database.

    Restore Backups Easily restore any one of your backups by simply clicking the restore icon and filling in the relevant database connection details. You can also choose to view a full restore report, giving you line-by-line details on screen of the restoration operation.

    Purge Backups Easily purge the backup files stored on the server for a specifed database. Simply specify a time in hours and any files on the server older than that time will be deleted.

    CRON Compatible Automatically backup a single database or all databases using a scheduled CRON job using the CRON compatible version inlcluded in the download. It will even email you the job log!

    Automatic Backup Purge When using CRON jobs you can choose to automatically purge backup files stored on the server. Simply specify a time in hours and the CRON job will delete any files older than that time.

    Completely Flat File Driven Other than the databases you are backing up, no MySQL database is required to install this script.

    Both the PHP and CSS code is extensively commented and should (i hope!) be easy enough to follow.

    It uses CSS for styling so again should be easy to modify if you would like it to match your website?s design, I?ve tried to make it as simple looking as possible so it should match a wide range of site designs without requiring too much modification.


    sALES Page
    Code:
    hxxp://codecanyon.n3t/item/easy-mysql-backup-restore/58387
    DOWNLOAD
    Code:
    hxxp://mir.cr/EA9YZHM4
    Virus Scan
     
  2. Gogol

    Gogol Elite Member

    Joined:
    Sep 10, 2010
    Messages:
    3,011
    Likes Received:
    2,858
    Or alternatively, use
    Code:
    http://www.mysqldumper.net/
    Which is free, open source and supports huge db dumps (even in gbs). It also has cron jobs module if you want to automate it.
     
    • Thanks Thanks x 1
  3. LukeX

    LukeX Newbie

    Joined:
    Aug 28, 2013
    Messages:
    19
    Likes Received:
    2
    Location:
    West Coast
    having used massive MySQL databases before, I would definitely recommend using MySqlDUMP, it's far more versatile.
     
    • Thanks Thanks x 1
  4. methylenebl

    methylenebl Newbie

    Joined:
    Aug 6, 2013
    Messages:
    22
    Likes Received:
    5
    WoW After looking over MySQL DUMP I will be using this on my future projects for sure thanks for the share.
     
  5. Gogol

    Gogol Elite Member

    Joined:
    Sep 10, 2010
    Messages:
    3,011
    Likes Received:
    2,858
    I also got addicted to it after the first use haha..