MySQLBackup 0.7 Beta

MySQL backups for admins and users

  Add it to your Download Basket!

 Add it to your Watch List!

0/5

Rate it!

What's new in MySQLBackup 0.7 Beta:

  • Fixed bad logic in the utility file path code.
  • Added a set of common path locations to the search path.
  • Removed information_schema from databases backed up.
Read full changelog
send us
an update
LICENSE TYPE:
BSD License 
USER RATING:
UNRATED
  0.0/5
DEVELOPED BY:
Chris Knight
HOMEPAGE:
www.ghostwheel.com
CATEGORY:
ROOT \ System \ Backup
MySQLBackup is a Perl script that allows you to make date-time stamped backups of individual MySQL databases. Each database backup is a gzip compressed SQL script that can be restored/imported via the MySQL command-line tool.

The tables of each database being backed up are locked, preserving data integrity. While this does temporarily prevent writes to the tables, the impact is reduced by backing up each database separately.

This script backups all tables accessible to the mysql user that it is configured to use. That means this script is useful to the sysadmin as well as to regular users who whish to maintain backups of their own MySQL databases.

This script requires that your MySQL connection information be stored in a my.cnf or .my.cnf file in the home directory of the user used to run this script. Because it makes an external call to mysqldump, it is inadvisible to hard code the username and password into this script and then call mysqldump with user and pass as command line arguments. Doing that would expose your mysql username and password to anyone logged into the server while the backup was occurring. For information on how to create a my.cnf file visit this page:
http://dev.mysql.com/doc/refman/5.0/en/option-files.html

Last updated on November 29th, 2009

requirements

#MySQL backup #database backup #MySQL #database #backup #archiving

Add your review!

SUBMIT