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

  1.  Home
  2. Text  
    3. Share to：
  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