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

Éý¼¶mysqlÊý¾Ý¿âµÄ·½·¨

Éý¼¶mysqlÊý¾Ý¿âµÄ·½·¨£º
1.         ÏÂÔØ°²×°½éÖÊmysql-essential-5.1.46-win32.msi
¿ÉÒÔµ½¹ÙÍøhttp://www.mysql.com/click.php?e=35166»òÆäËûÍøÕ¾È¥ÏÂÔØ£»
2.         ±¸·ÝmysqlµÄÊý¾Ý£»
ÔËÐÐcmd´ò¿ªÃüÁîÌáʾ·û£¬½øÈëµ½mysqlÈí¼þµÄbinĿ¼ÏÂͨ¹ýmysqldumpÃüÁî½øÐб¸·Ý£»
C:\mysql\bin>mysqldump -uroot -p -c -Q --add-drop-table --default-character-set=gb2312 ipmngr > D:\db20100525backup.sql
Enter password:£¨ÊäÈëÃÜÂëÒ»°ãÃÜÂëΪ¿ÕÖ±½Ó»Ø³µ¼´¿É£©
Êý¾Ý¿âÖеÄÐÅÏ¢»áµ¼Èëdb20100525backup.sqlÎļþÖУ»
ÔËÐÐservices.msc´ò¿ª·þÎñ´°¿Ú£¬Í£Ö¹µô¾ÉmysqlµÄ·þÎñ¡£ÎªÁË·ÀÖ¹Éý¼¶Êý¾Ý¿âʧ°Ü±ãÓÚ»Ö¸´£¬ÎÒ»¹¶ÔÎļþ¿½±´×öÁ˸öÓ²±¸·Ý±ãÓÚ»Ö¸´£»
¸´ÖÆmysqlÈí¼þµÄĿ¼£¬Õ³Ìùµ½±£´æµÄĿ¼Ï£»
±¸·ÝÍê±Ï£»
3.         Ð¶ÔØ¾ÉµÄmysqlÈí¼þ£¬¶ÀÁ¢mysql°²×°°ü°²×°µÄÔËÐÐappwiz.cplÐ¶ÔØmysqlÈí¼þ£»
¼ò»¯°²×°°ü°²×°µÄÔËÐÐappwiz.cplÐ¶ÔØipaddr managementÈí¼þ£»
ÒªÏë³¹µ×Ð¶ÔØ¸É¾»£¬»¹¸øÉ¾³ý֮ǰmysqlÈí¼þµÄÏà¹ØÄ¿Â¼£»
ÔËÐÐregedit´Ó×¢²á±íÖÐËÑË÷mysqlÏà¹ØµÄ¼Ç¼£¬È·ÈϺóɾ³ý£»
4.         °²×°Ð°æmysql5.1Èí¼þ£»
ͨ¹ýÏòµ¼°²×°mysqlÈí¼þ£»
Ñ¡ÔñCustom×Ô¶¯ÒѰ²×°£»
Ñ¡ÔñÊʵ±µÄĿ¼°²×°È«²¿£»
È·ÈÏÏà¹ØÐÅÏ¢ÎÞÎóºóµã»÷Install½øÐа²×°£»
°²×°ºóͨ¹ýÏòµ¼ÅäÖÃmysql£»
ÏêϸÅäÖã»
Ñ¡ÔñServer Machine£»
Ñ¡ÔñMultifunction Database£»
Ñ¡Ôñ±í¿Õ¼ä´æ·ÅµÄλÖã»
Ñ¡ÔñDecision Support£»
Ñ¡ÔñmysqlʹÓõĶ˿ڣ¬²¢¼Óµ½·À»ðǽµ±ÖУ»
Ñ¡ÔñĬÈϵÄ×Ö·ûgbk£»
Ñ¡Ôñ·þÎñÃû½øÐзþÎñµÄ°²×°£»
ÉèÖùÜÀíÔ±µÄÃÜÂ룻
×îºóÖ´Ðа²×°Íê±Ï£»
5.         »Ö¸´¾ÉÓÐmysqlÊý¾Ý¿âµÄÊý¾Ý£»
Ê×ÏÈͨ¹ý³õʼ°²×°µÄD:\BOCO\ipnms\ipaddmgr\db\ ipmngr.sql
»Ö¸´³õʼÊý¾Ý£»
ÔËÐÐcmd´ò¿ªÃüÁîÌáʾ·û£¬½øÈëµ½mysqlÈí¼þµÄbinĿ¼Ï£¬Ö´ÐÐmysql
D:\BOCO\program\MysqlServer5.1\bin>mysql -uroot -p mysql
Enter password: ******
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 463
Server version: 5.1.46-community MySQL Community Server (GPL)
 
Copyright (c) 2000, 2010, Oracle and/o


Ïà¹ØÎĵµ£º

cmdÃüÁîÌáʾÐÐÁ¬½ÓmysqlÂÒÂëµÄ½â¾ö

1¡¢MySQLÊÇÓÐһЩ»·¾³±äÁ¿¿ÉÒÔÉèÖã¬
¿ÉÊäÈ룺show variables;¿É²é¿´µ±Ç°µÄ»·¾³±äÁ¿ÉèÖã»
2¡¢ÕâЩ±äÁ¿µ±ÖÐÓÐÒ»²¿·ÖÓë×Ö·ûÏà¹ØµÄÉèÖã¬
¿ÉÊäÈ룺show variables like ´character%´;²é¿´£»
3¡¢ÆäÖÐcharacter_set_results¾ö¶¨·µ»Ø½á¹ûµÄ±àÂ룬
windowsÏÂÉèΪgb2312¼´¿ÉÕý³£ÏÔʾÖÐÎÄ£»
ÉèÖ÷½·¨£ºset charac ......

Ò»¸ö mysql server ÉϵÄС¼¼ÇÉ

ת×Ôhttp://www.linuxbyte.org/yi-ge-mysql-server-shang-de-xiao-ji-qiao.html
ÔÚmy.cnf µÄ mysql ¶Ë Ìí¼ÓÈçÏÂÉèÖÃ
[mysql]
#no-auto-rehash # faster start of mysql but no tab completition
prompt="(\u:mysql1@linuxbyte.org \R:\m)[\d]: "
»á²úÉúÈçÏÂЧ¹û:
root@ubuntu:/home/hew# mysql -u hew -p
Enter pass ......

MySQL´æ´¢ÒýÇæ

MySQLÓжàÖÖ´æ´¢ÒýÇæ£º
MyISAM¡¢InnoDB¡¢MERGE¡¢MEMORY(HEAP)¡¢BDB(BerkeleyDB)¡¢EXAMPLE¡¢FEDERATED¡¢ARCHIVE¡¢CSV¡¢BLACKHOLE¡£
MySQLÖ§³ÖÊý¸ö´æ´¢ÒýÇæ×÷Ϊ¶Ô²»Í¬±íµÄÀàÐ͵Ĵ¦ÀíÆ÷¡£MySQL´æ´¢ÒýÇæ°üÀ¨´¦ÀíÊÂÎñ°²È«±íµÄÒýÇæºÍ´¦Àí·ÇÊÂÎñ°²È«±íµÄÒýÇæ£º
¡ô MyISAM¹ÜÀí·ÇÊÂÎñ±í¡£ËüÌṩ¸ßËÙ´æ´¢ºÍ¼ìË÷£¬ÒÔ¼°È«ÎÄËÑË÷ÄÜÁ¦¡ ......

ÕûºÏfreeBSDÏÂnginx+php+mysql°²×°·½°¸£¨ports°²×°£©

  ×î½üÒ»Ö±ÔÚÑо¿freeBSDÏÂnginx+php+mysqlµÄ°²×°£¬¿´Á˺ܶàÍøÉϵÄ×ÊÁÏÊÕ»ñ²»Ð¡£¬²»¹ý´ó²¿·Ö¶¼ÊDZàÒë°²×°£¬Ïà¶Ô³õѧÕßÀ´Ëµ±È½Ï¸´ÔÓ£¬²»ÈÝÒ×Àí½â£¬ËùÒÔÎÒÕûºÏÁËһЩports°²×°µÄ×ÊÁÏ£¬¶¼ÊǾ­¹ý×Ô¼ºÑéÖ¤ºóµÄ£¬°²×°³É¹¦Ò²±È½ÏÈÝÒ×Àí½â£¬ÏÂÃæÊÇÁ½Öֳɹ¦µÄ°¸Àý£¬ÆäÖÐÓÐÒ»¸öÊÇApache´úÌænginxµÄ°²×°£¬Ï£Íû¶Ô´ó¼ÒÓÐËù°ïÖú¡£
° ......

OracleºÍMySQLÊý¾Ý¿âµÄһЩ¼òµ¥ÃüÁî¶Ô±È

ÒÔÏÂΪOracleºÍMySQLÊý¾Ý¿âµÄһЩ¼òµ¥ÃüÁî¶Ô±È£¬¿´¿´ËüÃÇÖ®¼ä´æÔÚÄÄЩ²îÒì
¡¡¡¡SQL> select to_char(sysdate,'yyyy-mm-dd') from dual;
¡¡¡¡SQL> select to_char(sysdate,'hh24-mi-ss') from dual;
¡¡¡¡mysql> select date_format(now(),'%Y-%m-%d');
¡¡¡¡mysql> select time_format(now(),'%H-%i-%S');
¡¡¡¡ÈÕÆÚº ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ