常用数据库的备份与恢复的方法

分手后的思念是犯贱 2022-06-10 12:54 116阅读 0赞

总结下各个数据库的 备份与恢复的方法  （有待补充）

\---------------------Oracle------------------------

备份：  
exp user/password@orcl file='/app/2012.dmp'  
恢复：  
imp user/password@orcl fromuser=ufidanc touser=pm file='/app/2012.dmp'  
  
\------------Ms sqlserver--------------------  
备份  
backup database dbname to disk='/app/2012.bak'  
恢复  
restore database dbname2 from disk='/app/2012.bak'  
  
导入文本文件    
EXEC master..xp\_cmdshell 'bcp "dbname..tablename" in c:\\DT.txt -c -Sservername -Usa -Ppassword'    
导出文本文件    
EXEC master..xp\_cmdshell 'bcp "dbname..tablename" out c:\\DT.txt -c -Sservername -Usa -Ppassword'    
\----------------MySql------------------  
  
备份:mysqldump -u root -ppassword dmname > '/app/2012.sql'  
还原:mysql -u root -ppassword dbname < '/app/2012.sql'  
  
导出表 : mysqldump -u root -ppassword dmname tablename >'/app/2012.sql'  
还原表 mysql -u root -ppassword dmname tablename < '/app/2012.sql'  
  
导入文本文件  
load data infile '/app/2012.dat' into table tb\_name FIELDS TERMINATED BY '|';  
  
导出文本文件  
select \* from tb\_name into outfile '/app/2012.dat' fields terminated by '|';  
  
\-------------------------DB2--------------------------  
导出表结构  
db2look -d dbname -e -o db2look.sql    
然后导出源数据库DB2数据  
db2move dbname export –u user –p password    
目标数据库  
db2 -tvf db2look.sql  
db2move dbname import    
\------------------------Sybase--------------------------  
备份数据：  
Dump database dbname to '/app/2012.dmp'  
恢复数据：  
Load database dbname2 from '/app/2012.dmp'  
online database dbname2  
  
导出表结构  
ddlgen –Usa –Ppassword –Ddbname –Sxxx:port –Ooutput\_file  
导出数据  
bcp dbname..tablename out '/app/2012.dmp' -Sservername -Uname -–Ppassword     
导入数据  
bcp dbname..tablename in '/app/2012.dmp' -Sservername -Uname -–Ppassword