Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ÈçºÎÓëC++Á¬½Ó£¿ - VC/MFC / Êý¾Ý¿â

ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡
±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST 
È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿
Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......

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¶ÁͼƬ·¾¶µ«ÊÇÎÞ·¨ÏÔʾ

´ó¼Ò°ïÎÒ¿´Ï°ɣ¬±¾À´Êý¾Ý¿âûÓж«Î÷£¬ÄÜÏÔʾûÓж«Î÷µÄÐÅÏ¢£¬µ«ÊÇÎÒÌí¼ÓÁËÒ»ÌõÄÚÈݺó£¬×ÖûÁË£¬µ«ÊÇͼƬҲÎÞ·¨ÏÔʾ£¬ºì²æ²æÒ²Ã»ÓУ¬Ôõô»ØÊ°¡£¿
PHP code:

<?php
$str="select * from product wh ......

ÔõôÔÚeclipseÏÂÏòmysql²åÈë±äÁ¿°¡ - Java / JavaÏà¹Ø

String SQL="insert into ѧÉúÐÅÏ¢±í values(StudentNumber,StudentName,StudentAge)";ÆäÖÐStudentNumber,StudentName,StudentAge¶¼ÊDZäÁ¿¡£ÕâÑùд²»¶Ô¡­¡­µ½µ×¸Ãզд°¡

Íò·Ö¸Ðл£¡

String SQL=&q ......

mysqlÖÐÎÄÂÒÂë - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

ÔÚC++³ÌÐòÖÐͨ¹ýmysqlµÄC APIÖ±½ÓÁ¬½ÓÊý¾Ý¿â£¬µ±°ÑÖÐÎIJåÈëmysqlµÄʱºò£¬¾Í±ä³ÉÂÒÂëÁË.
»¹ÓоÍÊÇʹÓÃload°ÑÎı¾Îļþµ¼ÈëmysqlÊý¾Ý¿â£¬ÎÞÂÛÎı¾ÎļþÊÇANSI±àÂ뻹ÊÇutf8±àÂ룬µ¼ÈëÖ®ºó¶¼ÊÇÂÒÂë¡£
ÆäÖÐmysqµÄ±àÂë¸ñʽ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ