mysql±íinnodbʹÓÃxtrabackup±¸·ÝÔÚwindowµÄÑùÀý
ËÄÜÌṩϹØÓÚinnodb±¸·Ý¹¤¾ßxtrabackupÔÚwindowϵı¸·ÝÓ뻹ԵÄÑùÀý£¬
СµÜÅöµ½ÎÊÌâÊÇÕâÑùµÄ£¬¿ÉÒԳɹ¦±¸·Ý£¬Ò²¿ÉÒÔÖ¸¶¨±í±¸·Ý£¬
1¡¢¹ØÓÚ¶à±í±¸·ÝÔõôʵÏÖ£¿
2¡¢±¸·Ý³öÀ´ºóÖ»ÓÐÊý¾ÝÎļþidb£¬£¨Í¨¹ýÐÞ¸ÄÅäÖÃÎļþÖвÎÊý£¬ÒÑÈø÷±íµÄÊý¾ÝÎļþ¶ÀÁ¢´æÔÚ£©£¬Ã»Óбí½á¹¹£¬Ôõô°ì£¿ÒòΪÔÀ´µÄÊý¾Ý¿âµÄ±íÐèÒª±»Ïú»Ù¡£
3¡¢Èç¹û»¹Ôµ½±ðÍâµÄÒ»¸öÊý¾Ý¿âÖУ¿
xtrabackup ûÓùý¡£Èç¹ûÄãʹÓÃMYSQL×Ô´øµÄmysqldump µ¹»¹¿ÉÒÔ°ïÄãÕÒһϷ½·¨¡£
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡
±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST
È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿
Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......
mysqlÊý¾Ý¿âµÄ±àÂë¸ñʽÊÇutf8
ÔÚc++³ÌÐòÖÐʹÓÃC APIÖ±½ÓÁ¬½ÓmysqlÊý¾Ý¿â£¬°ÑÖÐÎı£´æµ½mysqlÊý¾Ý¿âÖУ¬ÖÐÎç±ä³ÉÂÒÂë
ʹÓÃmysqlµÄloadÃüÁîµ¼ÈëÎı¾Îļþ£¬ÎÞÂÛÎı¾ÎļþÊÇANSI»¹ÊÇutf8±àÂ룬¶¼ÊÇÂÒÂë
ÇëÎÊÉÏÃæÁ½¸öÎÊ ......
±í
CREATE TABLE `ch1` (
`id` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT,
`no` int(10) unsigned DEFAULT NULL,
`dtime` datetime DEFAULT NULL,
PRIMARY KEY (`id ......
mysqlµÄÖ´ÐÐinsertÊÇ·ñÓзµ»ØÖµ£¿ÏñoracleµÄ·µ»ØÖµÊÇsqlcode£¬
mysqlÓзµ»ØÖµÃ´£¿Âé·³ÄÄλ¸æËßһϡ£
°ï¶¥ MYSQL½¨ÒéÈ¥ÆäËûÊý¾Ý¿â¿ª·¢°æ¿é
mysqlÓзµ»ØÖµÃ´£¿
---
ÎÒÖªµÀmssqlÓУ¬@@error
²»ÖªµÀÓÐûÓÐÀàË ......
±íÁÐ×Ö¶ÎÔÚÎÞÖµµÄÇé¿öÏÂ
ĬÈÏֵΪnullºÃ,»¹Êǿհ×ÖµºÃÄØ?
1)¶ÔÊý¾Ý²åÈë/²éѯ/µÄÓ°ÏìÈçºÎ?
2)¶Ô¸ÃÁнøÐÐË÷Òý,»áÓв»Í¬µÄЧÓÃô?
´ó¼ÒÒ»°ã¶Ô±êÌâ×ֶεÄλÊýÉèΪ¶àÉÙ?256
ÕýÎÄ×ֶεÄ?text?
¼¸Ç§ÍòÌõµÄÊý¾Ý´æ´¢,Òª ......