½â¶ÁOracle¼Æ»®£ºSolaris½«±»Õü¾È MySQL¼ÌÐøǰ;δ²·
¡¾51CTO.com¶À¼ÒÌظ塿Ãæ¶Ô¾ª»ÅµÄ¿Í»§ºÍ¹ã·ºÖÊÒɵÄýÌ壬Oracle¹Ù·½×î½üÖÕÓÚ³ö°ñ°²Ãñ£¬ÄDZãÊÇÒ»¸öÒÔ“SUN CUSTOMERS ,Oracle Plans To£º”Ϊ´ó±êÌâµÄ¹ã¸æ¡£Ö±Òë¹ýÀ´±ã¹ýÀ´¿ÉÖªµÀ£¬Oracle½«Òª¼Ó´óSPARCºÍSolarisµÄͶÈëÁË£¬¶ø´óÀÏ°å°£ÀïÉÒ²ÏòIBMÓ²¼þÏÂÁËÕ½Ê飬Éù³ÆOracle½«×îÖÕÓ®µÃÕⳡ¾ºÕù……
ÎÄ/ ÍõÎÄÎÄ
±ÊÕß×ݹÛÕû¸ö¹ã¸æ£¬¾ÓÈ»¶¼Ã»Óз¢ÏÖ¹ØÓÚMySQLµÄ×ÖÑÛ¡£ÇÒ²»¹ÜÔÒòÊÇ×î½üµÄÅ·Ã˵÷²é»¹Êǹ«Ë¾µÄÄÚ²¿²ßÂÔ£¬ÕâÑùµÄ½á¹û¶¼·Ç³£ÁîÈËÒź¶¡£¸Ð¾õ¾ÍºÃÏñÔÚ¿´“¿ìÀÖÅ®Éú”µÄ±ÈÈü£ºÓÐÈ˽ú¼¶£¬ÓÐÈË´ý¶¨……
ËùÒÔÕâ´ÎµÄ“¿ìÀÖ¿ªÔ´”Ð㳡ÀSolarisºÍSPARC½«±»Õü¾È£¬¶øMySQL£¬²»ÐÒ³ÉΪÁË´ý¶¨µÄÄÇÒ»¸ö¡£
²»¹ýÖµµÃ¿Ï¶¨µÄÊÇ£¬OracleÔÚæºõÁË°ëÄêÖ®ºó£¬ÖÕÓÚ×߶ÔÒ»²½ÆåÁË——ÄǾÍÊÇÖØÊÓSolarisÔÚÐÐÒµÄڵĵØλ¡£
À´×ÔºìñµÄ²úÆ·¾ÀíFrank FeldmannÔø½¾°ÁµØ¸æËß¼ÇÕߣ¬×îÖÕµÄÊг¡£¬½«Ö»ÓÐÁ½ÖÖ²Ù×÷ϵͳ£¬ÄǾÍÊÇLinuxºÍWindows¡£
¶Ô´ËÎÒ²»¸Ò¹¶Í¬£¬ÒòΪËû²»µ«Ã»ÓаÑBSD¼Ò×å·ÅÔÚÑÛÀ¸üºöÊÓÁËSolarisÕâ¿îÓÅÐãµÄÆóÒµ¼¶²Ù×÷ϵͳ¡£ÎÒ¿ÉÒÔÀí½âËû¶ÔºìñµÄÈÈ°®ºÍ×ÔºÀ£¬µ«ÊÇÎÒ²»µÃ²»ÌáÐÑËûÒ»¾ä£¬ÏÖÔÚÁ÷ÐеÄFreeBSD¡¢Æ»¹ûMAC¡¢SolarisºÍOpenSolarisÒÔ¼°ºÜ¶àµÄ·ÓÉ¡¢·À»ðǽ²Ù×÷ϵͳ£¬¶¼ÊÇUnix¼Ü¹¹µÄ¡£FreeBSD 7.0¡¢7.1²Å³öÀ´Ã»¶à¾Ã£¬¹Ù·½ÓÖѸËÙÍƳöÁË8.0¡£¶øÆ»¹ûMAC¸Õ·¢²¼µÄ“Ñ©±ª”£¬ÉõÖÁ±»ÈËÈÏΪ±ÈWindows 7»¹ÓÅÐã¡£Ò²ÐíËûÃDz»»áÄÇô´óÖÚ£¬µ«ÊǾø¶Ô²»»áÏûÍö¡£
ËäÈ»Oracle¶ÔLinuxµÄʹÓÃÖ®¶àÖÚËùÖÜÖª£¬µ«ÊÇËûÃÇÔÚ²Ù×÷ϵͳÐÐÒµµÄÃûÉùÒª±ÈËûÃÇÔÚÊý¾Ý¿âÐÐҵҪѷɫµÄ¶à¡£Èç¹ûÕâ´ÎÕæµÄÖؽðͶÈëSolaris£¬ÎÞÂÛÊǼ¼Êõ²ãÃ滹ÊÇÊг¡²ãÃ棬¶¼Ô¶±ÈËûÃÇÔÚÑз¢ºÍÐû´«Linux·½ÃæºÍºìñ¡¢NovellËÀ¿ÄÒªÀ´µÄ»®Ëã¡£
²»¹ý°£ÀïÉÒª“Spend more money”µÄ»°ËäÈ»·ÅÔÚÁËÕâÀµ«¾ßÌåSolaris»áÊÇÔõôһ¸ö×ßÏò£¬ÎÒÃÇ»¹µÃÆï¿¿´³ª——×ß×ÅÇÆ¡£ÔÙÔõô˵£¬°£ÀïÉËûÀÏÈ˼ÒÒÔǰûÔõô×ö¹ý¿ªÔ´²úÆ·²»ÊÇ£¿
ÓÐʱºò£¬¹ÛÄî±ÈǮҪÀ´µÄÖØÒª¡£
http://sysapp.51cto.com/art/200909/151313.htm
½â¶ÁOracle¼Æ»®£ºSolaris½«±»Õü¾È MySQL¼ÌÐøǰ;δ²·
¡¾51CTO.com¶À¼ÒÌظ壬תÔØÇë×¢Ã÷×÷ÕßÐÕÃûºÍ³ö´¦¡¿
Ïà¹ØÎĵµ£º
±¸·ÝMySQLÊý¾Ý¿âµÄÃüÁî
mysqldump -hhostname -uusername -ppassword databasename > backupfile.sql
±¸·ÝMySQLÊý¾Ý¿âΪ´øɾ³ý±íµÄ¸ñʽ
±¸·ÝMySQLÊý¾Ý¿âΪ´øɾ³ý±íµÄ¸ñʽ£¬Äܹ»Èøñ¸·Ý¸²¸ÇÒÑÓÐÊý¾Ý¿â¶ø²»ÐèÒªÊÖ¶¯É¾³ýÔÓÐÊý¾Ý¿â¡£
mysqldump -–add-drop-table -uusername -ppassword databasename > bac ......
±¾ÎÄÌÖÂÛ MySQL µÄ±¸·ÝºÍ»Ö¸´»úÖÆ£¬ÒÔ¼°ÈçºÎά»¤Êý¾Ý±í£¬°üÀ¨×îÖ÷ÒªµÄÁ½ÖÖ±íÀàÐÍ£ºMyISAM ºÍ Innodb£¬ÎÄÖÐÉè¼ÆµÄ MySQL °æ±¾Îª 5.0.22¡£
Ä¿Ç° MySQL Ö§³ÖµÄÃâ·Ñ±¸·Ý¹¤¾ßÓУºmysqldump¡¢mysqlhotcopy£¬»¹¿ÉÒÔÓà SQL Óï·¨½øÐб¸·Ý£ºBACKUP TABLE »òÕß SELECT INTO OUTFILE£¬ÓÖ»òÕß±¸·Ý¶þ½øÖÆÈÕÖ¾£¨binlog£©£¬»¹¿ÉÒÔÊÇÖ±½Ó¿½± ......
CREATE TABLE `taa` (
`year` varchar(4) DEFAULT NULL,
`month` varchar(2) DEFAULT NULL,
`amount` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf
"year","m ......
£©MySql ÖÐÎÄÍø£ºhttp://imysql.cn/onlinedoc
£©MySQL ÖÐÎÄÉçÇø £ºhttp://www.mysql.net.cn/
£©MySql °Ù¶È°Ù¿Æ£ºhttp://baike.baidu.com/view/24816.htm
²Î¿¼×ÊÁÏ£º
MySql°æ±¾¹¹¼Ü¼°Ë÷ÒýÎļþ½éÉÜ
Linux·þÎñÆ÷ÅäÖ÷½°¸MySQL
WinodwsÏÂIIS/Apache PHP MySQLµÄ°²×°ÅäÖÃ
³õѧMySQLÄÄЩÐèÒªÄãÖªµÀ& ......
access denied for user 'root'@'localhost' (using password: YES);
½ñÌìÓÃmysqlµÄʱºò£¬µÇ¼µÄʱºò³öÏÖÁËÕâ¾ä£¬²»ÖªµÀÊÇʲôÒâ˼£¬ÒòΪÎÒµÄmysqlÊÇ×°centosµÄʱºòÒ»Æð×°µÄ£¬ÃÜÂëÎÒ¾ÍÊäÈëÎÒµÄÕÊ»§ÃÜÂ룬½á¹û³öÏÖÁËÉÏÃæÄǾ䣻°Ù¶ÈÁËһϣ¬»¹Õæ²»ÉÙÈ˳öÏÖÁËÕâ¸öÎÊÌâ¡£¡£×îºóÎÒÕÒµ½ÁË·½·¨£»
[root@localhost home]# mysql - ......