MySQL Backup and restore Database

To back up the database:
/usr/local/kkmail/service/mysql/bin/mysqldump-u kkmail-p--databases Kkmail |gzip>20180309.sql.gz

Restore the database:
Stop the database-related services, unzip the backed up SQL database files, restore the database, and finally turn on these services:
For i in Kkmail_app kkmail_nginx kkmail_apache kkmail_dovecot kkmail_redis kkmail_postfix;do/etc/init.d/$i Stop;done
Gunzip 20180309.sql.gz
/usr/local/kkmail/service/mysql/bin/mysql-ukkmail-p Kkmail <20180309.sql
For i in Kkmail_app kkmail_nginx kkmail_apache kkmail_dovecot kkmail_redis kkmail_postfix;do/etc/init.d/$i Start;done
Think: Whether to lock the table when backing up.

MySQL Backup and restore Database