MySQL¶þ½øÖÆÈÕÖ¾ÓÐ--binlog-do-db=db_nameÑ¡Ïî¿ÉÖ¸¶¨¼Ç¼ָ¶¨Êý¾Ý¿âµÄ±ä¸üÐÅÏ¢£¬ÆäËûµÄÔòºöÂÔ¡£ÎÊÌâÊDzéѯÈÕÖ¾logÓÐûÓÐÏàÓ¦µÄÑ¡Ï¿ÉÒÔÖ»¼Ç¼ָ¶¨µÄÊý¾Ý¿âµÄÈÕ־Ĩ£¿
ÎÒÄÜÓÐÄãµÄQQ²» £¬ÎÒµÄÊÇ247782779¡£
......
½ñÌìÀÏ´ó²¼ÖøöÈÎÎñ£¬ÒªÎÒÔÚÎÒÃǵIJúÆ·Öа²×°Ò»¸öMYSQLÊý¾Ý¿â£¬ÒªÇóÊÇÈí¼þÕ¼Óÿռ䲻Äܳ¬¹ý5M¡£
ÔÚÍøÉÏÕÒÁ˺þÃҲûÓÐÕÒµ½¹ØÓÚǶÈëʽϵͳÖÐMySQLÊý¾Ý¿âµÄ×ÊÁÏ£¬ÓеÄÒ²Ö»ÊǼòµ¥Ìáһϡ£
ÏÖÌØÏò¸÷λÇë½ÌÒÔÏÂÎÊÌ⣺
1.ÎÒÓ¦¸ÃѡȡµÄMySQLÊý¾Ý¿âµÄ°æ±¾£»
2.¹«Ë¾²úÆ·ÊÇARMоƬ£¬ÈçºÎ¼«ÐÔÒÆÖ²£»
3.ÊÇ·ñ¿ÉÒÔ¶ÔMySQL½øÐвüô£¬È ......
±£»¤mysql£¬Çë´ó¼ÒÒ»ÆðÀ´Ç©Ãû¡£
http://helpmysql.org/cn/theissue/customerspaythebill
mysqlÊÇÈ«ÊÀ½ç×îÓÅÐãµÄ¿ªÔ´Êý¾Ý¿âϵͳ£¬×÷ΪһÃûÊý¾Ý¿âʹÓÃÕߣ¬ÎҵĴ󲿷ֹ¤×÷¶¼ÓëmysqlÏà¹Ø£¬ËäÈ»ÆÚ¼äÒ²Éæ¼°µ½oracleÒÔ¼°sqlserverÊý¾Ý¿âϵͳ£¬µ«mysqlµÄÓÅÐãµÄ±íÏÖʹÎÒ¶ÔËüÎÒÇéÓжÀÖÓ¡£
ÔÚÕâÀïÎÒÏìÓ¦Õâ¸ö±£»¤³«Ò飬²¢ÇëÇ ......
ÎÒÓиöÐèÇó£º
Èý¸ömysqlµÄMaster---A,B,C.Ò»¸ömysqlµÄSlave---S
AÖÐÓÐÕűíT_A£»BÖÐÓÐÕűíT_B£»CÖÐÓÐÕűíT_C£»¶øÔÚSÖÐÓÐÈýÕÅ±í£¬T_A,T_B,T_C¡£·Ö±ð¶ÔÓ¦T_A,T_B,T_C¡£
ÎÒÏëA,B,C,ÖÐдÈëÊý¾Ý£¬ÒªÍ¬²½µ½SÖС£
Ò²¾ÍÊÇ˵£ºÈý¸öÖ÷£¬Ò»¸ö´Ó¡£ÔÚmysqlÀïÃæ¿É·ñʵÏÖÄØ£¿£¿
ÎÒÑо¿Á˺þÃÁË£¬Ã»ÓÐʵÏÖ¡£ÓÐÈË˵²»¿É ......
ʹÓÃÏÂÃæµÄÐ޸ĻáÌáʾ´íÎó£º1005 - Can't create table 'csgps.#sql-388_176' (errno: 121)
SQL code:
[SQL] ALTER TABLE `t_terminal`
DROP FOREIGN KEY `FK704405E7F06A14EF`,
ADD CONSTRAINT `FK704405E7F06A14EF` FOREIGN KEY (`userId`) REFERENCES `t_user` (`id`) ON DELETE CASCADE ON UPDATE ......
MySQLºÍMySQLi
ÓÐÊ²Ã´Çø±ðºÍÓ÷¨°¡£¿
mysqlÊǷdzּÌÁ¬½Óº¯Êý¶ømysqliÊÇÓÀÔ¶Á¬½Óº¯Êý¡£Ò²¾ÍÊÇ˵mysqlÿ´ÎÁ´½Ó¶¼»á´ò¿ªÒ»¸öÁ¬½ÓµÄ½ø³Ì¶ømysqli¶à´ÎÔËÐÐmysqli½«Ê¹ÓÃͬһÁ¬½Ó½ø³Ì,´Ó¶ø¼õÉÙÁË·þÎñÆ÷µÄ¿ªÏú.
mysqliÀ಻ÊÇphp×Ô´øµÄÂ𣿲»ÊÇĬÈÏ¿ªÆôµÄ£¬winÏÂÒª¸Äphp.ini,È¥µôphp_mysqli.dllǰµÄ;
linuxÏÂÒª°Ñmysq ......