Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Mysql×Ö·û¼¯ÎÊÌâС½á

MysqlµÄ×Ö·û¼¯ÊDZȽÏÂé·³µÄ,ĬÈϵĶÔÎÒÃÇÀ´Ëµ¸ù±¾¾ÍûʲôÓÃ,ÎÒÃÇÊÇÒªÓõ½ÖÐÎĵÄ,ËùÒÔÒ»¶¨µÃ¸Ä×Ö·û¼¯,Èç¹û×Ö·û¼¯²»¶Ô»áÓкܶàµÄÎÊÌâ,ÓÐÂÒÂ뻹ÓоÍÊÇÎÒÃÇÔÚ³ÌÐòÀï²åÈëÖÐÎÄʱ»á¸øÄã˵mysql Data truncation: Data too long for column,ÄãǧÍò±ðÒÔΪÊÇÄãµÄ×Ö¶ÎÉèµÃ²»¹»³¤,ÄãÉèµÃÔÙ³¤Ëû¶¼»á±¨´í,ËùÒÔ¸Ä×Ö·û¼¯°É
ÎÒÃÇÒ»°ã×°ºÃÊý¾Ý¿âÁË,ÒªÔõô¸ÄÄØ,ÕâÀïÒª¸ÄÁ½¸öÎļþ:
1:ÐÞ¸Ämysql °²×°ÎļþϵÄmy.ini Îļþ;ÕâÀïÃæÓÐÁ½´¦;²éÕÒÒ»ÏÂcharacterÕÒ³öÀ´¸Ä³Égbk»òÊÇutf8;
2:dataĿ¼ÏÂÕÒµ½ÏàÓ¦Êý¾Ý¿âÎļþ,ÕÒµ½db.opt Îļþ,´ò¿ª¿´Ò»ÏÂÓÐÁ½ÐÐ,Á½Ðж¼¸ÄÁË.
×îºóÎÒÃÇ¿´Ò»Ï±íµÄ×Ö·û¼¯;Èç¹ûÄãµÄ±íÊÇÔçÒѾ­½¨ºÃµÄ,ÄÇËûµÄ×Ö·û¼¯¿Ï¶¨Ò²ÊÇĬÈϵÄ,¿ÉÒÔÓÃÏÂÃæµÄÓï¾ä¿´Ò»¿´
ÓÃshow full fields from + ±íÃû¾Í¿ÉÒÔ¿´³öÄãµÄÁеıàÂë¸ñʽ;
Èç¹û²»ÊÇgbk,»òÕßutf8,Ôò°ÑËûÒ²¸ÄÁË,Ôõô¸Ä?¿´ÄãÓÃʲô¹¤¾ßÁË,ÓеŤ¾ßÊÇ¿ÉÒԸĵÄ,ͼÐι¤¾ßµÄ,Èç¹û²»ÖªµÀÄǾͰѱíɾÁË,ÖØ½¨±í,ÒòΪÎÒÃǰÑËûµÄĬÈÏ×Ö·û¼¯¸Ä¹ýÁË,ÎÒÃǺóÃæÔÙ½¨±í,×Ö·û¼¯¾ÍÊÇÎÒÃÇÏëÒªµÄ×Ö·û¼¯ÁË.
ÕâÖָķ¨Ï൱ÓÐЧ,¸Ä¹ýÖ®ºóÆäËûµØ·½»ù±¾É϶¼²»ÓøÄʲô×Ö·û¼¯ÁË,°üÀ¨¹ýÂËÆ÷ʲôµÄ,ºÃÏñ¶¼²»ÓÃ,·´ÕýÎÒÊÇûÓÐÓÃ,ÎÒÓõÄÊÇextjs+struts+tomcat+tomcatÊý¾ÝÔ´,¶Áд¶¼Õý³£Ã»ÓÐÂÒÂë,µ±È»Á¬½ÓÊý¾Ý¿âjdbc:mysql://localhost:3306/qxxt?useUnicode=true&characterEncoding=GBK;ÕâÀïÊÇÓÃÁË×Ö·ûµÄ


Ïà¹ØÎĵµ£º

ASP.NETÓëMySqlµÄÁ¬½Ó——Êý¾Ý¿â·ÃÎʲÙ×÷

1.¶Á³ö·½Ê½
DataReaderºÍDataSet¶¼¿ÉÒÔʵÏÖ¶ÔÊý¾Ý¿âÊý¾ÝµÄ²éѯ·µ»Ø£¬µ«Ç°ÕßÖ»ÄÜÌṩ¿ìËٵIJéѯ·½Ê½£¬ºóÕß»¹¿ÉÒÔʵÏÖ¶ÔÊý¾ÝµÄÌí¼Ó¡¢Ð޸ġ¢É¾³ý¹¦ÄÜ¡£
£¨1£©DataReader·½Ê½¶ÁÈ¡£º
string sConnString = "server=localhost;User Id=root;password=root;Persist Security Info=True;database=db_user";
MySqlConnection myC ......

MySQLÊý¾Ý¿âÎļþ½éÉÜ

mysqlµÄÊý¾Ý´¢´æÄ¿Â¼ÔÚmysqlµÄÅäÖÃÎļþmy.iniÎļþÉèÖ㬸ñʽÈçÏ£º
# Uncomment the following rows if you move the MySQL distribution to another
# location
basedir = d:/cyoa/mysql_cy/
datadir = d:/cyoa/mysql_cy/data/
      ÆäÖÐdatadirĿ¼¶¨ÒåÁËmysqlµÄÊý¾Ý´æ´¢Î»Öã¬MySQLµÄÿ¸ ......

MySQL´æ´¢¹ý³ÌÒÔ¼°ÔÚJAVAÖеijÌÐòµ÷ÓÃ

               ´æ´¢¹ý³ÌÊÇÒ»ÖÖ´æ´¢ÔÚÊý¾Ý¿âÖеijÌÐò£¨¾ÍÏñÕý¹æÓïÑÔÀïµÄ×Ó³ÌÐòÒ»Ñù£©£¬×¼È·µÄÀ´Ëµ£¬MySQLÖ§³ÖµÄ“routines£¨Àý³Ì£©”ÓÐÁ½ÖÖ£ºÒ»ÊÇÎÒÃÇ˵µÄ´æ´¢¹ý³Ì£¬ ¶þÊÇÔÚÆäËûSQLÓï¾äÖпÉÒÔ·µ»ØÖµµÄº¯Êý£¨Ê¹ÓÃÆðÀ´ºÍMysqlÔ¤×°ÔØµÄº¯ÊýÒ ......

ͨÓõÄmysql dump³ÌÐò

¿ÉÒÔÊÊÓÃÈκÎsql , ×Ô¶¯Ê¶±ð×Ö¶ÎÃû£¬ gzipѹËõ , ´øÊä³öbuffer , Ö§³Ö·Ö¿â·Ö±í
ÐèÒª¸¨Öú´úÂëºÍMakefie , ÏÂÃæÊÇÖ÷³ÌÐò´úÂ룬 
/**
* mysqlÊý¾Ý±ídump³ÌÐò
* @author : cheng limin
* @date : 2010-1-18
*
* ʹÓÃÑùÀý:
*./dump_mysql -c ../conf/dump.conf
* -t xml
* -s ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ