Home » Archive

Articles tagged with: shell script

articles, Linux tips, Tutorial »

[4 Mar 2019 | One Comment | 2,165 supporters]
Bash script to backup and restore MySQL, InnoDB database for Cpanel server

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.