mysql±¸·ÝÎÊÌâ¡£¼±£¡£¡£¡£¡£¡
¸ßÊÖ£¬ÏÖÔÚÓöµ½Ò»¸ömysql±¸·ÝµÄÎÊÌâ¡£
ÎÒµÄÊý¾Ý¿âÀïÓÐһЩÓÃcreate function½¨Á¢µÄ×Ô¶¨Ò庯Êý¡£µ±ÎÒÓÃmysqldump±¸·Ý¸ÃÊý¾Ý¿âÈ»ºóµ¼Èëµ½ÁíÍâÒ»¸ö·þÎñÆ÷BÉÏ£¬·¢ÏÖ·þÎñÆ÷BÉÏÖ»ÓÐÊý¾Ý£¬¶øÃ»ÓÐÄÇЩ×Ô¶¨ÒåµÄº¯Êý¡£ÎҸоõmysqldumpÖ»±¸·ÝÊý¾ÝºÍ±í£¬²¢²»±¸·Ý×Ô¶¨Ò庯Êý¡£
ÓÐûÓÐʲômysqlÃüÁî¿ÉÒÔÒ»Æð±¸·ÝÁ˰¢¡£²»Òª¸æËßÎÒÓÃʲô¹¤¾ß£¬ÎÒÏÖÔڵķþÎñÆ÷ÉÏʲô¹¤¾ß¶¼²»Äܰ²×°£¬Ö»ÄÜÓÃÖ´ÐÐmysql×Ô¼ºµÄ±¸·ÝÃüÁî¡£
лл£¡
¼Ó-R²ÎÊý¾ÍÓÐ
-R, --routines Dump stored routines (functions and procedures).
-E, --events Dump events.
ÒòΪ´æ´¢¹ý³Ì²¢Ã»ÓдæÔÚÊý¾Ý¿âµÄĿ¼ÖУ¬¶øÔÚ´æÔÚmysqlÊý¾Ý¿âÖС£
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÏÖÔÚÓÐÒ»¸öÍøÕ¾£¬ÏëÔÚÁíÍâһ̨·þÎñÆ÷ÉÏ×öÒ»¸öÕâ¸öÍøÕ¾µÄ¾µÏñ¡£
ÔÚÖ÷ÍøÕ¾ÉϵÄÊý¾Ý¸üÐÂҪͬ²½µ½¾µÏñ·þÎñÆ÷ÉÏ
ͬʱÓû§·ÃÎʾµÏñ·þÎñÆ÷ʱµÄÊý¾Ý¸üÐÂҲҪͬ²½µ½Ö÷ÍøÕ¾ÉÏ
ÆäÖÐÊý¾Ý¸üРÖ÷Òª°üÀ¨ MysqlÊý¾Ý¿âµ ......
ÎÒ֮ǰµ¼ÈëµÄÊý¾Ý¿â£¬ÏÖÔÚɾ³ý²»ÁË£¬ÓÃÁËÃüÁîÐк͹¤¾ß¶¼²»ÐУ¬ÖØÆôÒ²²»ÐУ¬ÕâÊÇÎªÊ²Ã´ÄØ£¿
ÄãÊÇÈçºÎɾ³ýµÄ£¿
ÓÐʲôÌáʾ£¿
ÎÊÌâ˵Ã÷Ô½Ïêϸ£¬»Ø´ðÒ²»áԽ׼ȷ£¡²Î¼ûÈçºÎÌáÎÊ¡££¨ÌáÎʵÄÖǻۣ©
......
ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......