总结下各个数据库的 备份与恢复的方法 (有待补充)
---------------------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