mysqlÖÐÎÄÂÒÂë
ÀûÓÃload data infileÃüÁîµ¼ÈëuserDesc.txtÊý¾Ý£¬Êý¾Ýµ¼ÈëºóËùÓеÄÖÐÎľÓȻȫÊÇÂÒÂ룬
mysql×Ö·û¼¯ÉèÖÃÈçÏ£º
-> ;
+--------------------------+-------------------------------------------+
| Variable_name | Value |
+--------------------------+-------------------------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8
Ïà¹ØÎÊ´ð£º
Winform+MySQL×öÏîÄ¿£¬ÔÚ×¢ÖØÐÔÄܵÄÇé¿öÏ£¬ÎÒ¸ÃÈçºÎÈ¥Íê³ÉÕâÀàÐ͵ÄÏîÄ¿ÄØ£¡
Çë¸÷λ¸øÒÔÌáʾ¡£
ÄãÕâ¸ö·¶Î§Ì«¹ãÁË£¬ÎÒ˵2µãÖØÒªµÄ°É
1.WINFORM³ÌÐòÊǵ¥¶ÀÔËÐеÄCS³ÌÐò£¬ºÍBS²»Í¬£¬BSµÄѹÁ¦Ê¼ÖÕ¶¼ÔÚSERVERÉϵ쬶ÔC ......
ÔÚdocÏÂÖ´Ðе¼ÈëÃüÁî
mysql -uadmin -padmin student < d:\a.txt
ʱÌáʾϵͳÕÒ²»µ½Îļþ£¬»·¾³±äÁ¿¶¼ÉèÖöÔÁ˰¡£¬Ö®Ç°Ò²Ã»ÓгöÏÖ¹ýÕâ¸ö´íÎó£¬Çë´ó¼Ò°ïæ½â¾öÏ£¡Ð»ÁË£¡£¡
mysql -uadmin -padmin st ......
´ÓÆô¶¯µ½ÄÜÕý³£ÔËÐÐ,´ó¸ÅÒª15µ½20·ÖÖÓ×óÓÒ
ÏÖÏóÊÇ,Æô¶¯ÒÔºómysql½ø³ÌÔÚÈÎÎñ¹ÜÀíÆ÷ÀïÒѾ¿ÉÒÔ¿´µ½ÁË,µ«ÊÇnetstat -anoûÓп´µ½Óнø³ÌÔÚ¼àÌý3306¶Ë¿Ú,ÉÏÃæÊý¾Ý¿â¶¼²»ÄÜ·ÃÎÊ
Ö±µ½15-20·ÖÖÓºó,ÄÜ¿´µ½mysqlÔÚ¼à ......
ÏÖÓÐÒ»¸ö±íÓÐ185ÍòÌõ¼Ç¼
ËÑË÷ʱ£¬×î¸ß·åÖµ¿É´ï1.2G×óÓÒ
ʹÓÃmy-xxx.ini±È½ÏºÃ£¿£¡
ÈçºÎ½«ÕâЩÅäÖñä³ÉĬÈÏÅäÖã¿£¡
°ÑÔÀ´µÄ my.ini ¸ÄÃû±¸·Ý£¬È»ºóÔÙ°ÑÕâ¸ö my-huge.ini ¸Ä³É my.ini
» ......
±¾ÈËÐÂÊÖ ÏÂÔØÁ˸ömysql ÇëÎÊÈçºÎ°²×°
mysql-5.1.32-linux-i686-glibc23.tar.gz
ÄãÊÇʲôϵͳ£¿
redhatµÄ»°¾ÍÈ¥ÏÂrpm£¬Ö±½Órpm -i xxxx.rpm¾ÍOKÁË
²»¹ý±¾ÈË»¹ÊÇÍÆ¼öʹÓð²×°µÄ°æ±¾
ÒýÓÃ
ÎÒ¿´Á ......