linux采用scp命令拷贝文件到本地,拷贝本地文件到远程服务器
// 假设远程服务器IP地址为 192.168.1.100
1.从服务器复制文件到本地:
scp root@192.168.1.100:/data/test.txt /home/myfile/
root@192.168.1.100 root是目标服务器(有你需要拷贝文件的服务器)的用户名,192.168.1.100是IP地址,后面紧跟的 “:” 不要忘记,/data/test.txt 是目标服务器中你要拷贝文件的地址,接一个空格,后面的 /home/myfile/ 是本地接收文件的地址。
2.从服务器复制文件夹到本地:
scp -r root@192.168.1.100:/data/ /home/myfile/
只需在前面加 -r 即可,就可以拷贝整个文件夹。
3.从本地复制文件到服务器:
scp /home/myfile/test.txt root@192.168.1.100:/data/
4.从本地复制文件夹到服务器:
scp -r /home/myfile/ root@192.168.1.100:/data/
ALTER USER SYS IDENTIFIED BY "123456";
mysqldump -h123.56.245.49 -P36987 -uroot -pqxjqx80moc2b2jjnaqqb6vwz5f7fx7y4 --all-databases > bak.sql;
mysqldump -uroot -pqxjqx80moc2b2jjnaqqb6vwz5f7fx7y4 --all-databases > bak.sql;
mysql -uroot- p'123456' -P3306 test </home/test/0101_0630_up_subjects.sql
create temporary tablespace TEMP tempfile '/home/app/oracle/oradata/orcl/TEMP.bdf' size 100m reuse autoextend on next 20m maxsize unlimited;
create tablespace NOTIFYDB datafile '\home\app\oracle\oradata\orcl\notifydb.dbf' size 100M reuse autoextend on next 40M maxsize unlimited default storage(initial 128k next 128k minextents 2 maxextents unlimited);
create user hc_notify identified by hc_password default tablespace TEMP02 temporary tablespace TEMP02_TEMP;
CREATE TABLESPACE TJ_MVDTCITY datafile '/home/app/oracle/oradata/orcl/TJ_MVDTCITY.dbf' size 600M autoextend on next 50m maxsize unlimited;
create user TJ_MVDTCITY1 identified by 123456 default tablespace users01.dbf temporary tablespace temp01.dbf;
create user customerchat identified by customerchat default tablespace customerchat temporary tablespace customerchat_temp;
CREATE USER TJ_MVDTCITY1 IDENTIFIED BY "123456" DEFAULT TABLESPACE TJ_MVDTCITY;
grant connect,resource,dba to ET;
CREATE USER ET IDENTIFIED BY "123456" DEFAULT TABLESPACE TJ_MVDTCITY TEMPORARY TABLESPACE TEMP;