Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÇëÎÊ£¬mysql µÄË«»ú±¸·ÝʵÏÖ¹ýÂ𣿠ÎÊÌâ¼ûϱí

ÇëÎÊ£¬mysql µÄË«»ú±¸·ÝʵÏÖ¹ýÂð£¿
ÉèÖ÷½·¨£º
ÉèÖ÷¶Àý»·¾³£º
¡¡¡¡²Ù×÷ϵͳ£ºwindow2000 professional
¡¡¡¡mysql£º4.0.4-beta-max-nt-log
¡¡¡¡A ip:10.10.10.22
¡¡¡¡B ip:10.10.10.53
A:ÉèÖÃ
¡¡¡¡1.Ôö¼ÓÒ»¸öÓû§×îΪͬ²½µÄÓû§Õʺţº
GRANT FILE ON *.* TO backup@'10.10.10.53' IDENTIFIED BY ¡®1234¡¯
¡¡¡¡2.Ôö¼ÓÒ»¸öÊý¾Ý¿â×÷Ϊͬ²½Êý¾Ý¿â£º
create database backup
B:ÉèÖÃ
¡¡¡¡1.Ôö¼ÓÒ»¸öÓû§×îΪͬ²½µÄÓû§Õʺţº
GRANT FILE ON *.* TO backup@'10.10.10.22' IDENTIFIED BY ¡®1234¡¯
¡¡¡¡2.Ôö¼ÓÒ»¸öÊý¾Ý¿â×÷Ϊͬ²½Êý¾Ý¿â£º
create database backup


¡¡¡¡Ö÷´Óģʽ£ºA->;B
¡¡¡¡AΪmaster
¡¡¡¡ÐÞ¸ÄA mysqlµÄmy.iniÎļþ¡£ÔÚmysqldÅäÖÃÏîÖмÓÈëÏÂÃæÅäÖãº
server-id=1
log-bin
#ÉèÖÃÐèÒª¼Ç¼log ¿ÉÒÔÉèÖÃlog-bin=c:mysqlbakmysqllog ÉèÖÃÈÕÖ¾ÎļþµÄĿ¼£¬
#ÆäÖÐmysqllogÊÇÈÕÖ¾ÎļþµÄÃû³Æ£¬mysql½«½¨Á¢²»Í¬À©Õ¹Ãû£¬ÎļþÃûΪmysqllogµÄ¼¸¸öÈÕÖ¾Îļþ¡£
binlog-do-db=backup #Ö¸¶¨ÐèÒªÈÕÖ¾µÄÊý¾Ý¿â

¡¡¡¡ÖØÆðÊý¾Ý¿â·þÎñ¡£
¡¡¡¡ÓÃshow master status ÃüÁî¿´ÈÕÖ¾Çé¿ö¡£

¡¡¡¡BΪslave
¡¡¡¡ÐÞ¸ÄB mysqlµÄmy.iniÎļþ¡£ÔÚmysqldÅäÖÃÏîÖмÓÈëÏÂÃæÅäÖãº
server-id=2
master-host=10.10.10.22
master-user=backup #ͬ²½Óû§ÕʺÅ
master-password=1234
master-port=3306
master-connect-retry=60 Ô¤ÉèÖØÊÔ¼ä¸ô60Ãë
replicate-do-db=backup ¸æËßslaveÖ»×öbackupÊý¾Ý¿âµÄ¸üÐÂ

¡¡¡¡ÖØÆðÊý¾Ý¿â


Ïà¹ØÎÊ´ð£º

ÈçºÎ¶¨ÆÚɾ³ýmysqlÊý¾Ý - PHP / »ù´¡±à³Ì

ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË

¼Æ»®ÈÎÎñ...php....sql...truncate....OK

Äã¾ÍÕâ½ÓÔÚҳà ......

ÓйØmysqlµÄÎÊÌ⣡ - Java / Web ¿ª·¢

ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ

ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£

ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......

mysql root¸ÄÁËÃÜÂ룬ÓÖ×Ô¶¯±äÁË

¸Õ°²×°mysqlµÄʱºò£¬°Ñ³õʼÃÜÂëÍü¼ÇÁË£¬Ö»ºÃÌø¹ýȨÏÞÑéÖ¤£¬ÐÞ¸ÄÃÜÂ룬Ð޸ijɹ¦ºó£¬ÄܵǼ£¬¿ÉÊÇ»úÆ÷ÖØÆôÁË£¬ÓøĹýµÄÃÜÂëÓֵDz»ÉÏÁË£¬ÏÂÎÄÊÇÐ޸ĵķ½·¨£¬²»ÖªµÀÄÄÀï³öÁËÎÊÌ⣿
ÃÜÂëÐ޸ķ½·¨£º
  1.ÒÔϵͳ¹ ......

eclipseÁ¬½ÓmysqlÊý¾Ý¿â - Java / Eclipse

ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
java.sql.SQLException: Before start of result set
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java: ......

mysqlÊý¾ÝÕÒ»ØÄÑÌ⣬¸ß·Ö£¬¼±£¡£¡£¡

ÎÒÔÚÇåÀímysqlµÄʱºò£¬Ò»²»ÁôÉñ½«mysql(¼´dataÀïµÄmysqlÎļþ¼Ð)Êý¾Ý¿â¸øÉ¾µôÁË£¬¸ôÁ˼¸¸öСʱÎÒÖØÆôÁËmysqlÈí¼þ£¬mysql¾Í×Ô¶¯³õʼ»¯ÁËÊý¾Ý¿â£¬µ¼Ö´Óɾ³ýmysqlÎļþ¼Ð¿ªÊ¼µ½ÖØÆôÕâ¶Îʱ¼äµÄÊý¾Ý¶ªÊ§£¬ÄÇλ¸ßÊÖ°ïÏëÏë°ì ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ