发表于 2009-1-5 19:48
| 
MySQL鏁版嵁搴撶殑澶囦唤涓庡阀鐢
鍙戝竷: 2008-7-01 12:48 | 浣滆: admin | 鏌ョ湅: 9娆
MySQL鏁版嵁搴撶殑澶囦唤涓庡阀鐢
銆愬瓧浣擄細灏 澶с
MySQL鏁版嵁搴撶殑澶囦唤涓庡阀鐢
浣滆咃細涓嶈 鏂囩珷鏉ユ簮锛氱綉缁 鐐瑰嚮鏁帮細422 鏇存柊鏃堕棿锛2007-1-21 
鈥滄病蹇呰杩涜MySQLdump绋嬪簭澶囦唤鈥濊娉曚笉瀹屽叏
閲囩敤鐩存帴鎷疯礉鏁版嵁搴撴枃浠剁殑鏂瑰紡锛岄熷害鍥虹劧蹇紝浣嗕綘蹇呴』淇濊瘉鎷疯礉鏃惰〃娌℃湁琚娇鐢ㄣ傚鏋滄湇鍔″櫒鍦ㄦ鍦ㄦ嫹璐濅竴涓〃鏃舵敼鍙樺畠锛屾嫹璐濆氨澶卞幓鎰忎箟銆傝屼笖锛岃鐢ㄧ洿鎺ユ嫹璐濇枃浠舵妸涓涓暟鎹簱浠庝竴鍙扮數鑴戞嫹璐濆埌鍙︿竴鍙扮數鑴戜笂鏃讹紝瑕佺‘淇濇枃浠舵槸MyIASM鏍煎紡鎴栦袱鍙扮數鑴戞湁鐩稿悓鐨勭‖浠剁粨鏋勶紝鍚﹀垯浣犵殑鏁版嵁搴撳湪鍙︿竴鍙颁富鏈轰笂鏈夊鎬殑鍐呭銆備綘涔熷簲璇ヤ繚璇佸湪鍙︿竴鍙扮數鑴戜笂鐨勬湇鍔″櫒鍦ㄤ綘姝ｅ湪瀹夎鏁版嵁搴撹〃鏃朵笉璁块棶瀹冧滑銆
鑰屾垜浠氳繃MySQLdump绋嬪簭澶囦唤鐨勬枃浠跺凡涓嶅悓浜庡師鏂囦欢鐨勬牸寮忎簡锛屼笅闈㈡槸鐢盡ySQLdump澶囦唤鎴愭枃鏈枃浠剁殑涓閮ㄥ垎锛
# MySQL Dump 6.0
#
# Host: localhost Database: samp_db
#---------------------------------------
# Server version 3.23.2-alpha-log
#
# Table structure for table 'absence'
#
CREATE TABLE absence (
student_id int(10) unsigned DEFAULT 鈥0鈥 NOT NULL锛
date date DEFAULT '0000-00-00' NOT NULL锛
PRIMARY KEY (student_id锛宒ate)
);
#
# Dumping data for table 鈥榓bsence鈥
#
INSERT INTO absence VALUES (3锛屸1999-09-03鈥);
INSERT INTO absence VALUES (5锛屸1999-09-03鈥);
INSERT INTO absence VALUES (10锛屸1999-09-08鈥);
......銆
鏂囦欢鍓╀笅鐨勯儴鍒嗘湁鏇村鐨処NSERT鍜孋REATE TABLE璇彞缁勬垚銆
褰撲綘浣跨敤MySQLdumo绋嬪簭浜х敓鏁版嵁搴撳浠芥枃浠舵椂锛屾垜浠疄闄呬笂鍦ㄦ枃浠朵腑杈撳叆浜嗗垱寤烘鍦ㄥ惧掔殑琛ㄧ殑CREATE璇彞鍜屽寘鍚〃涓鏁版嵁鐨処NSERT璇彞銆傛崲鍙ヨ瘽璇达紝mysqldump浜х敓鐨勮緭鍑哄彲鍦ㄤ互鍚庣敤浣淢ySQL鐨勮緭鍏ユ潵閲嶅缓鏁版嵁搴撱
鎯冲浠組ySQL鏁版嵁搴撶洿鎺ユ嫹璐濇暟鎹簱鏂囦欢
鍋囪鏈嶅姟鍣ㄥ叧闂垨宸茬粡閿佸畾浜嗕綘鎯虫嫹璐濈殑琛紝涓嬪垪鏄剧ず濡備綍灏嗘暣涓猻amp_db鏁版嵁搴撳浠藉埌涓涓浠界洰褰曪紙DATADIR琛ㄧず鏈嶅姟鍣ㄧ殑鏁版嵁鐩綍锛夛細
%cd DATADIR
%cp -r samp_db /usr/archive/mysql
鍗曚釜琛ㄥ彲浠ュ涓嬪浠斤細
%cd DATADIR/samp_db
%cp member.* /usr/archive/mysql/samp_db
%cp score.* /usr/archive/mysql/samp_db
.......
浣嗘槸锛屽煎緱寮鸿皟鐨勬槸锛
鈷堝綋浣跨敤涓绉嶇洿鎺ュ浠芥柟娉曟椂锛屼綘蹇呴』淇濊瘉琛ㄤ笉鍦ㄨ浣跨敤銆傚鏋滄湇鍔″櫒鍦ㄤ綘姝ｅ湪鎷疯礉涓涓〃鏃舵敼鍙樺畠锛屾嫹璐濆氨澶卞幓鎰忎箟銆備繚璇佷綘鐨勬嫹璐濆畬鏁存х殑鏈濂芥柟娉曟槸鍏抽棴鏈嶅姟鍣紝鎷疯礉鏂囦欢锛岀劧鍚庨噸鍚湇鍔″櫒銆
鈷夎鐢ㄧ洿鎺ユ嫹璐濇枃浠舵妸涓涓暟鎹簱浠庝竴鍙扮數鑴戞嫹璐濆埌鍙︿竴鍙扮數鑴戜笂锛屽彧鏄皢鏂囦欢鎷疯礉鍒板彟涓鍙版湇鍔″櫒涓绘満鐨勯傚綋鏁版嵁鐩綍涓嬪嵆鍙傝纭繚鏂囦欢鏄疢yIASM鏍煎紡鎴栦袱鍙扮數鑴戞湁鐩稿悓鐨勭‖浠剁粨鏋勶紝鍚﹀垯浣犵殑鏁版嵁搴撳湪鍙︿竴鍙颁富鏈轰笂鏈夊鎬殑鍐呭銆備綘涔熷簲璇ヤ繚璇佸湪鍙︿竴鍙扮數鑴戜笂鐨勬湇鍔″櫒鍦ㄤ綘姝ｅ湪瀹夎鏁版嵁搴撹〃鏃朵笉璁块棶瀹冧滑銆
瀹炵幇MySQL鏁版嵁搴撳浠界殑鏂规硶
浣跨敤mysqldump绋嬪簭澶囦唤鍜屾嫹璐濇暟鎹簱鏄氬父鐨勪綔娉曘備綘鍙互灏嗘暣涓暟鎹簱杈撳叆杩涗竴涓崟鐙殑鏂囨湰鏂囦欢涓紝瀹炵幇濡備笅锛
%mysqldump samp_db >/usr/archives/mysql/samp_db.2002-07-24
涓轰簡鑺傜害绌洪棿锛屼綘鍙互杩涜鍘嬬缉澶囦唤锛屼娇鐢ㄥ涓嬬殑鍛戒护锛
%mysqldump samp_db | gzip >/usr/archives/mysql/samp_db.2002-07-24.gz 銆
[璐ｄ换缂栬緫:鐢佃剳鎶宸
