mysqlblasy is a Perl script for automating MySQL database backups. It uses "mysqldump" for dumping mysql databases to the files sytem. It was written with automated usage in mind. For example, it is silent during operation, and only produces noise on errors/problems. It rotates backups automatically to prevent the backup disk from getting full when the administrator is on vacation (or is lazy).
mylvmbackup is a Perl script for quickly creating backups of a MySQL server's data files. To perform a backup, mylvmbackup obtains a read lock on all tables and flushes all server caches to disk, makes an LVM snapshot of the volume containing the MySQL data directory, and unlocks the tables again. The snapshot process takes only a small amount of time. When it is done, the server can continue normal operations while the actual file backup proceeds. The actual backup can be performed by using tar, rsync, or rsnap.
Zmanda Recovery Manager (ZRM) for MySQL simplifies life of a database administrator who needs an easy to use yet flexible and robust backup and recovery solution for MySQL server. With ZRM for MySQL, you can schedule full and incremental logical or raw backups of your local or remote MySQL database, perform a backup that is the best match for your storage engine and your MySQL configuration, get encrypted and compressed backups, get email notification about the status of your backups (including RSS feeds), monitor and get backup reports, and recover a database easily to any point in time or to any particular transaction.
Telemeta is a global audio archiving program which introduces useful and secure indexing methods to back up digitized audio files and metadata dictionaries. It is dedicated to backing up any digitized and documented sound from collections of vinyls, magnetic tapes, or audio CDs over a strong database in accordance with many standards. Export functions also encapsulate edited metadata into a compressed file. The object style architecture provides easy developed user-friendly interfaces and a plugin style audio processing.
The dsnapshot script provides a high-level interface to the Linux Logical Volume Manager. It uses its block-level snapshot support to create directory snapshots. In contrast to block-level snapshots, directory snapshots resemble the file system layer. Thus, you can snapshot any directory that is on a logical volume without worrying about the actual logical volumes, mount points, and paths.
MySQL Backup is a Perl script that uses mysqlshow to grab the database names and "show tables" to grab the table names for a user's account, and then uses mysqldump to save the data in a subdirectory named in the script. It then tars and gzips the files, using the date and time for the file name. It can be run from cron on a daily basis. It removes old files and has an option to email the gzip file to an admin, and/or FTP the file to a remote server. It also has options to use "select data into outfile" or a regular "select" for users who can't use mysqldump. It supports LARGE sets of databases and tables.
JdbcTool is a collection of command line utilities for making your life easier when working with Java JDBC databases. Included is jdbctool, an interactive command line tool for executing SQL statements, jdbcdump, which dumps the contents of a database as SQL statements into a file, like mysqldump, and jdbcload, which executes SQL statements from a file (the opposite of jdbcdump).