±¸·ÝmysqlÊý¾Ý¿âµÄÎÊÌâ
ÏÖÔÚÓÐÕâô¸öÇé¿ö,ÎÒ×°µÄÊÇmysqlÂÌÉ«°æ2.5.Óà NaviCar 8.0 for MySQL ½¨Á¢Á¬½ÓºóÀïÃæÓÐ3¸ö¿â.
1¡¢information_schema
2¡¢mysql
3¡¢test
ÎÒÏëÓÃSQLÓï¾ä±¸·ÝÕâ3¸ö¿âÖÐµÄÆäÖÐÒ»¸ö£¬»òÕß¶¼±¸·Ý¡£ÔÚÍøÉÏÕÒµ½µÄ±¸·ÝÓë»Ö¸´SQLÈçÏ£º
±¸·Ý£º
/path/to/mysql/bin/mysqldump --flush-logs --opt -h HOST -u USER -pUSER_PASSWORD DB_NAME > /path/DB_NAME.dump
»Ö¸´£º
mysql -h HOST -u USER -p -pUSER_PASSWORD DB_NAME < /path/DB_NAME.dump
±¸·ÝÀïÃæµÄ /path/to/mysql/bin/mysqldump Õâ¸öÊÇʲô·¾¶£¿ »¹ÓÐ --flush-logs --opt ÕâÀïµÄÁ½¸ö -- ¶ÔÂð£¿
ÓÉÓÚ±¾È˽ϲˣ¬Ï£Íû¸ßÊÖÄܸøÒ»¸ö±È½ÏÍêÕûµÄ±¸·ÝÓë»Ö¸´Êý¾Ý¿âµÄSQL£¬ÐèÒªÌæ»»µÄµØ·½×¢Ã÷һϣ¬Ð»Ð»£¡
×¢:ÎÒÒªÓÃSQLÓï¾äÀ´±¸·Ý¶ø²»ÊÇÓÃmysqldumpÀ´±¸·Ý
/path/to/mysql/bin/mysqldump Õâ¸öÄãÄãµÄmysql·¾¶ÏµÄÎļþÃû
ÀýÈçÔÚwindowÏ£¬¾ÍÊÇ
ÄãµÄmysqlµÄ·¾¶/bin/mysqldump.exe
¿ÉÒԲο¼Ò»ÏÂÊÖ²áÖеÄ˵Ã÷¡£
MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc/refman/5.1/zh/index.html
Ïà¹ØÎÊ´ð£º
ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡
±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST
È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿
Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......
ÎÒ°²×°µÄÕâ¸öÈí¼þVertrigoServ£¬ÔÚwindows7ÖÐÔËÐУ¬Í¼±ê¼ÓºÅΪÀ¶É«£¬±¨MySQLµÄ´íÎó£¬Çë½Ì¸÷λ¸ßÊÖ¸ÃÔõÑù¸ü¸Ä¡£Ð»Ð»¸÷λ£¡
mysql ·þÎñÊÇ·ñÆðÀ´ÁË£¿
ûÓУ¬±¨µÄÊǶ˿ڴíÎó£¬ÔÚÅäÖÃÎļþµ±ÖиÄÁË£¬Ò²²»ÐÐ
¿ÉÒÔÓÃÈ ......
ÈçÌâ
²¹³äÏ£º
ÎÞ³ÌÐò£¬¸øË¼Â·Ò²ÐУ»
1. ÏÈÅжÏ֮ǰµÄͬ²½ÊÇ·ñÍê³ÉÁË¡£ ###ÈçºÎÅжϣ¿
2. ½øÐÐCHANGE MASTER TO ²Ù×÷¡£###ÎÒÖªµÀ¿ÉÒÔÇл»³É±¸·Ý»ú£¬µ«ÊDz»ÖªµÀÈçºÎÇл»»ØÖ÷·þÎñÆ÷£¬
ÎÒµÄÓÊÏäÊÇdo ......