Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Êý¾Ý¿âµÄ¸üÐÂ

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


Ïà¹ØÎÊ´ð£º

c,c++Á¬½Ómysql ÕÒ²»µ½Í·²¿Îļþ£¨ÐÂÊÖ£©

±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......

mysqlµÄÁ¬½Ó³¬Ê±Ê±¼äÔõôÉèÖà - VC/MFC / Êý¾Ý¿â

ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))

AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......

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

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

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

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

MysqlЧÂÊÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

±í
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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ