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

MySQLµ¼Èëµ¼³öÃüÁî

MySQLµ¼Èëµ¼³öÃüÁî
1.µ¼³öÕû¸öÊý¾Ý¿â
¡¡¡¡mysqldump -u Óû§Ãû -p Êý¾Ý¿âÃû > µ¼³öµÄÎļþÃû
¡¡¡¡mysqldump -u wcnc -p smgp_apps_wcnc > wcnc.sql
2.µ¼³öÒ»¸ö±í
¡¡¡¡mysqldump -u Óû§Ãû -p Êý¾Ý¿âÃû ±íÃû> µ¼³öµÄÎļþÃû
¡¡¡¡mysqldump -u wcnc -p smgp_apps_wcnc users> wcnc_users.sql
3.µ¼³öÒ»¸öÊý¾Ý¿â½á¹¹
¡¡¡¡mysqldump -u wcnc -p -d --add-drop-table smgp_apps_wcnc >d:wcnc_db.sql
¡¡¡¡-d ûÓÐÊý¾Ý --add-drop-table ÔÚÿ¸öcreateÓï¾ä֮ǰÔö¼ÓÒ»¸ödrop table
4.µ¼ÈëÊý¾Ý¿â
¡¡¡¡³£ÓÃsource ÃüÁî
¡¡¡¡½øÈëmysqlÊý¾Ý¿â¿ØÖÆÌ¨£¬
¡¡¡¡Èçmysql -u root -p
¡¡¡¡mysql>use Êý¾Ý¿â
¡¡¡¡È»ºóʹÓÃsourceÃüÁºóÃæ²ÎÊýΪ½Å±¾Îļþ(ÈçÕâÀïÓõ½µÄ.sql)
¡¡¡¡mysql>source d:wcnc_db.sql £¨×¢£ºÈç¹ûд³Ésource d:\wcnc_db.sql£¬¾Í»á±¨Óï·¨´íÎó£©
×¢Ò⣺ʹÓõ¼ÈëÊý¾Ý¿âÃüÁîµÄÊý¾Ý¿âÎļþ±ØÐëÔÚmysqlµÄbinĿ¼Ï²ſÉÒÔ
µ¼³ö²éѯ½á¹û£ºmysql>select   *   from   ±í   into   outfile   'c:\aaa.txt';


Ïà¹ØÎĵµ£º

MySQLÖ÷´Ó·þÎñÆ÷£¨Replication£©µÄÉèÖÃ

Ê×ÏÈÉèÖÃMySQLÖ÷·þÎñÆ÷£º
ÔÚÖ÷·þÎñÆ÷ÉÏΪ´Ó·þÎñÆ÷½¨Á¢Ò»¸öÓû§£º
grant replication slave on *.* to 'Óû§Ãû'@'Ö÷»ú' identified by 'ÃÜÂë';
Èç¹ûʹÓõÄÊÇMySQL 4.0.2֮ǰµÄ°æ±¾£¬ÔòÓÃfileȨÏÞÀ´´úÌæreplication slave
±à¼­Ö÷·þÎñÆ÷µÄÅäÖÃÎļþ£º/etc/my.cnf
server-id=1
log-bin
binlog-do-db=ÐèÒª¸´ÖƵÄÊý¾Ý¿âÃû£ ......

mysql×Ó²éѯ exists,not exists


(1)ʵÏÖÈýá¹û¼¯A-½á¹û¼¯B£º--ÀûÓÃnot
exists£¬ºÏ²¢Ôò¿ÉÓÃunion
exists,not
exists£ºÓÃÓÚÅжÏÇÒ»ñÈ¡½á¹û¼¯AÊÇ·ñ´æÔڵؽá¹û¼¯BÖÐ!
==========½á¹û¼¯A£º
SELECT
d.Device_ID,d.Device_Name,a.App_ID,a.App_Name
               from
T_ ......

windows°²×°apache+php+mysqlµÄһЩ¼Ç¼

apache°²×°£¬mysql°²×°£¬php5Ö±½Ó½âѹ£¬¾ù·ÅÔÚD:\wwwÏ¡£
Ŀ¼½á¹¹Îª£º
D:\www\apache2
D:\www\mysql
D:\www\php5
½«php5\php.ini-dist¸´ÖÆÎªphp.ini£¬°ÑÐèÒªÓõ½µÄ×é¼þ½«Ç°ÃæµÄ;È¥µô¡£
Èç
extension=php_mysql.dll
extension=php_gd2.dll
ÔÚapache2µÄconf/httpd.confÎļþÖмÓ
LoadFile D:/www/php5/php5ts.dll
......

MySQL²é¿´ºÍµ¼Èëµ¼³öÃüÁî

1¡¢ÏÔʾÊý¾Ý¿âÁÐ±í£º
   show databases;
   ¸Õ¿ªÊ¼Ê±²ÅÁ½¸öÊý¾Ý¿â£ºmysqlºÍtest¡£mysql¿âºÜÖØÒªËüÀïÃæÓÐMYSQLµÄϵͳÐÅÏ¢£¬ÎÒÃǸÄÃÜÂëºÍÐÂÔöÓû§£¬Êµ¼ÊÉϾÍÊÇÓÃÕâ¸ö¿â½øÐвÙ×÷¡£
2¡¢ÏÔʾ¿âÖеÄÊý¾Ý±í£º
   use mysql£» //´ò¿ª¿â
   show tables;
3¡¢ÏÔʾÊý¾Ý±íµÄ½á¹¹£ ......

MySQLÖеÄmysqldumpÃüÁîʹÓÃÏê½â

MySQLÓкܶà¿ÉÒÔµ¼ÈëÊý¾ÝµÄ·½·¨£¬È»¶øÕâЩֻÊÇÊý¾Ý´«ÊäÖеÄÒ»°ë£¬ÁíÍâµÄÒ»°ãÊÇ´ÓMySQLÊý¾Ý¿âÖе¼³öÊý¾Ý¡£ÓÐÐí¶àµÄÔ­ÒòÎÒÃÇÐèÒªµ¼³öÊý¾Ý¡£Ò»¸öÖØÒªµÄÔ­ÒòÊÇÓÃÓÚ±¸·ÝÊý¾Ý¿â¡£Êý¾ÝµÄÔì¼Û³£³£Êǰº¹óµÄ£¬ÐèÒª½÷É÷´¦ÀíËüÃÇ¡£¾­³£µØ±¸·Ý¿ÉÒÔ°ïÖú·ÀÖ¹±¦¹óÊý¾ÝµØ¶ªÊ§£»ÁíÍâÒ»¸öÔ­ÒòÊÇ£¬Ò²ÐíÄúÏ£Íûµ¼³öÊý¾ÝÀ´¹²Ïí¡£ ÔÚÕâ¸öÐÅÏ¢¼¼Êõ²»¶ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ