1. mysql濡備綍鍒╃敤Navicat瀵煎嚭鍜屽煎叆鏁版嵁搴撶殑鏂规硶
MySql鏄鎴戜滑缁忓父鐢ㄥ埌鐨勬暟鎹锛屾棤璁烘槸寮鍙戜汉鍛樼敤鏉ョ粌涔狅紝杩樻槸灏忓瀷绉佹湇娓告垙鏈嶅姟鍣锛屾垨鑰呮槸涓浜鸿蒋浠舵惌鎼浣跨敤锛岄兘鍗佸垎鏂逛究銆傚逛簬鍋氫竴浜涗釜浜鸿緟鍔╄蒋浠讹紝鎷嗘媿閫夋嫨mysql鏁版嵁搴撴槸涓鏄庢櫤鐨勯夋嫨锛屾湁涓涓濂界殑宸ュ叿鏇存槸浜嬪崐鍔熷嶏紝瀵逛簬MySql 鐨処DE 鎴戞帹鑽怤avicat for MySql锛岀幇鍦ㄦ垜灏卞悜澶у朵粙缁嶅備綍鍒╃敤Navicat for MySql 瀵煎嚭鍜屽煎叆鏁版嵁銆
瀵煎嚭鏁版嵁搴擄細
鎵撳紑Navicat 锛屽湪鎴戜滑瑕佸埌澶勭殑鏁版嵁涓婇潰鍙冲嚮榧犳爣锛岀劧鍚庡脊鍑虹殑蹇鎹疯彍鍗曚笂鐐瑰嚮鈥滆浆鍌⊿QL 鏂囦欢鈥濓紝鍦ㄥ啀娆″脊鍑虹殑瀛愯彍鍗曢」涓閫夋嫨绗涓涓鈥滄暟鎹璺熺粨鏋勨濄
鐒跺悗锛屽湪浼氬脊鍑轰竴涓閫夋嫨淇濆瓨浣嶇疆鐨勪繚瀛樻嗭紝閫夋嫨濂戒綅缃鍚庯紝鐐圭‘瀹氾紝灏監K浜
瀵煎叆鏁版嵁搴擄細
鎵撳紑Navicat for MySQL锛岀劧鍚庣偣鍑诲彸閿閫夋嫨鏂板缓鏁版嵁搴擄紝鍚嶅瓧璺熸垜浠瑕佸煎叆鐨勬暟鎹鐨勫悕瀛椾竴鏍
鐐瑰嚮纭瀹氬悗锛屾垜浠灏卞彲浠ヨ佸埌宸﹁竟鍑虹幇鍒氬垰鎴戜滑寤虹珛濂界殑鏁版嵁浜嗭紝鐒跺悗鍙冲嚮閫夋嫨鈥滆繍琛孲QL鏂囦欢鈥濅細寮瑰嚭涓涓妗嗭紝鐐瑰嚮鈥...鈥濋夋嫨鏂囦欢鎵鍦ㄧ殑璺寰勶紝
鐐瑰嚮寮濮嬶紝鏂囦欢灏变細瀵煎叆鎴愬姛锛
涓ユ牸鏉ヨ诧紝鍏跺疄Navicat for MySQL瀵煎嚭鐨勪笉鏄鏁版嵁搴擄紝鑰屾槸鏁版嵁搴撲腑鐨勬墍鏈夎〃鐨勬暟鎹浠ュ強缁撴瀯銆傛墍浠ワ紝濡傛灉浣犱笉寤虹珛涓庝箣瀵瑰簲鐨勬暟鎹搴擄紝鑰屾槸闅忎究鎵句竴涓鏁版嵁瀵煎叆锛岀粨鏋滄槸杩欎釜鏁版嵁搴撳氫簡鍑犲紶鍒氬垰瀵煎叆鐨勮〃銆
PS锛歮ysql 鏁版嵁搴撳煎叆瀵煎嚭鏂规硶鎬荤粨
涓鑸褰㈠紡锛歮ysqlmp -h IP -u 鐢ㄦ埛鍚 -p 鏁版嵁搴撳悕 > 瀵煎嚭鐨勬枃浠跺悕
锛1锛-p 鍚庨潰涓嶈兘鍔爌assword锛屽彧鑳藉崟鐙杈撳叆濡1涓閭ｆ牱 锛2锛塵ysqlmp鏄鍦╟md涓嬬殑鍛戒护锛屼笉鑳藉啀mysql涓嬮潰锛屽嵆涓嶈兘杩涘叆mysql鐨勶紙鍗硊se dpname涓嬶紝寰梕xit閫鍑簃ysql涓嬫墠鍙浠ョ殑銆傦級
涓锛氭暟鎹搴撶殑瀵煎嚭锛堝囦唤锛
0:(澶囦唤鏁版嵁搴撳嵆瀵煎嚭鎵鏈夎〃浠ュ強鏁版嵁 涓嶅姞-d)
mysqlmp -h localhost -u root -p test > G:arcgisworkspacezypdoc est.sql
mysqlmp -h 10.180.6.183 -u root -p dmsdev > D:imssdb20170930dmsdev20170930.sql
mysqlmp -h 10.180.6.183 -u root -p newfwk > D:imssdb20170930
ewfwk20170930.sql
mysqlmp -h 10.180.6.183 -u root -p dcsdev > D:imssdb20170930dcsdev20170930.sql
浜岋細鏁版嵁搴撶殑瀵煎叆(杩樺師)
0锛氬煎叆鏁版嵁搴擄紙棣栧厛寰楀垱寤烘暟鎹锛屽啀瀵煎叆锛塁:Program FilesMySQLMySQL Server 5.5in>
mysql -h localhost -u root -p锛堣繘鍏mysql涓嬮潰锛
create database abc;(鍒涘缓鏁版嵁搴)
show databases;(灏卞彲鐪嬪埌鎵鏈夊凡缁忓瓨鍦ㄧ殑鏁版嵁搴擄紝浠ュ強鏃呮灊缇″垰鍒氬垱寤虹殑鏁版嵁搴揳bc)
use abc;(杩涘叆abc鏁版嵁搴撲笅闈)
show tables;(浜х湅abc鏁版嵁搴撲笅闈㈢殑鎵鏈夎〃,绌虹殑)
source G:arcgisworkspacezypdoc est.sql锛堝煎叆鏁版嵁搴撹〃锛
show tables;(鏌ョ湅abc鏁版嵁搴撲笅闈㈢殑鎵鏈夎〃,灏卞彲浠ョ湅鍒拌〃浜)
desc pollution;(鏌ョ湅琛ㄧ粨鏋勮捐)
select * from pollution;
exit(鎴栬卌trl + c)閫鍑簃ysql