怎么用SQL语句备份和恢复数据库?
SQL语句备份和恢复SQL
Server:
备份命令：
BACKUP
DATABASE
test
TO
disk
=
'c:\test'
WITH
FORMAT,
NAME
=
'Full
Backup
of
MyNwind'
解释如下：
NAME
=
'Full
Backup
of
MyNwind'
--这个是备注，随便写。
还原命令：
USE
master
GO
RESTORE
DATABASE
test_wt
FROM
disk
=
'c:\test_wt'
GO
MySQL:
备份:
mysqldump
-u
root
-p
database_name
>
d:\db.bak
恢复:
mysql
-u
root
-p
database_name
<
d:\db.bak
注意:在WIN下,路径用path/filename.sql是不行的,那就用path\filename.sql
绛旓細鍦╯qlserver2012鐨勭淮鎶よ鍒掑悜瀵间腑锛岃寤虹珛瀹屾暣澶囦唤锛屽樊寮澶囦唤鍜浜嬪姟鏃ュ織銆1銆佽嚦灏戞湁涓涓鍒犻櫎涔嬪墠鐨勬暟鎹簱瀹屽叏澶囦唤鏁版嵁搴撶殑鎭㈠妯″紡锛圧ecovery mode锛夋槸鈥滃畬鏁达紙Full锛夐拡瀵硅繖涓や釜鍓嶆彁鏉′欢锛屽鏋滆繖涓や釜鍓嶆彁鏉′欢閮藉瓨鍦紝閫氳繃SQL璇彞鍙渶涓夋灏辫兘鎭㈠鍙傝冩枃绔狅紝鏃犻渶鍊熷姪绗笁鏂瑰伐鍏枫2銆佸浠藉綋鍓嶆暟鎹簱鐨勪簨鍔...
绛旓細1銆侀鍏堣繍琛孯ecovery for SQL Server銆2銆佺偣鍑伙細Next > Next--銆嬭繘鍏 Recovery Configuration 鐣岄潰銆3銆佹帴鐫閫変腑 Search for deleted records锛屽苟閫夋嫨瑕佹仮澶嶇殑鏁版嵁搴撶殑鏃ュ織鏂囦欢璺緞log file path銆4銆佺偣鍑籲ext-銆嬪紑濮嬫仮澶嶃5銆佺偣鍑伙細Next锛岄夋嫨琚鎭㈠鏁版嵁瀛樻斁鐨勭洰鏍囨暟鎹簱銆6銆佹渶鍚庣偣鍑籉inish锛岀劧鍚庡氨瀹屾垚...
绛旓細澶囦唤 mysqldump -u 鐢ㄦ埛鍚 -p瀵嗙爜 鏁版嵁搴撳悕 > 瀵煎嚭鐨勬枃浠跺悕 濡傦細mysqldump -u root -p123456 database_name > outfile_name.sql 杩樺師 mysql -u root -p123456 databse_name < outfile_name.sql mysqldump鏈夋洿澶氬弬鏁板彲浠ヤ娇鐢紝濡傚帇缂┿佸彧澶囦唤琛ㄧ粨鏋勭瓑锛屼娇鐢 mysqldump --help鍙煡鐪嬭缁嗗懡浠ゃ
绛旓細sql server涓鍒犻櫎鏁版嵁鐨鎭㈠鏈潵涓嶆槸浠堕毦浜嬶紝浠庝簨鍔℃棩蹇楁仮澶嶅嵆鍙備絾鏄紝杩欎釜鎭㈠闇瑕佹湁涓や釜鍓嶆彁鏉′欢锛1.鑷冲皯鏈変竴涓鍒犻櫎涔嬪墠鐨勬暟鎹簱瀹屽叏澶囦唤銆2.鏁版嵁搴撶殑鎭㈠妯″紡锛坮ecovery mode锛夋槸鈥滃畬鏁达紙full锛夆濄傞拡瀵硅繖涓や釜鍓嶆彁鏉′欢锛屼細鏈変笁绉嶆儏鍐碉細鎯呭喌涓銆佸鏋滆繖涓や釜鍓嶆彁鏉′欢閮藉瓨鍦紝閫氳繃sql璇彞鍙渶涓夋...
绛旓細SQL Server涓鍒犻櫎鏁版嵁鐨鎭㈠鏈潵涓嶆槸浠堕毦浜嬶紝浠庝簨鍔℃棩蹇楁仮澶嶅嵆鍙備絾鏄紝杩欎釜鎭㈠闇瑕佹湁涓や釜鍓嶆彁鏉′欢锛1. 鑷冲皯鏈変竴涓鍒犻櫎涔嬪墠鐨勬暟鎹簱瀹屽叏澶囦唤銆2. 鏁版嵁搴撶殑鎭㈠妯″紡锛圧ecovery mode锛夋槸鈥滃畬鏁达紙Full锛夆濄傞拡瀵硅繖涓や釜鍓嶆彁鏉′欢锛屼細鏈変笁绉嶆儏鍐碉細鎯呭喌涓銆佸鏋滆繖涓や釜鍓嶆彁鏉′欢閮藉瓨鍦紝閫氳繃SQL璇彞鍙渶涓...
绛旓細杩樺師鐨鏁版嵁搴撴枃浠跺悗缂涓澶囦唤鏂囦欢锛坆ak锛夛紱绗洓姝ワ細閫変腑娣诲姞杩涙潵鐨勮繕鍘熸枃浠讹紝鎵惧埌宸︿笂瑙掍笂鐨勨滈夋嫨椤光濓紝鍕鹃夌涓椤癸紙瑕嗙洊鐜版湁鏁版嵁搴擄級锛岀偣鍑荤‘瀹氬氨鍙互浜嗐傛敞鎰忎簨椤 1銆佷竴瀹氳璁板緱瑕嗙洊鐜版湁鏁版嵁搴擄紱2銆佹墽琛屾暟鎹簱鎿嶄綔鐨勬椂鍊欙紝璇锋柇寮褰撳墠鏁版嵁搴撶殑浠讳綍浣跨敤锛堜緥濡傛煡璇紝鏁版嵁搴撶殑杩炴帴浣跨敤锛夈
绛旓細1銆侀鍏堣繍琛SQL銆2銆佸皢鏁版嵁搴撹繘琛岃繛鎺ャ3銆佸崟鍑烩滄湇鍔″櫒瀵硅薄"锛屽湪鈥滄湇鍔″櫒瀵硅薄鈥濅腑鍙抽敭鍗曞嚮鈥澶囦唤璁惧鈥濓紝閫夋嫨鈥濇柊寤哄浠借澶団濄4銆佸湪璁惧鍚嶇О鏂囨湰妗嗚緭鍏ヤ綘瑕佸垱寤虹殑璁惧鍚嶇О锛岀劧鍚庡崟鍑烩滅‘瀹氣濄5銆佽繖鏍峰浠借澶囩殑鍒涘缓灏卞畬鎴愪簡銆6銆佸彸閿崟鍑昏澶囦唤鐨勬暟鎹簱锛岄夋嫨鈥滀换鍔♀濓紝鍦ㄢ滀换鍔♀濅腑閫夋嫨鈥滃浠解濄
绛旓細鐢⊿QL2000杩樺師bak鏂囦欢 1.鍙冲嚮SQL Server 2000瀹炰緥涓嬬殑鈥滄暟鎹簱鈥濇枃浠跺す銆傚氨鏄痬aster绛夋暟鎹簱涓婁竴绾х殑閭ｄ釜鍥炬爣銆傞夋嫨鈥滄墍鏈変换鍔♀濓紝鈥杩樺師鏁版嵁搴撯2.鍦ㄢ滆繕鍘熶负鏁版嵁搴撯濅腑濉笂浣犲笇鏈涙仮澶嶇殑鏁版嵁搴撳悕瀛椼傝繖涓悕瀛楀簲璇ヤ笌浣犵殑婧愮爜涓娇鐢ㄧ殑鏁版嵁搴撳悕瀛椾竴鑷淬3.鍦ㄥ脊鍑虹殑瀵硅瘽妗嗕腑锛岄夆滀粠璁惧鈥4.鐐瑰嚮鈥滈夋嫨...
绛旓細SQL Server涓鍒犻櫎鏁版嵁鐨鎭㈠鏈潵涓嶆槸浠堕毦浜嬶紝浠庝簨鍔℃棩蹇楁仮澶嶅嵆鍙備絾鏄紝杩欎釜鎭㈠闇瑕佹湁涓や釜鍓嶆彁鏉′欢锛1. 鑷冲皯鏈変竴涓鍒犻櫎涔嬪墠鐨勬暟鎹簱瀹屽叏澶囦唤銆2. 鏁版嵁搴撶殑鎭㈠妯″紡锛圧ecovery mode锛夋槸鈥滃畬鏁达紙Full锛夆濄傞拡瀵硅繖涓や釜鍓嶆彁鏉′欢锛屼細鏈変笁绉嶆儏鍐碉細鎯呭喌涓銆佸鏋滆繖涓や釜鍓嶆彁鏉′欢閮藉瓨鍦紝閫氳繃SQL璇彞鍙渶涓...
绛旓細杩樺師鏁版嵁鐨璇彞濡備笅锛歳estore database 鏁版嵁搴 from disk='c:\浣犵殑澶囦唤鏂囦欢鍚';鍏朵腑姹夊瓧鈥滄暟鎹簱鈥濇寚鐜版湁鐨勬暟鎹簱鍚嶇О锛屸渃:\浣犵殑澶囦唤鏂囦欢鍚嶁濅负瑕佽繕鍘熺殑鏁版嵁鏂囦欢鐨勮矾寰勫強鍚嶇О銆傚彟澶栵紝涔熷彲鐢ㄥ浘褰㈢晫闈㈢殑鏂规硶锛1銆佺櫥褰曟暟鎹簱銆2銆佸彸閿偣鍑绘暟鎹簱锛屽苟閫夋嫨杩樺師鏁版嵁搴撱3銆佸鍥句綅缃夋嫨瑕佽繕鍘熷埌鐨勬暟鎹簱...
