Skip to content

Bash script to Backup & Restore ALL MySQL databases from any host, one file per table, being friendly with rsnapshot tool

Notifications You must be signed in to change notification settings

juangacovas/rsnapshot-mysql

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

19 Commits
 
 
 
 

Repository files navigation

rsnapshot-mysql

This is a bash script that allows to automatically pull ALL databases from MySQL/MariaDB servers, remote or local, for backup purposes, creating "One Dump File Per Table" and a convenient restore script for each database. Plus, this script is rsnapshot-friendly, meaning you can use it with the "backup_script" feature of rsnapshot.

Features:

  • Handle dumps from local or remote MySQL hosts.
  • Allows to choose compression type for dumps (none, gzip or bzip2).
  • Automatically fetches database names from mysql host and creates a directory for each database.
  • Dump each table to its own file (.sql, .sql.gz or .sql.bz2) under a directory named as the database.
  • Handle dump of mixed database tables using MyISAM AND/OR InnoDB...
  • Ready to work with "backup_script" feature of rsnapshot, an incremental snapshot utility for local and remote filesystems.
  • Creates a convenient restore script (BASH) for each database, under each dump directory.
  • Creates backup of GRANTs (mysql permissions), and info files with the list of tables and mysql version.

About

Bash script to Backup & Restore ALL MySQL databases from any host, one file per table, being friendly with rsnapshot tool

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages