实现远程服务器的Mysql数据库备份和恢复

  1. 备份192.168.1.1服务器上的Customers数据库 用户名sadmin ,密码pass21
  2. mysqldump --host 192.168.1.1 -u sadmin -p pass21 Customers > custback.sql
  3. 远程恢复
  4. mysql  --host 192.168.1.1 -uroot -pass21   Customers <custback.sql
Last modification:October 1st, 2017 at 09:24 pm
If you think my article is useful to you, please feel free to appreciate

Leave a Comment