远程备份数据库

发布时间 2024-01-12 14:30:51作者: 博小群

/usr/bin/mysqldump -h 192.168.0.201 -u root -p'Newland123!' --default-character-set=utf8 tnhg > /Lims/mysql/bak_DB/tnhg/tnhg_db_date +%Y%m%d%H%M%S.sql
sleep 30

/usr/bin/mysqldump -h 192.168.0.201 -u root -p'Newland123!' --default-character-set=utf8 tchg > /Lims/mysql/bak_DB/tchg/tchg_db_date +%Y%m%d%H%M%S.sql
sleep 30

/usr/bin/mysqldump -h 192.168.0.201 -u root -p'Newland123!' --default-character-set=utf8 twhg > /Lims/mysql/bak_DB/twhg/twhg_db_date +%Y%m%d%H%M%S.sql
sleep 30