MYSQL¹ÜÀí
¶¨ÆÚά»¤ÄãµÄÊý¾Ý±í¡£
¹¤¾ß£ºmysqlcheck myisamchk
mysqlcheck¿Í»§¶Ë¿ÉÒÔ¼ì²éºÍÐÞ¸´MyISAM±í¡£Ëü»¹¿ÉÒÔÓÅ»¯ºÍ·ÖÎö±í¡£
mysqlcheckµÄ¹¦ÄÜÀàËÆmyisamchk£¬µ«Æ乤×÷²»Í¬¡£
Ö÷Òª²î±ðÊǵ±mysqld·þÎñÆ÷ÔÚÔËÐÐʱ±ØÐëʹÓÃmysqlcheck£¬¶ømyisamchkÓ¦ÓÃÓÚ·þÎñÆ÷ûÓÐÔËÐÐʱ¡£
ʹÓÃmysqlcheckµÄºÃ´¦ÊDz»ÐèҪֹͣ·þÎñÆ÷À´¼ì²é»òÐÞ¸´±í¡£
Ö´Ðз½·¨£º
cmd> mysqlcheck[options] db_name [tables]
cmd> mysqlcheck[options] ---database DB1 [DB2 DB3...]
cmd> mysqlcheck[options] --all--database
²ÎÊý£º
--all--database£¬-A
--analyze£¬-a ·ÖÎö±í¡£
--auto-repair Èç¹ûij¸ö±»¼ì²éµÄ±íÆÆ»µÁË£¬×Ô¶¯ÐÞ¸´Ëü¡£¼ì²éÍêËùÓбíºó×Ô¶¯½øÐÐËùÓÐÐèÒªµÄÐÞ¸´¡£
--check£¬-c ¼ì²é±íµÄ´íÎó¡£
--check-only-changed£¬-C Ö»¼ì²éÉϴμì²éÒÔÀ´ÒѾ¸ü¸ÄµÄ»òûÓÐÕýÈ·¹Ø±ÕµÄ±í¡£
---database£¬-B ´¦ÀíÊý¾Ý¿âÖÐÃüÃûµÄËùÓÐ±í¡£Ê¹ÓøÃÑ¡ÏËùÓÐ×ÖÃû²ÎÁ¿±»¿´×÷Êý¾Ý¿âÃû£¬¶ø²»ÊDZíÃû¡£
--extended£¬-e Èç¹ûÄãÕýʹÓøÃÑ¡ÏîÀ´¼ì²é±í£¬¿ÉÒÔÈ·±£ËüÃÇ100%µØÒ»Ö£¬µ«ÐèÒªºÜ³¤µÄʱ¼ä¡£
Èç¹ûÄãÕýʹÓøÃÑ¡ÏîÀ´ÐÞ¸´±í£¬ÔòÔËÐÐÀ©Õ¹ÐÞ¸´£¬²»µ«Ö´ÐеÄʱ¼äºÜ³¤£¬¶øÇÒ»¹»á²úÉú´óÁ¿µÄÀ¬»øÐÐ!
--fast£¬-F Ö»¼ì²éûÓÐÕýÈ·¹Ø±ÕµÄ±í¡£
--force£¬-f ¼´Ê¹³öÏÖSQL´íÎóÒ²¼ÌÐø¡£
--medium-check£¬-m Ö´ÐбÈ--extended²Ù×÷¸ü¿ìµÄ¼ì²é¡£Ö»ÄÜ·¢ÏÖ99.99%µÄ´íÎó£¬ÔÚ´ó¶àÊýÇé¿öÏÂÕâÒѾ×ã¹»ÁË¡£
--optimize£¬-o ÓÅ»¯±í¡£
--quick£¬-q Èç¹ûÄãÕýʹÓøÃÑ¡ÏîÔÚ¼ì²é±í£¬Ëü·ÀֹɨÃèÐÐÒÔ¼ì²é´íÎóÁ´½ÓµÄ¼ì²é¡£ÕâÊÇ×î¿ìµÄ¼ì²é·½·¨¡£
Èç¹ûÄãÕýʹÓøÃÑ¡ÏîÔÚÐÞ¸´±í£¬Ëü³¢ÊÔÖ»ÐÞ¸´Ë÷ÒýÊ÷¡£ÕâÊÇ×î¿ìµÄÐÞ¸´·½·¨¡£
--repair£¬-r Ö´ÐпÉÒÔÐÞ¸´´ó²¿·ÖÎÊÌâµÄÐÞ¸´£¬Ö»ÊÇΨһֵ²»Î¨Ò»Ê±²»ÄÜÐÞ¸´¡£
--tables ¸²¸Ç---database»ò-BÑ¡ÏѡÏîºóÃæµÄËùÓвÎÁ¿±»ÊÓΪ±íÃû¡£
Innodb ±íÔò¿ÉÒÔͨ¹ýÖ´ÐÐÒÔÏÂÓï¾äÀ´ÕûÀíËéƬ£¬Ìá¸ßË÷ÒýËٶȣº
ALTER TABLE tbl_name ENGINE = Innodb;
ÕâÆäʵÊÇÒ»¸ö NULL ²Ù×÷£¬±íÃæÉÏ¿´Ê²Ã´Ò²²»×ö£¬Êµ¼ÊÉÏÖØÐÂÕûÀíËéƬÁË¡£
ͨ³£Ê¹ÓÃµÄ MyISAM ±í¿ÉÒÔÓÃÉÏÃæÌáµ½µÄ»Ö¸´·½·¨À´Íê³É¡£Èç¹ûÊÇË÷Òý»µÁË£¬¿ÉÒÔÓ
Ïà¹ØÎĵµ£º
Windows:
1. ÓÃϵͳ¹ÜÀíÔ±µÇ½ϵͳ¡£
2. Í£Ö¹MySQLµÄ·þÎñ¡£
3. ½øÈëÃüÁî´°¿Ú(cmd)£¬È»ºó½øÈëMySQLµÄ°²×°Ä¿Â¼£¬±ÈÈçÎҵݲװĿ¼ÊÇc:\mysql,½øÈëC:\mysql\bin
4. Ìø¹ýȨÏÞ¼ì²éÆô¶¯MySQL£¬
c:\mysql\bin>mysqld-nt --skip-grant-tables
5. ÖØдò¿ªÒ»¸öcmd´°¿Ú£¬½øÈëc:\mysql\b ......
ÎÒд¹ýµÄ½Ì³Ì²»¶à£¬¶øÇҴ󲿷ֶ¼ÊÇÀ´Ô´ÓÚ±ðÈ˵Ľ̳̣¬²»¹ý£¬ÕâÀïËù½éÉܵģ¬¶¼ÊÇÈÚÈëÎÒËù×ܽáµÄ¾Ñ飮££ÒýÑÔ
¡¡¡¡
¡¡¡¡PHPµÄÖ´ÐÐЧÂÊÊÇÓÐÄ¿¹²¶ÃµÄ£¬ÕâÒ²ÊÇÎÒϲ»¶ËüµÄÔÒòÖ®Ò»£¬ºÍËü³ÆΪ¾øÃî´îµµµÄMysqlÒÔ¼°ApacheÏëÈںϣ¬²»Äܲ»¾ªÌ¾ÆäЧÂÊÁË¡£PHP¸üÐÂÒ²ºÜ¿ì£¬ÕâÀïÁоÙÁËÄ¿Ç°×îа汾PHP4.3.2RC4£¨¼¸ºõûÓÐBUGÁË£¬¹À¼ÆÐ´Í ......
ERROR 1005 (HY000): Can't create table ' ****.frm' (errno: 150)
ÎÒÊÇ´ÓÒÔϼ¸¸ö·½Ãæ½â¾öÁË´ËÎÊÌ⣺
1¡¢È·±£²ÎÕյıíºÍ×Ö¶ÎÊÇ´æÔڵģ»
2¡¢×é³ÉÍâ¼üµÄ×Ö¶ÎÒªÇó±»Ë÷Òý(Ö÷ÒªÊÇÍâ¼üÄǸö×Ö¶ÎÒªÇóÔÚÆäËû±íÖÐÊÇÖ÷¼ü)£»
3¡¢Íâ¼ü¹ØÁªµÄÁ½±í»ò¶à±íÒªÇó¶¼ÊÇINNODBÀàÐÍµÄ±í£»
4¡¢×Ö¶ÎÀàÐÍ£¨ËµÃ÷£©ÒªÒ»Ñù`itemId` varchar( ......
·ÖÒ³¹¦ÄܵÄʵÏÖÊÇÿÖÖWEB¿ª·¢ÓïÑÔ±ØÐëҪʵÏֵŦÄÜ¡£PHPÒ²ºÃ,JSPÒ²°Õ¡£ÎÒ×¼±¸ÓÃÁ½¸ö·½·¨À´²ûÊöPHP+MYSQLʵÏÖ·ÖÒ³µÄ¹¦ÄÜ¡£
Ò»¡¢·ÖÒ³³ÌÐòµÄÔÀí
·ÖÒ³³ÌÐòÓÐÁ½¸ö·Ç³£ÖØÒªµÄ²ÎÊý£ºÃ¿Ò³ÏÔʾ¼¸Ìõ¼Ç¼£¨$pagesize£©ºÍµ±Ç°Êǵڼ¸Ò³£¨$page£©¡£ÓÐÁËÕâÁ½¸ö²ÎÊý¾Í¿ÉÒԺܷ½±ãµÄд³ö·ÖÒ³³ÌÐò£¬ÎÒÃÇÒÔMySqlÊý¾Ý¿â×÷ΪÊý¾ÝÔ´£¬ ......
ÏÈÇ°ÔÚ²âÊÔmysql connect c++½Ó¿ÚµÄʱºòÔËÐÐÆä¹Ù·½ÌṩµÄÀý×Ó
21.5.5.6. MySQL Connector/C++ Complete Example 2
The following code shows a complete example of how to use MySQL Connector/C++:
/* Copyright 2008 Sun Microsystems, Inc.
This program is free software; you can redistribute it and/or modify ......