]]>
]]>
娉ㄩ噴:灝嗘暟鎹簱school澶囦喚鍒皊chool.bbb鏂囦歡錛宻chool.bbb鏄竴涓枃鏈枃浠訛紝鏂囦歡鍚嶄換鍙栵紝鎵撳紑鐪嬬湅浣犱細(xì)鏈夋柊鍙戠幇銆?
1.瀵煎嚭鏁翠釜鏁版嵁搴?
mysqldump -u 鐢ㄦ埛鍚?-p 鏁版嵁搴撳悕 > 瀵煎嚭鐨勬枃浠跺悕
mysqldump -u root -p aikersql> aiker.sql
2.瀵煎嚭涓涓〃
mysqldump -u 鐢ㄦ埛鍚?-p 鏁版嵁搴撳悕 琛ㄥ悕> 瀵煎嚭鐨勬枃浠跺悕
mysqldump -u aiker -p aikersql users> aiker_users.sql
3.瀵煎嚭涓涓暟鎹簱緇撴瀯
mysqldump -u root -p -d --add-drop-table aikersql>d:\aiker_db.sql
-d 娌℃湁鏁版嵁 --add-drop-table 鍦ㄦ瘡涓猚reate璇彞涔嬪墠澧炲姞涓涓猟rop table
浜?瀵煎叆鏁版嵁搴?
甯哥敤source 鍛戒護(hù)
榪涘叆mysql鏁版嵁搴撴帶鍒跺彴錛屽mysql -u root -p
mysql>use 鏁版嵁搴?
鐒跺悗浣跨敤source鍛戒護(hù)錛屽悗闈㈠弬鏁頒負(fù)鑴氭湰鏂囦歡錛堝榪欓噷鐢ㄥ埌鐨?sql錛?
mysql>source d:\aiker_db.sql
涔熷彲浠ョ敤 mysql -uroot -Ddb1 <d:\aiker_db.sql
涓夈佸皢鏂囨湰鏁版嵁杞埌鏁版嵁搴撲腑
1銆佹枃鏈暟鎹簲絎﹀悎鐨勬牸寮忥細(xì)瀛楁鏁版嵁涔嬮棿鐢╰ab閿殧寮錛宯ull鍊肩敤n鏉ヤ唬鏇?
渚嬶細(xì)
3 rose 娣卞湷浜屼腑 1976-10-10
4 mike 娣卞湷涓涓?1975-12-23
2銆佹暟鎹紶鍏ュ懡浠?load data local infile "鏂囦歡鍚?quot; into table 琛ㄥ悕;
娉ㄦ剰錛氫綘鏈濂藉皢鏂囦歡澶嶅埗鍒癿ysqlbin鐩綍涓嬶紝騫朵笖瑕佸厛鐢╱se鍛戒護(hù)鎵撹〃鎵鍦ㄧ殑搴撱?
鏁版嵁瀵煎嚭
銆銆鏁版嵁瀵煎嚭涓昏鏈変互涓嬪嚑縐嶆柟娉曪細(xì)
銆銆浣跨敤select into outfile "filename"璇彞
銆銆浣跨敤mysqldump瀹炵敤紼嬪簭
浣跨敤phpmyadmin瀵煎叆
渚嬪錛歮ysql> select * from driver into outfile "a.txt";
瀵煎叆
銆銆鍚屽鍑虹浉綾諱技錛屽鍏ヤ篃鏈変袱縐嶆柟娉曪細(xì)
浣跨敤LOAD DATA INFILE "filename"鍛戒護(hù)
浣跨敤mysqlimport瀹炵敤紼嬪簭
浣跨敤phpmyadmin瀵煎叆
浣跨敤sql鏂囦歡
澶╁ぉ榪涙涓鐐圭偣 2007-10-08 11:32 鍙戣〃璇勮
]]>