MySQLɾ³ýË÷Òý
MySQLɾ³ýË÷ÒýµÄʱºòÊDz»ÊÇдʲôÎļþ°¡ £¬ÒòΪÎÒ·¢ÏÖÔÚɾ³ýË÷ÒýʱÎÒµÄÓ²Å̿ռäÔÚ¼õÉÙ£¿É¾³ýË÷ÒýÊÇʲô»úÖÆ°¡£¿Çë½âÊÍһϠлл
±íʲôÒýÇæ ±íÊÇʲô´æ´¢ÒýÇæ£¿ Èç¹ûÊÇ myisam µÄ»°£¬»áÔÚ xxx.idx ÎļþÖнøÐÐɾ³ý£¬µ«²»»áÂíÉϼõÉÙÎļþ³ß´ç¡£ Èç¹ûÊÇ innodb£¬ÔòË÷ÒýÊý¾ÝÔÚibdata? ÖУ¬ÓÀÔ¶²»»áÊÍ·ÅÎļþ³ß´ç£¬³ý·ÇÖØ¹¹ myusamÒýÇæ£¬ÊÇÎÒÔÚɾ³ýʱºò·¢ÏÖ´ÅÅÌʹÓÿռäÔÚÔö¼Ó £¬Ò»¶¨ÊÇÔÚдʲôÎļþ°¡ ÒýÓà ÊÇÎÒÔÚɾ³ýʱºò·¢ÏÖ´ÅÅÌʹÓÿռäÔÚÔö¼Ó £¬Ò»¶¨ÊÇÔÚдʲôÎļþ°¡ ºÜ¶àÎļþҪд°¡¡£ µ±Äã×öÒ»¸ö²Ù×÷µÄʱºò£¬MYSQLÐèҪд ÈÕÖ¾Îļþ£¨ÆÕͨÈÕÖ¾£¬¶þ½øÖÆÈÕÖ¾£¬»¹ÓÐÁÙʱ±íÎļþµÈµÈ£© ÎÒûÓдò¿ªÈÕÖ¾Îļþ ÄǾÍÊÇÔÚдÁÙʱÎļþÁË£¿ ±íÓжà´ó£¿ÈÕÖ¾´ò¿ªÃ»ÓУ¿ ÊǵÄÁÙʱÎļþ¡£ ±íÓÐ1.7G Ë÷ÒýΪ600M ûÓдò¿ªÈÕÖ¾ ºÃµÄ ллÄãÃÇ °¡ ½áÌù¸ø·Öʱµã´íÁË ºÇºÇ£¬ ÎÞËùν SORRY
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃmysql×Ô´øµÄC API if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0)) { AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it. ¿ÉÊÇÎÒÕÒ ......
Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......
ÎÒ¿ª·¢ASP.netʱ ²åÈëÍâÎÄÂÒÂë SHOW VARIABLES LIKE 'character%'; Õâ¸öʱºò character_set_client utf8 character_set_connection utf8 character_set_database utf8 ch ......
¸Õ°²×°mysqlµÄʱºò£¬°Ñ³õʼÃÜÂëÍü¼ÇÁË£¬Ö»ºÃÌø¹ýȨÏÞÑéÖ¤£¬ÐÞ¸ÄÃÜÂ룬Ð޸ijɹ¦ºó£¬ÄܵǼ£¬¿ÉÊÇ»úÆ÷ÖØÆôÁË£¬ÓøĹýµÄÃÜÂëÓֵDz»ÉÏÁË£¬ÏÂÎÄÊÇÐ޸ĵķ½·¨£¬²»ÖªµÀÄÄÀï³öÁËÎÊÌ⣿ ÃÜÂëÐ޸ķ½·¨£º 1.ÒÔϵͳ¹ ......