programmer group

Using Shell script to automatically backup MySQL database

Purpose: The 192.168.100.20 server backs up the MySQL database on the 192.168.100.10 server. 1. Configure MySQL server 1) 100.10 MySQL server log in to MYSQL to create two databases [root@centos01 ~]# mysql -uroot -ppwd@123 mysql> create database liyanxin; mysql> create database wangzhaojun; 2) liyanxin database creates tables and writes data mysql> create table liyanxin.liyanxin (full name char(6),Gender char(5),Age...