Create Zip Backup files for each Database by using mysqldump in MySQL or MairaDB

Create Zip Backup files for each Database by using mysqldump in MySQL or MairaDB

mysqldump is used to take logical backups of database/databases in MairaDB and Mysql. Below script will create a directory with timestamp and then create zip backup file for each database in MySQL or MairaDB.

Link to script used in video

sudo mkdir /mysqlbackup

chown -R mysql:mysql /mysqlbackup

CREATE USER 'backupuser'@'localhost' identified BY 'Test123';

GRANT reload, lock tables, REPLICATION client,process, super, CREATE, INSERT, SELECT ON *.* TO 'backupuser'@'localhost';