Linux Remote Copy SCP command

Today to update the database from the admin server to the DZ server with the modified content and Image_count on the test.

First you need to back up the database and use the mysqldump command

Full table Backup: Mysqldump-u root-p artdb topic > Topic_back_2016_09_10.sql

Conditional backup: mysqldump-u root-p artdb topic--where= "FLAG_HQ =1 and Flag_off = 0" >Hq.sql;

Before you can make an SCP copy, you need to be able to ssh to the target computer remotely and not copy it if you cannot ssh. Specific reference: http://www.cnblogs.com/jdksummer/articles/2521550.html

Make SCP copy SCP [email protected]:/home/yangkun/soft/topic_update.sql. /db_back/

SCP User name @ Remote Address: File path destination file path

For the SCP command, refer to: http://www.cnblogs.com/peida/archive/2013/03/15/2960802.html

Linux Remote Copy SCP command