linux mysql8备份还原

1.备份

[mysql@localhost bak]$ pwd
/home/mysql/bak
[mysql@localhost bak]$ ll
总用量 4
drwxrwxr-x. 2 mysql mysql  37 9月  28 21:07 data
-rwxrw-r--. 1 mysql mysql 350 9月  28 21:07 mysql_bak.sh
[mysql@localhost bak]$ cat mysql_bak.sh
#!/bin/bash
. $HOME/.bash_profile
echo =================`date +%Y-%m-%d~%H:%M:%S`===start
cd $HOME/bak
$HOME/mysql-8.0.26/bin/mysqldump -uroot -p123456 jeecg_boot --single-transaction> data/jeecg_boot-`date +%Y%m%d`.sql

#delete bak files 30 days ago
find $HOME/bak/data -mtime +30 |xargs rm -rf
echo =================`date +%Y-%m-%d~%H:%M:%S`===end
[mysql@localhost bak]$ crontab -l
15 0 * * * $HOME/bak/mysql_bak.sh >$HOME/bak/mysql_bak.log 2>&1
[mysql@localhost bak]$ 

2.还原

先建好库；

然后还原：

mysql -uroot -p123456 db_name < db_name.sql