Backup your MySQL Server Daily with a Shell Script and a Cronjob

Backup your MySQL Server Daily with a Shell Script and a Cronjob
Detailed Instructions and Link to Backup Script mentioned in this video.

*** Clustered Networks Product Recommendations ***

*** Contact Clustered Networks ***

DISCLAIMER: This video and description contain affiliate links, which means that if you click on one of the product links, I’ll receive a small commission. This helps supports the channel and allows us to continue to make videos like this. Thank you for your support!

[afzaalawan]

Brilliant, simple and straight .. many thanks Ron

[uxnitro]

The instructions are smooth and the process works beautifully. Thanks!

[hussainabbas]

thank you, we need more tutorials about how to manage servers please.

[udayachanta]

Thanks you ji.
I can able to play with ur script according to my needs.

[satheeswaran]

Its worked great for me, Thank you so much!!!

[hakeryk]

In my case there is an error: "unknown variable 'innodb_buffer_pool_size=6G'"

EDIT: Nevermind, I had an error in config my.cnf file because few variables was in [client-server] and not below [mysqld]

[nidhisethi]

All my db(which are default) get backed up except one. Can anyone help?

Hi Sir,
its worked perfectly
what I am supposed to do if I need a single DB backup? this script takes the whole DB backup but I need a single DB backup

[zohebkhan]

Sir how can we schedule a stored procedure backups?

[sayedbasha]

where we have to put db name and hostname, did not seen

[maworks]

My credentials:
USER= "root"
PASSWORD= ""
Getting this error while executing the backup-mysql.sh file
./backup-mysql.sh: line 18: mysql: command not found