½â¶Á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 ......
1. ÔÚ/etc/my.cnfÖмÓÈëÒ»ÏÂÄÚÈÝ
[mysqld_dev]
socket=/tmp/mysql.sock
port=3307
pid-file=/var/run/mysqld/mysqld_dev.pid
datadir=/var/lib/mysql_dev
log=/var/log/mysqld_dev.log
log-error=/var/log/mysqld_dev.err.log
user=mysql
2. ¸ù¾ÝÒÔÉÏÄÚÈÝ´´½¨Ä¿Â¼ºÍÎļþ
mkdir /var/lib/mysqld_dev
chown mys ......
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µÄÓα꾿¾¹ÔõôÓÖӳÈպɻ¨±ðÑùºì
Mysql´Ó5.0¿ªÊ¼Ö§³Ö´æ´¢¹ý³ÌºÍtrigger£¬¸øÎÒÃÇϲ»¶ÓÃmysqlµÄÅóÓÑÃǸüϲ»¶mysqlµÄÀíÓÉÁË£¬Óï·¨
ÉϺÍPL/SQLÓвî±ð£¬²»¹ý¸ã¹ý±à³ÌµÄÈ˶¼ÖªµÀ£¬Óï·¨²»ÊÇÎÊÌ⣬¹Ø¼üÊÇ˼Ï룬´óÖÂÁ˽âÓï·¨ºó£¬¾Í´Ó
±äÁ¿¶¨Ò壬ѻ·£¬Åжϣ¬Óα꣬Òì³£´¦ÀíÕâ¸ö¼¸¸ö·½ÃæÏêϸѧϰÁË¡£¹ØÓÚÓαêµÄÓ÷¨M ......
¼¸¸öÔÂÇ°£¬ÊÜһλÀÏʦµÄίÍУ¬Òª°ïËû×öÒ»¸ö¹ØϵÊý¾Ý¿âģʽÐÅÏ¢ÌáÈ¡µÄСÏîÄ¿£¬Ö÷ÒªµÄ¹¦ÄÜʵÏÖ¾ÍÊǽ«¹ØϵÊý¾Ý¿âµÄ±í½á¹¹ºÍ×ֶεÄÐÅϢͨ¹ý±í¸ñµÄÐÎʽչʾ³öÀ´¡£ÎÒͨ¹ý´ÓÍøÉÏËѼ¯×ÊÁÏÒÔ¼°·Êé²éÕÒ£¬ÏÈʵÏÖÁËÒ»¸ömysqlµÄÊý¾ÝÌáÈ¡Æ÷¡£Ïȸø´ó¼Ò·ÖÏíһϡ£ÉÔºóµÄ¼¸ÌìÄÚ»á°ÑÁíÒ»¸ömysql¹ ......