发表于 2009-1-5 19:48
| 
MySQL鏁版嵁搴撳浠
鍙戝竷: 2008-7-01 12:48 | 浣滆: admin | 鏌ョ湅: 20娆
MySQL鏁版嵁搴撳浠
鐑
銆愬瓧浣擄細灏 澶с
MySQL鏁版嵁搴撳浠
浣滆咃細涓嶈 鏂囩珷鏉ユ簮锛氱綉缁 鐐瑰嚮鏁帮細931 鏇存柊鏃堕棿锛2007-1-21 
鍦ㄦ暟鎹簱琛ㄤ涪澶辨垨鎹熷潖鐨勬儏鍐典笅锛屽浠戒綘鐨勬暟鎹簱鏄緢閲嶈鐨勩傚鏋滃彂鐢熺郴缁熷穿婧冿紝浣犺偗瀹氭兂鑳藉灏嗕綘鐨勮〃灏藉彲鑳戒涪澶辨渶灏戠殑鏁版嵁鎭㈠鍒板穿婧冨彂鐢熸椂鐨勭姸鎬併傛湁鏃讹紝姝ｆ槸MySQL绠＄悊鍛橀犳垚鐮村潖銆傜鐞嗗憳宸茬粡鐭ラ亾琛ㄤ互鐮村潖锛岀敤璇稿vi鎴朎macs绛夌紪杈戝櫒璇曞浘鐩存帴缂栬緫瀹冧滑锛岃繖瀵硅〃缁濆涓嶆槸浠跺ソ浜嬶紒
澶囦唤鏁版嵁搴撲袱涓富瑕佹柟娉曟槸鐢∕ySQLdump绋嬪簭鎴栫洿鎺ユ嫹璐濇暟鎹簱鏂囦欢锛堝鐢╟p銆乧pio鎴杢ar绛夛級銆傛瘡绉嶆柟娉曢兘鏈夊叾浼樼己鐐癸細
MySQLdump涓嶮ySQL鏈嶅姟鍣ㄥ崗鍚屾搷浣溿傜洿鎺ユ嫹璐濇柟娉曞湪鏈嶅姟鍣ㄥ閮ㄨ繘琛岋紝骞朵笖浣犲繀椤婚噰鍙栨帾鏂戒繚璇佹病鏈夊鎴锋鍦ㄤ慨鏀逛綘灏嗘嫹璐濈殑琛ㄣ傚鏋滀綘鎯崇敤鏂囦欢绯荤粺澶囦唤鏉ュ浠芥暟鎹簱锛屼篃浼氬彂鐢熷悓鏍风殑闂锛氬鏋滄暟鎹簱琛ㄥ湪鏂囦欢绯荤粺澶囦唤杩囩▼涓淇敼锛岃繘鍏ュ浠界殑琛ㄦ枃浠朵富璇笉涓鑷寸殑鐘舵侊紝鑰屽浠ュ悗鐨勬仮澶嶈〃灏嗗け鍘绘剰涔夈傛枃浠剁郴缁熷浠戒笌鐩存帴鎷疯礉鏂囦欢鐨勫尯鍒槸瀵瑰悗鑰呬綘瀹屽叏鎺у埗浜嗗浠借繃绋嬶紝杩欐牱浣犺兘閲囧彇鎺柦纭繚鏈嶅姟鍣ㄨ琛ㄤ笉鍙楀共鎵般
MySQLdump姣旂洿鎺ユ嫹璐濊鎱簺銆
mysqldump鐢熸垚鑳藉绉绘鍒板叾瀹冩満鍣ㄧ殑鏂囨湰鏂囦欢锛岀敋鑷抽偅浜涙湁涓嶅悓纭欢缁撴瀯鐨勬満鍣ㄤ笂銆傜洿鎺ユ嫹璐濇枃浠朵笉鑳界Щ妞嶅埌鍏跺畠鏈哄櫒涓婏紝闄ら潪浣犳鍦ㄦ嫹璐濈殑琛ㄤ娇鐢∕yISAM瀛樺偍鏍煎紡銆侷SAM琛ㄥ彧鑳藉湪鐩镐技鐨勭‖浠剁粨鏋勭殑鏈哄櫒涓婃嫹璐濄傚湪MySQL 3.23涓紩鍏ョ殑MyISAM琛ㄥ瓨鍌ㄦ牸寮忚В鍐充簡璇ラ棶棰橈紝鍥犱负璇ユ牸寮忔槸鏈哄櫒鏃犲叧鐨勶紝鎵浠ョ洿鎺ユ嫹璐濇枃浠跺彲浠ョЩ妞嶅埌鍏锋湁涓嶅悓纭欢缁撴瀯鐨勬満鍣ㄤ笂銆傚彧瑕佹弧瓒充袱涓潯浠讹細鍙︿竴鍙版満鍣ㄥ繀椤讳篃杩愯MySQL 3.23鎴栦互鍚庣増鏈紝鑰屼笖鏂囦欢蹇呴』浠yISAM鏍煎紡琛ㄧず锛岃屼笉鏄疘SAM鏍煎紡銆
涓嶇浣犱娇鐢ㄥ摢绉嶅浠芥柟娉曪紝濡傛灉浣犻渶瑕佹仮澶嶆暟鎹簱锛屾湁鍑犱釜鍘熷垯搴旇閬靛畧锛屼互纭繚鏈濂界殑缁撴灉锛
瀹氭湡瀹炴柦澶囦唤銆傚缓绔嬩竴涓鍒掑苟涓ユ牸閬靛畧銆
璁╂湇鍔″櫒鎵ц鏇存柊鏃ュ織銆傚綋浣犲湪宕╂簝鍚庨渶瑕佹仮澶嶆暟鎹椂锛屾洿鏂版棩蹇楀皢甯姪浣犮傚湪浣犵敤澶囦唤鏂囦欢鎭㈠鏁版嵁鍒板浠芥椂鐨勭姸鎬佸悗锛屼綘鍙互閫氳繃杩愯鏇存柊鏃ュ織涓殑鏌ヨ鍐嶆杩愮敤澶囦唤鍚庨潰鐨勪慨鏀癸紝杩欏皢鏁版嵁搴撲腑鐨勮〃鎭㈠鍒板穿婧冨彂鐢熸椂鐨勭姸鎬併
浠ユ枃浠剁郴缁熷浠界殑鏈璁诧紝鏁版嵁搴撳浠芥枃浠朵唬琛ㄥ畬鍏ㄥ惧掞紙full dump锛夛紝鑰屾洿鏂版棩蹇椾唬琛ㄦ笎杩涘惧掞紙incremental dump锛夈
浣跨敤涓绉嶇粺涓鐨勫拰鏄撶悊瑙ｇ殑澶囦唤鏂囦欢鍛藉悕鏈哄埗銆傝薄backup1銆乥uckup2绛変笉鏄壒鍒湁鎰忎箟銆傚綋瀹炴柦浣犵殑鎭㈠鏃讹紝浣犲皢娴垂鏃堕棿鎵惧嚭鏂囦欢閲屾槸浠涔堜笢瑗裤備綘鍙兘鍙戣鐢ㄦ暟鎹簱鍚嶅拰鏃ユ湡鏋勬垚澶囦唤鏂囦欢鍚嶄細寰堟湁鐢ㄣ備緥濡傦細
%mysqldump samp_db >/usr/archives/mysql/samp_db.1999-10-02
%mysqldump menagerie >/usr/archives/mysql/menagerie.1999-10-02
浣犲彲鑳芥兂鍦ㄧ敓鎴愬浠藉悗鍘嬬缉瀹冧滑銆傚浠戒竴鑸兘寰堝ぇ锛佷綘涔熼渶瑕佽浣犵殑澶囦唤鏂囦欢鏈夎繃鏈熸湡闄愪互閬垮厤瀹冧滑濉弧浣犵殑纾佺洏锛屽氨璞′綘璁╀綘鐨勬棩蹇楁枃浠惰繃鏈熼偅鏍枫
鐢ㄦ枃浠剁郴缁熷浠藉浠戒綘鐨勫浠芥枃浠躲傚鏋滈亣涓婁簡涓涓交搴曞穿婧冿紝涓嶄粎娓呴櫎浜嗕綘鐨勬暟鎹洰褰曪紝涔熸竻闄や簡鍖呭惈浣犵殑鏁版嵁搴撳浠界殑纾佺洏椹卞姩鍣紝浣犲皢鐪熸閬囦笂浜嗛夯鐑︺備篃瑕佸浠戒綘鐨勬洿鏂版棩蹇椼
灏嗕綘鐨勫浠芥枃浠舵斁鍦ㄤ笉鍚屼簬鐢ㄤ簬浣犵殑鏁版嵁搴撶殑鏂囦欢绯荤粺涓娿傝繖灏嗛檷浣庣敱浜庣敓鎴愬浠借屽～婊″寘鍚暟鎹洰褰曠殑鏂囦欢绯荤粺鐨勫彲鑳芥с
鐢ㄤ簬鍒涘缓澶囦唤鐨勬妧鏈悓鏍峰鎷疯礉鏁版嵁搴撳埌鍙︿竴鍙版満鍣ㄦ湁鐢ㄣ傛渶甯歌鍦帮紝涓涓暟鎹簱琚浆绉诲埌浜嗚繍琛屽湪鍙︿竴鍙颁富鏈轰笂鐨勬湇鍔″櫒锛屼絾鏄綘涔熷彲浠ュ皢鏁版嵁杞Щ鍒板悓涓鍙颁富鏈轰笂鐨勫彟涓涓湇鍔″櫒銆
1 浣跨敤mysqldump澶囦唤鍜屾嫹璐濇暟鎹簱
褰撲綘浣跨敤mysqldumo绋嬪簭浜х敓鏁版嵁搴撳浠芥枃浠舵椂锛岀己鐪佸湴锛屾枃浠跺唴瀹瑰寘鍚垱寤烘鍦ㄥ惧掔殑琛ㄧ殑CREATE璇彞鍜屽寘鍚〃涓鏁版嵁鐨処NSERT璇彞銆傛崲鍙ヨ瘽璇达紝mysqldump浜х敓鐨勮緭鍑哄彲鍦ㄤ互鍚庣敤浣渕ysql鐨勮緭鍏ユ潵閲嶅缓鏁版嵁搴撱
浣犲彲浠ュ皢鏁翠釜鏁版嵁搴撳惧掕繘涓涓崟鐙殑鏂囨湰鏂囦欢涓紝濡備笅锛
%mysqldump samp_db >/usr/archives/mysql/samp_db.1999-10-02
杈撳嚭鏂囦欢鐨勫紑澶寸湅璧锋潵璞¤繖鏍凤細
# 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 NOT NULL,
date date DEFAULT 000-00-00 NOT NULL,
PRIMARY KEY (student_id,date)
);
#
# Dumping data for table absence
#
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璇彞缁勬垚銆
濡傛灉浣犳兂鍘嬬缉澶囦唤锛屼娇鐢ㄧ被浼煎涓嬬殑鍛戒护锛
%mysqldump samp_db | gzip >/usr/archives/mysql/samp_db.1999-10-02.gz
濡傛灉浣犺涓涓簽澶х殑鏁版嵁搴擄紝杈撳嚭鏂囦欢涔熷皢寰堝簽澶э紝鍙兘闅句簬绠＄悊銆傚鏋滀綘鎰挎剰锛屼綘鍙互鍦╩ysqldump鍛戒护琛岀殑鏁版嵁搴撳悕鍚庡垪鍑哄崟鐙殑琛ㄥ悕鏉ュ惧埌瀹冧滑鐨勫唴瀹癸紝杩欏皢鍊惧掓枃浠跺垎鎴愯緝灏忋佹洿鏄撲簬绠＄悊鐨勬枃浠躲備笅渚嬫樉绀哄浣曞皢samp_db鏁版嵁搴撶殑涓浜涜〃鍊惧埌杩涘垎寮鐨勬枃浠朵腑锛
%mysqldump samp_db student score event absence >grapbook.sql
%mysqldump samp_db member president >hist-league.sql
