使用ssh从服务器端回传文件到windows:
scp -i identity_file username@hostname:/path/to/file/filename.txt local/dir/
mysql按照限定条件导出数据:
mysqldump --user=username --password="password" dbname tablename --where="id > 123" > dump.sql
scp -i identity_file username@hostname:/path/to/file/filename.txt local/dir/
mysqldump --user=username --password="password" dbname tablename --where="id > 123" > dump.sql
转载于:https://www.cnblogs.com/gebilaowangpython/p/10535686.html