All Projects → nethalo → backup-scripts

nethalo / backup-scripts

Licence: other
Short collection of backup scripts. Mostly on bash

Programming Languages

shell
77523 projects

Projects that are alternatives of or similar to backup-scripts

docker-mariadb
A docker image to run MariaDB with XtraBackup 🐳
Stars: ✭ 12 (-45.45%)
Mutual labels:  xtrabackup
triki
Mysql, PostgreSQL and SQL dump obfuscator aka anonimizer
Stars: ✭ 28 (+27.27%)
Mutual labels:  mysqldump
go-sync
🔁 CLI synchronization utility to sync project files and databases for your local project with SSH and Docker support
Stars: ✭ 61 (+177.27%)
Mutual labels:  mysqldump
wp-dbmanager
Allows you to optimize database, repair database, backup database, restore database, delete backup database , drop/empty tables and run selected queries. Supports automatic scheduling of backing up, optimizing and repairing of database.
Stars: ✭ 63 (+186.36%)
Mutual labels:  mysqldump
zzmysqldump
mysqldump every DB of your MySQL Server to its own, 7z-compressed file.
Stars: ✭ 47 (+113.64%)
Mutual labels:  mysqldump
myanon
A mysqldump anonymizer
Stars: ✭ 24 (+9.09%)
Mutual labels:  mysqldump
Backup-Scripts
PowerShell Scripts and Automation Manager Policies for N-able Backup
Stars: ✭ 26 (+18.18%)
Mutual labels:  backup-scripts
wing-binlog
php mysqlbinlog monitoring system
Stars: ✭ 37 (+68.18%)
Mutual labels:  mysqlbinlog

Backup Scripts

Collection of backup scripts (sometimes just wrapers) for MySQL. Tools to enhance the MySQL Backup experience and make it easier (almost plug and play...almost!)

All the scripts take care of the retention policy (defined by the user), as followed:

  • For MyDumper: User will define weekly and daily retention times.
  • For Mysqldump: User will define weekly and daily retention times.
  • For Mysqlbinlog: User will define number of days that the binlog files will be keep it
  • For XtraBackup: User will define weekly and daily retention times.

Binlog backup

pull-binlogs.sh Bash script for backup binlogs using the mysqlbinlog utility that comes with MySQL 5.6. To launch this script, run:

  nohup ./pull_binlog.sh > /var/log/mysql/pull_binlog.log 2>&1 /dev/null

MyDumper backup

mydumper.sh Bash script used as a wraper of the MyDumper backup tool. Run this script as a daily cronjob

Mysqldump backup

mysqldump.sh Bash script used as a wraper of the classic mysqldump backup tool. Run this script as a daily cronjob

XtraBackup script.

xtrabackup.sh Bash script used as a wrapper of the Percona XtraBackup tool. Run this script as a daily cronjob. It only takes care of full backups. Coming soon: Incremental backups

Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].