Offsite Backup Solution MySQL Backup Tool - gHacks Tech News

Offsite Backup Solution MySQL Backup Tool

MySQL Backup Tool is a free program for Microsoft Windows devices that enables you to backup MySQL tables, create SQL dump files, and more.

Backups are an important part not only when it comes to local data but also data such as websites, apps or databases made available online or in a computer network.

Websites are usually made up of files on a web server and contents stored in a database. The best option to backup those files and databases is to run a cron job that back up all files and moves them to another backup location.

Backing up data in remote locations ensures that the site or app can be recovered if files on the server are damaged or deleted, or if the server fails completely. A hard drive failure for instance would take all data with it, and if backups are stored on the same data, well, then those are gone too.

Many web hosters offer backups as part of plans, or as add-ons for a plan. While that is comfortable, depending on the company you are dealing with, you may have to pay a pretty penny for the privilege.

MySQL Backup Tool

Webmasters who want to create a quick local copy of their MySQL database have several options at hand. They can connect via ssh to the server and create a database backup, or use phpMyAdmin if the database is not that big.

Another comfortable option is the offsite backup software MySQL Backup Tool for the Windows operating system. The Open Source software can be used to create a backup of a specified local or remote MySQL database.

You need to enter the login credentials of a user authorized to access the MySQL database (MySQL username, password and database name), and set a backup location on the local system.

While you may backup full MySQL databases using the tool, you may also blacklist tables that you don't want included in the back up. This can be useful to speed up the back up process or decrease the amount of storage needed on the local system.

For instance, if you don't need a temporary table, or a table with email spam, then you could block those from being backed up with the rest.

MySQL Backup Tool provides other options: it allows you to password protect the backup, compress it to save space on the local system, or store tables in a single file or separate files.

You may save the settings that you modify so that they become available when you use the program in the future. A click on Start Backup will initiate the backup process. The software displays status information on the screen.

Update: The most recent version of the database backup program supports additional features. You may use a whitelist instead of a blacklist for instance; useful if you need to backup a small number of tables only.

There is also an option to delete old backups by selecting a number that you want to keep at any point in time.

Closing Words

MySQL Backup Tool is a handy software program for Windows users who want to backup MySQL databases occasionally. The application can be added to the Windows Task Scheduler so that backups are created regularly. The program can be downloaded from the project's website over at Sourceforge. (via Addictive Tips)

Summary
software image
Author Rating
1star1star1star1stargray
no rating based on 0 votes
Software Name
MySQL Backup Tool
Operating System
Windows
Software Category
Backup
Landing Page




  • We need your help

    Advertising revenue is falling fast across the Internet, and independently-run sites like Ghacks are hit hardest by it. The advertising model in its current form is coming to an end, and we have to find other ways to continue operating this site.

    We are committed to keeping our content free and independent, which means no paywalls, no sponsored posts, no annoying ad formats (video ads) or subscription fees.

    If you like our content, and would like to help, please consider making a contribution:

    Comments

    1. raman said on March 1, 2010 at 10:12 am
      Reply

      “It is optionally possible to block some database tables from being backed up with the backup tool”
      ..hmmmmm?

    2. Tobey said on April 10, 2010 at 11:59 pm
      Reply

      Looks very handy indeed, thanks for the mention Martin.

      @raman: Read.

    3. Killnir Show said on September 12, 2013 at 3:47 pm
      Reply

      For MySQL backup I use MySQL Dump Tool from Devart. You can read more about its features here: http://www.devart.com/dbforge/mysql/studio/mysql-backup.html

    Leave a Reply