mysqlµÇ²»ÉÏ
ÎÒ×°ÍêMysql£¬½øMySQL Command Line Client¸ÕÊäÈëÃÜÂëÒ»»Ø³µ¾Í³öÏÖConnection error 2013: Lost connection to MySQL server during query¡£ÉÁһϾÍûÁË¡£ÕâÓ¦¸ÃÊÇ´íÎóÈÕÖ¾£º
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
100309 16:28:43 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
100309 16:28:43 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 10 MB
InnoDB: Database physically writes the file full: wait...
100309 16:28:44 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
100309 16:28:44 InnoDB: Started; log sequence number 0 0
100309 16:28:44 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.22-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
ºÜÍ·ÌÛ£¬×°Á˼¸´Î¶¼ÕâÑù¡£ÓÐʲôºÃ°ì·¨£¿
²»¶®£¬°ï¶¥°É£¡ÊDz»ÊÇÄãÒÔǰûж¸É¾»Ñ½£¡
°Ù¶ÈһϠºÃÏñÐèÒª¸Ä Á¬½Ó³¬Ê±µÄ²ÎÊý¡£¡£
È¥ÆäËûÊý¾Ý¿â/MySqlÇøÎÊÎÊ¿´¡£
lost connectionÒԺ󣬷þÎñÊÇ
Ïà¹ØÎÊ´ð£º
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ
ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£
ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
mysqlÊý¾Ý¿âµÄ±àÂë¸ñʽÊÇutf8
ÔÚc++³ÌÐòÖÐʹÓÃC APIÖ±½ÓÁ¬½ÓmysqlÊý¾Ý¿â£¬°ÑÖÐÎı£´æµ½mysqlÊý¾Ý¿âÖУ¬ÖÐÎç±ä³ÉÂÒÂë
ʹÓÃmysqlµÄloadÃüÁîµ¼ÈëÎı¾Îļþ£¬ÎÞÂÛÎı¾ÎļþÊÇANSI»¹ÊÇutf8±àÂ룬¶¼ÊÇÂÒÂë
ÇëÎÊÉÏÃæÁ½¸öÎÊ ......
ÎÒ¼¸ÕÅmysql±í ·ÖÇø
È»ºó°Ñ·ÖÇø±íµ¥¶À¿½³öÀ´
ÀýÈ磺test.MYD test.MYI data.MYD data.MYI user.MYD user.MYI dem.MYD dem.MYI
ÎÒÏë¶ÁÈ¡ÕâËÄÕűíµÄÄÚÈÝ
¹ØÁªÊý¾ÝÕûºÏµ½Ò»ÕűíÖС£Õâ¸öÒªÔõô×öÄØ
ÓóÌÐòÔ ......
mysql¶¨Ê±±¸·Ý ÔÚwindowsÉÏ
¿ÉÒÔÏÂÔØÒ»¸ö Navicat for MySQL£¬ÀïÃæÓиö¶¨Ê±±¸·Ý¹¦ÄÜ£¬·Ç³£ºÃÓá£
дһ¸öphpµÄ±¸·Ýº¯Êý.È»ºóÀûÓÃwindowsµÄ¼Æ»®ÈÎÎñÖ´Ðб¸·Ý³ÌÐò!
Navicat¡£¡£ÀïÃæ¿ÉÒÔд±¸·Ý¼Æ»®µÈ
ÊDz»ÊÇÓà ......