Home » Archive

Articles tagged with: shell script

Linux »

[1 Jun 2021 | One Comment | ]

This shell script is to check weekly and monthly backup date. I use it to check backup status for cpanel account.  It can also be used to check daily backup. Combine with cronjob, you can create an email report. As for me, I have created cronjob to generate a report every Tuesday.
The shell script as below, and it is a …

Articles, Headline, Linux tips, Tutorial »

[4 Sep 2019 | One Comment | ]
Bash script to backing up and restore MySQL, InnoDB database

If you want to dump a few database the command ‘mysqldump’ is sufficient. How about the server that have several hundred databases inside. It is easier if we create Shell scripts to do the task. There are 2 version of scripts I normally use. One is to backup whole MySQL database, the other is to backup InnoDB database only.
The databases will be dumped in the folder that we created first and dumped as *.sql.