ELK>> mysql-backup>> 返回
项目作者： Sopsy

项目描述 ：
Backup script for MySQL databases
高级语言： Shell
项目地址: git://github.com/Sopsy/mysql-backup.git
创建时间： 2018-04-20T13:03:59Z
项目社区：https://github.com/Sopsy/mysql-backup
开源协议：GNU Affero General Public License v3.0
下载


mysql-backup.sh

Backup script for MySQL databases. Mainly designed for InnoDB.

Installation

  1. Create a local user for backups
  2. Create a database user for backups, give the following permissions: SELECT, LOCK TABLES, SHOW VIEW, PROCESS, TRIGGER, EVENT
  3. Run mysql_config_editor to create .mylogin.cnf so the script does not request login details
  4. chmod u+x mysql-backup.sh
  5. ./mysql-backup.sh, verify output and backups in the same folder
  6. Add to crontab or as a pre-command in your backup system (e.g. backuppc has pre-cmd)

Known issues

None (tested only with <100GB databases)