mysql backup

MySQL Backup using mysqldump

by

Create file mkdir /usr/serverok/ vi /usr/serverok/mysqldump-backup.sh Add #!/bin/bash # Author: Yujin Boby # Email: admin@serverok.in # Web: https://serverok.in/mysqldump-backup DB_BACKUP=”/home/serverok-mysql-backup/`date +%Y-%m-%d`” mkdir -p $DB_BACKUP find /home/serverok-mysql-backup/ -maxdepth 1 -type d -mtime +10 -exec rm -rf {} \; for db in $(mysql -e ‘show databases’ -s –skip-column-names); do if [ $db == “performance_schema” ] || \ [ … Read more

automysqlbackup

by

Auto backup all your MySQL databases daily, weekly and monthly. To install on Debian/Ubuntu, run apt install automysqlbackup -y To manually backup, run automysqlbackup MySQL backups will be stored in folder /var/lib/automysqlbackup/ See backup