Home » Archive

Articles tagged with: tutorial

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.