¹ØÓÚMySQL±íÉè¼ÆÓ¦¸Ã×¢ÒâµÄÎÊÌâ(×öÁ˵ãÐÞ¸Ä)
¹ØÓÚMySQL±íÉè¼ÆÓ¦¸Ã×¢ÒâµÄÎÊÌâ(×öÁ˵ãÐÞ¸Ä)
¹Ø
ÓÚÉè¼Æ±íʱӦ¸Ã×¢ÒâµÄÎÊÌâ
ÈçÓдíÎó»¶Ó´ó¼ÒÖ¸³ö¡£Õâ
¶Îʱ¼äÔÚ¼ÒÀ×öÁ˵ãÐÞÕý¡£
1
¡¢É÷ÖØÑ¡Ôñ±íÃû¡£
ÓÐ
Á½ÖÖÑ¡Ôñ£º
°´ÕÕ¶àÊý¿ª·¢ÓïÑÔµÄÃüÃû¹æÔò¡£±ÈÈç
£¨myCustomer£©¡£
°´ÕÕ¶àÊý¿ªÔ´Ë¼ÏëÃüÃû¹æ
Ôò¡£±ÈÈ磨my_customer£©¡£
°´ÕÕÔÛÃÇÖйú
È˵Ä˼Ïë¡£±ÈÈ磨ÎҵĿͻ§£©¡£
µÚÒ»ÖÖÓиöȱµã£¬ºÜÈÝ
Ò×Íüµô´óдµÄ×Öĸ¡£
µÚ¶þÖÖÔò±È½ÏºÃ£¬Ã¿¸öWORD¼ä
ÓÃÏ»®ÏßÁ¬½Ó£¬±ÜÃâÒÅÍü¡£
µÚÈýÖÖ½¨Òé²»ÒªÓã¬ËäÈ»ºÜ
ºÃ¼Ç¡£²»¾õµÃ½âÎöÕâ¸ö±íµÄʱºò»¹ÐèÒª±àÂëת»¯Âð£¿ÎÒ¸öÈËÀí½â£¬´ó¼Ò¿ÉÒÔ²¹³ä¡£
2
. ¹ØÓÚ±àÂëµÄÉ趨¡£
A£® GBK/GB2312.
£¨ÊÊÓÃÓÚ´¿ÖÐÎÄ´æ´¢£©¡£
B£® UTF8.
£¨ÊÊÓÃÓÚÖÐÓ¢ÎÄ»ìºÏ´æ´¢£©¡£
C£® LATIN1¡££¨ÊÊ
ÓÃÓÚ´¿Ó¢ÎÄ´æ´¢£©¡£
D. ÆäËûµÄ¡£
3
. ¹ØÓÚ±íÒýÇæµÄÑ¡Ôñ¡£
A. MYISAM.
£¨ºÜ¶àÈË˵ËýµÄ±í¼¶Ëø¶¨»á´øÀ´ºÃ¶àÎÊÌ⣬ÆäʵֻҪÉè¼ÆºÃ¶ÔÓ¦µÄ±íÒÔ¼°Ð´ºÃ¶ÔÓ¦µÄSQL²éѯ¾ÍûÓÐÄÇô´óµÄÎÊÌâ¡££©
B. INNODB. £¨Èç
¹ûÒªÓõ½ÊÂÎñ£¬Ñ¡ÔñËý²»»á´í¡£ÖÁÓÚ¶àÊýÈ˽²µÄMASTER/SLAVE½á¹¹ÉÏÓÃINNODBÔÚMASTERµÄÑ¡ÔñÊÇ·ñÕýÈ·£¬¾ÍÒª¿´ÄãÔõôÓÃÁË¡£²»ÄÜһζµÄ
·è¿ñʹÓÃINNODB¡£³ý·ÇÄãÏëҪȷ±£·Ç³£¸ß¿ÉÓÃÐÔ£¬
£©
C. &
Ïà¹ØÎĵµ£º
mysql 5.0´æ´¢¹ý³Ìѧϰ×ܽá
Ò».´´½¨´æ´¢¹ý³Ì
1.»ù±¾Óï·¨£º
create procedure sp_name()
begin
………
end
2.²ÎÊý´«µÝ
¶þ.µ÷Óô洢¹ý³Ì
1.»ù±¾Óï·¨£ºcall sp_name()
×¢Ò⣺´æ´¢¹ý³ÌÃû³ÆºóÃæ±ØÐë¼ÓÀ¨ºÅ£¬ÄÄŸô洢¹ý³ÌûÓвÎÊý´«µÝ
Èý.ɾ³ý´æ´¢¹ý³Ì
1.»ù±¾Óï·¨£º
drop procedure sp_name// ......
Ê×ÏÈÉèÖÃ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=ÐèÒª¸´ÖƵÄÊý¾Ý¿âÃû£ ......
Ó¦¸Ã˵һ°ãµÄÊý¾Ý¿â¶¼ÓÐBackUpµÄÐèÇó, MySql±¸·ÝÊý¾Ý¿âµÄ·½Ê½ºÜ¼òµ¥, µ«ÊÇÔÚÍøÉÏ˵µÃÔÆÀïÎíÀï, Ò²Ó¦¸ÃÊÇÎÒ¶ÔMySqlÊý¾Ý¿â²»ÊìϤ.
Ä¿±ê(Target) : ½«±¾»úÖеÄmysqlÊý¾Ý¿â±¸·Ýµ½±¾»úÖеÄmydatabaseÊý¾Ý¿âÖÐ - Ò²¾ÍÊÇÍêÈ«µÄCopyÒ»¸öÊý¾Ý¿â.
#1. C:\Program Files\MySQL\MySQL Server 5.0\bin>mysqldump -u ......
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.µ¼³öÒ ......
±ÏÒµÉè¼ÆµÄ³ÌÐòÖ÷Ìå±àºÃÁË£¬ÔËÐÐÉÙÁ¿Êý¾ÝûÓÐÈκÎÎÊÌ⣬һµ©Êý¾ÝÁ¿Ôö¼Óµ½22w£¬ÔËÐÐʱ¼ä¾Í³¤µÃÁîÈË·¢Ö¸¡£µ¼Ê¦½¨Ò飬³ÌÐòÖо¡¿ÉÄܵؼõÉÙÓëÊý¾Ý¿â½»»¥µÄ´ÎÊý£¬¾¡¿ÉÄܵذѹ¤×÷¶ª¸øÊý¾Ý¿âÍê³É¡£ÔÚÕâһ˼ÏëµÄÖ¸µ¼Ï£¬ÎÒÈýÌì´ó·ùÐ޸ijÌÐò£¬²¿·Ö´úÂ뼸ºõÊÇ·ÐÂÁËÒ»±é¡£×ܵÄÀ´Ëµ£¬ÔËÐÐʱ¼äȷʵµÃµ½ÁË ......