[B! mysql] otomã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

otom id:otom

mysqlã«é–¢ã™ã‚‹otomã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (19)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

Rails ã§ã€Controller ã«å®šç¾©ã•ã‚Œã¦ã„ã‚‹ action ã‚’ä¸€åº¦ã«å–å¾—ã™ã‚‹æ–¹æ³•ã¯ã‚ã‚Šã¾ã™ã‹ï¼Ÿ - QA@IT
å¹³ç´ ã‚ˆã‚ŠQAï¼ ITã‚’ã”åˆ©ç”¨ã„ãŸã ãã€èª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ QAï¼ ITã¯ã€Œè³ªå•ã‚„å›žç”ã‚’ã€Žå…±æœ‰ã€ã—ã€Žç·¨é›†ã€ã—ã¦ã„ãã“ã¨ã§ãƒ™ã‚¹ãƒˆãªQAã‚’è“„ç©ã§ãã‚‹ã€IT ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ãŸã‚ã®å•é¡Œè§£æ±ºã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒ¼ã€ã¨ã—ã¦ç´„7å¹´é–“é‹å–¶ã‚’ã—ã¦ãã¾ã—ãŸã€‚ã“ã‚Œã¾ã§ã‚µãƒ¼ãƒ“ã‚¹ã‚’ç¶šã‘ã‚‹ã“ã¨ãŒã§ããŸã®ã¯ã€QAï¼ ITã®ã‚³ãƒ³ã‚»ãƒ—ãƒˆã«å…±æ„Ÿã‚’ã„ãŸã ãã€é©åˆ‡ãªè³ªå•ã‚„å›žç”ã‚’ãŠå¯„ã›ã„ãŸã ã„ãŸçš†ã•ã¾ã®ã”æ”¯æ´ãŒã‚ã£ãŸã‹ã‚‰ã“ãã¨è€ƒãˆã¦ãŠã‚Šã¾ã™ã€‚é‡ãã¦å¾¡ç¤¼ç”³ã—ä¸Šã’ã¾ã™ã€‚ ã—ã‹ã—ãªãŒã‚‰ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®æƒ…å ±å…¥æ‰‹æ–¹æ³•ã®å¤šæ§˜åŒ–ã‚„QAã‚µãƒ¼ãƒ“ã‚¹å¸‚å ´ã®çŠ¶æ³ã€ï¼ ITã®ä»Šå¾Œã®ãƒ¡ãƒ‡ã‚£ã‚¢é‹å–¶æ–¹é‡ãªã©ã‚’æ¤œè¨Žã—ãŸçµæžœã€2020å¹´2æœˆ28æ—¥ï¼ˆé‡‘ï¼‰15:00ã‚’ã‚‚ã¡ã¾ã—ã¦QAï¼ ITã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã™ã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã€‚ ã“ã‚Œã¾ã§ã”åˆ©ç”¨ã‚’ã„ãŸã ãã¾ã—ãŸçš†ã•ã¾ã«ã¯æ®‹å¿µãªãŠçŸ¥ã‚‰ã›ã¨ãªã‚Šã€èª ã«å¿ƒè‹¦ã—ãæ€ã£ã¦ãŠã‚Šã¾ã™ã€‚ä½•ã¨ãžã€ã”ç†è§£ã‚’ã„ãŸã ã‘ã¾ã™ã¨å¹¸ã„ã§ã™ã€‚ QAï¼ ITã®7å¹´é–“ã§çš†ã•ã¾ã®çŸ¥è˜
otom 2012/09/12
PostgreSQL

MySQL
ãƒªãƒ³ã‚¯
GitHub - livedoor/cicindela2: a highly customizable recommendation engine written in perl + MySQL
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session. Dismiss alert
otom 2009/06/08
livedoor

ãƒ¬ã‚³ãƒ¡ãƒ³ãƒ‡ãƒ¼ã‚·ãƒ§ãƒ³

perl

mysql
ãƒªãƒ³ã‚¯
MySQLã®EXPLAINã‚’å¾¹åº•è§£èª¬!!
ä»¥å‰ã€MySQLã‚’é«˜é€ŸåŒ–ã™ã‚‹10ã®æ–¹æ³•ã¨ã„ã†æŠ•ç¨¿ã§ã€ŒEXPLAINã®è¦‹æ–¹ã«ã¤ã„ã¦ã¯ã„ãšã‚Œè§£èª¬ã—ã‚ˆã†ã¨æ€ã†ã€ã¨æ›¸ã„ã¦ã—ã¾ã£ãŸã®ã§ã€ä»Šæ—¥ã¯ãã®å…¬ç´„ï¼Ÿã‚’æžœãŸãã†ã¨æ€ã†ã€‚ MySQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã§æœ€ã‚‚å¤§åˆ‡ãªã®ã¯ã€ã‚¯ã‚¨ãƒªã¨ã‚¹ã‚ãƒ¼ãƒžã®æœ€é©åŒ–ã§ã‚ã‚‹ã€‚ã‚¹ã‚ãƒ¼ãƒžã®è¨è¨ˆã¯ä¸€åº¦æ±ºã‚ã¦ã—ã¾ã†ã¨ãã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’åˆ©ç”¨ã™ã‚‹å…¨ã¦ã®ã‚¯ã‚¨ãƒªã«å½±éŸ¿ã—ã¦ã—ã¾ã†ãŸã‚ãªã‹ãªã‹å¤‰æ›´ã™ã‚‹ã“ã¨ã¯å‡ºæ¥ãªã„ãŒã€ã‚¯ã‚¨ãƒªã¯ãã®ã‚¯ã‚¨ãƒªã ã‘ã‚’æ›¸ãç›´ã›ã°è‰¯ã„ã®ã§å¤‰æ›´ã®æ•·å±…ã¯ä½Žã„ã€‚ãã—ã¦é…ã„ã‚¯ã‚¨ãƒªã‚’ãªãã™ã“ã¨ã¯ã€æ€§èƒ½ã‚’å¤§å¹…ã«å‘ä¸Šã•ã›ã‚‹ãŸã‚ã®æœ€ã‚‚æœ‰åŠ¹ãªæ‰‹æ®µã§ã‚ã‚‹ã€‚å¾“ã£ã¦ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®æ€§èƒ½ã‚’å‘ä¸Šã•ã›ãŸã„ãªã‚‰ã€ã¾ãšæœ€åˆã«ã‚¯ã‚¨ãƒªã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’æ¤œè¨Žã™ã‚‹ã¹ããªã®ã§ã‚ã‚‹ã€‚ æœ€é©åŒ–ã™ã‚‹ã¹ãã‚¯ã‚¨ãƒªã¯ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªãƒã‚°ã‚„ã‚¯ã‚¨ãƒªã‚¢ãƒŠãƒ©ã‚¤ã‚¶ã§è¦‹ä»˜ã‘ã‚‰ã‚Œã‚‹ãŒã€ã§ã¯ãã®ã‚ˆã†ãªã‚¯ã‚¨ãƒªãŒè¦‹ã¤ã‹ã£ãŸå ´åˆã«ã¯ã©ã®ã‚ˆã†ã«æœ€é©åŒ–ã™ã‚Œã°ã„ã„ã®ã‹ï¼Ÿãã®ãŸã‚ã«ã¯ã¾ãšç¾åœ¨ã©ã®ã‚ˆã†ã«ã‚¯ã‚¨ãƒªãŒå®Ÿè¡Œã•
otom 2009/03/31
mysql

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
ã€ãƒ¬ãƒãƒ¼ãƒˆã€‘Facebookã®ãƒ‡ãƒ¼ã‚¿ã‚»ãƒ³ã‚¿ãƒ¼ã«è¦‹ã‚‹MySQLæ´»ç”¨äº‹ä¾‹ - MySQLã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ (1) ç†±æ°—ã«æº€ã¡ãŸ4æ—¥é–“ - MySQL Conference and Expo | ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚º | ãƒžã‚¤ã‚³ãƒŸã‚¸ãƒ£ãƒ¼ãƒŠãƒ«
4æœˆ14æ—¥ã‹ã‚‰17æ—¥ã¾ã§ã®4æ—¥é–“ã€ç±³ã‚«ãƒªãƒ•ã‚©ãƒ«ãƒ‹ã‚¢å·žã‚µãƒ³ã‚¿ã‚¯ãƒ©ãƒ©ã«ãŠã„ã¦ã€MySQL Conference and Expo(ä»¥ä¸‹ã€MySQLã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹)ãŒé–‹å‚¬ã•ã‚ŒãŸã€‚MySQLé–¢é€£ã®æœ€å¤§ã®ã‚¤ãƒ™ãƒ³ãƒˆã§ã‚ã‚‹ã€‚ã‚»ãƒƒã‚·ãƒ§ãƒ³ã¯æœ‰æ–™ã§ã€æ—¥æœ¬å††ã§10ä¸‡å††ã‚’è¶…ãˆã‚‹é‡‘é¡ã«ã‚‚ã‹ã‹ã‚ã‚‰ãšã€å‚åŠ ç™»éŒ²è€…æ•°ã¯2,000äººè¿‘ãã«é”ã—â€»ã€æ—¥æœ¬ã‹ã‚‰ã‚‚å¤šãã®ãƒ¦ãƒ¼ã‚¶ãƒ¼ãŒå‚åŠ ã—ã¦ã„ãŸã€‚ â€» ã‚»ãƒƒã‚·ãƒ§ãƒ³å‚åŠ ã®ã§ããªã„ã€å±•ç¤ºä¼šå ´ã®ã¿ã®ç”³ã—è¾¼ã¿è€…ã‚‚å«ã‚€ã€‚ ä»Šå›žã®MySQLã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã§ã¯ã€è¤‡æ•°ãƒ‡ãƒ¼ã‚¿ã‚»ãƒ³ã‚¿ãƒ¼ã«ã¾ãŸãŒã£ã¦MySQLã‚’æ´»ç”¨ã™ã‚‹ã‚ˆã†ãªå¤§è¦æ¨¡äº‹ä¾‹ã€ãƒšã‚¿ãƒã‚¤ãƒˆç´šã®è¦æ¨¡ã«æŒ‘æˆ¦ã™ã‚‹äº‹ä¾‹ã€MySQL Clusterã®äº‹ä¾‹ã€Heartbeat + DRBDã«ã‚ˆã‚‹é«˜å¯ç”¨æ€§ã®äº‹ä¾‹ãªã©ã€ã•ã¾ã–ã¾ãªäº‹ä¾‹ãŒç™ºè¡¨ã•ã‚ŒãŸã€‚ã¨ãã«Facebookã¯ã€1ä¸‡å°ã®Webã‚µãƒ¼ãƒã€800å°ã®ã‚ãƒ£ãƒƒã‚·ãƒ¥ã‚µãƒ¼ãƒ(memcached)ã€ãã—ã¦1,800å°ã®My
otom 2008/04/29
mysql

facebook
ãƒªãƒ³ã‚¯
ã€ãƒã‚¦ãƒ„ãƒ¼ã€‘è©±é¡Œã®é«˜æ©Ÿèƒ½CMSã€ŒMODxã€ ã‚’è©¦ã™! - å°Žå…¥ã‹ã‚‰ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆä½œæˆã¾ã§ (1) PHPï¼‹MySQLã®é«˜æ©Ÿèƒ½CMSã€ŒMODxã€ã¨ã¯? | ãƒãƒƒãƒˆ | ãƒžã‚¤ã‚³ãƒŸã‚¸ãƒ£ãƒ¼ãƒŠãƒ«
æ³¨ç›®ã®CMSã€ŒMODxã€ã¨ã¯? ã€ŒMODxã€ã¯PHPã§å®Ÿè£…ã•ã‚Œã¦ã„ã‚‹Webãƒ™ãƒ¼ã‚¹ã‚µã‚¤ãƒˆã‚’ç®¡ç†ã™ã‚‹ã“ã¨ãŒã§ãã‚‹CMS (Content Management System)ã§ã™ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«MySQLã‚’åˆ©ç”¨ã—ã¦ã„ã‚‹ãŸã‚ã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ç³»ã®Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ç’°å¢ƒã§æ¨™æº–çš„ãªLAMPã§æ§‹æˆã™ã‚‹ã“ã¨ãŒã§ãã€å›½å†…ã§ã‚‚ã“ã“æœ€è¿‘ã«ãªã£ã¦çŸ¥ååº¦ã‚’é«˜ã‚ã¦ã„ã¾ã™ã€‚ ä»–ã®å¤šãã®CMSã¨åŒæ§˜ã«ã€Webã‚µã‚¤ãƒˆã®ç®¡ç†è€…å°‚ç”¨ã®ãƒšãƒ¼ã‚¸ãŒç”¨æ„ã•ã‚Œã¦ãŠã‚Šã€ç®¡ç†è€…ã¯ç®¡ç†ãƒšãƒ¼ã‚¸ã‚’é€šã—ã¦ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã‚„ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®ç®¡ç†ã‚’è¡Œã†ã“ã¨ãŒã§ãã¾ã™ã€‚åŠ ãˆã¦MODxã®ç®¡ç†ç”»é¢ã¯Ajaxã‚’ç”¨ã„ã¦ã„ã‚‹ãŸã‚ãƒšãƒ¼ã‚¸é·ç§»ã‚’ç™ºç”Ÿã•ã›ãšã«ç”»é¢ç§»å‹•ã§ãã€å¿«é©ãªæ“ä½œæ€§ã‚’å®Ÿç¾ã—ã¦ã„ã¾ã™ã€‚ MODxã‚’ç”¨ã„ã‚‹ã“ã¨ã§ã€ç”¨æ„ã•ã‚Œã¦ã„ã‚‹ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆã‚„ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã§Webã‚µã‚¤ãƒˆã‚’æ§‹ç¯‰ã™ã‚‹ã“ã¨ãŒã§ãã€å¿…è¦ã§ã‚ã‚Œã°PHPã‚’æ›¸ã„ã¦ç‹¬è‡ªã®Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚„ã‚µãƒ¼ãƒ“ã‚¹ã‚’æ§‹ç¯‰ã™ã‚‹ã“ã¨ã‚‚
otom 2007/10/30
php

mysql

cms
ãƒªãƒ³ã‚¯
æœ€çŸã‹ã¤æœ€é€Ÿã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã€ŒDBé«˜é€ŸåŒ–æŠ€è¡“ã€ï¼ˆå‰ç·¨ï¼‰ï¼šITpro
ãƒã‚¤ãƒ³ãƒˆ ãƒ»é«˜åº¦ãªã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚„ã‚¸ãƒ§ã‚¤ãƒ³ã‚’åˆ©ç”¨ã—ï¼Œæœ€çŸçµŒè·¯ã§ãƒ‡ãƒ¼ã‚¿ã«ã‚¢ã‚¯ã‚»ã‚¹ ãƒ»ãƒ¡ãƒ¢ãƒªãƒ¼ä¸è¶³ã‚’è‡ªå¾‹çš„ã«è§£æ¶ˆã—ï¼Œã‚ãƒ£ãƒƒã‚·ãƒ¥ã®ãƒ’ãƒƒãƒˆçŽ‡ã‚’é«˜ã‚ã‚‹ ãƒ»ã‚¤ãƒ³ãƒ¡ãƒ¢ãƒªãƒ¼DBã¯å…¨ãƒ‡ãƒ¼ã‚¿ã‚’ãƒ¡ãƒ¢ãƒªãƒ¼ã§å‡¦ç†ã—ï¼Œé«˜é€ŸåŒ–ã‚’å›³ã‚‹ ç›®çš„åœ°ã«æ—©ãåˆ°ç€ã—ãŸã„ãªã‚‰ï¼Œæœ€çŸã®çµŒè·¯ã‚’æœ€é€Ÿã§è¡Œã‘ã°ã‚ˆã„ã€‚ã“ã‚Œã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼ˆDBï¼‰ã§ã‚‚åŒæ§˜ã ï¼ˆå›³1ï¼‰ã€‚ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãªã©ã‚’ä½¿ã£ã¦ãƒ‡ãƒ¼ã‚¿ã¸ã®æœ€çŸçµŒè·¯ã‚’è¦‹ã¤ã‘ï¼Œãƒ¡ãƒ¢ãƒªãƒ¼ãƒ»ã‚¢ã‚¯ã‚»ã‚¹ã‚’å¢—ã‚„ã—ã¦ï¼Œæœ€é€Ÿã§ãŸã©ã‚Šç€ãã€‚DBã«ã¯ãã‚“ãªæŠ€è¡“ãŒè©°ã¾ã£ã¦ã„ã‚‹ã€‚ å›³1â—ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é«˜é€ŸåŒ–æŠ€è¡“ã®ãƒã‚¤ãƒ³ãƒˆ ãƒ“ãƒƒãƒˆãƒžãƒƒãƒ—ãƒ»ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãªã©ã‚’ä½¿ã„ã€ãƒ‡ãƒ¼ã‚¿ã«ãŸã©ã‚Šç€ãæœ€çŸã®é“ã‚’é¸ã¶ã€‚ã¾ãŸã€ã§ãã‚‹ã ã‘ãƒ¡ãƒ¢ãƒªãƒ¼ã«ãƒ‡ãƒ¼ã‚¿ã‚’ã‚ãƒ£ãƒƒã‚·ãƒ¥ã•ã›ã¦ãŠãã“ã¨ã§ã€ã‚¢ã‚¯ã‚»ã‚¹ã®ã‚¹ãƒ”ãƒ¼ãƒ‰ã‚’ä¸Šã’ã‚‹ã€ã¨ã„ã†äºŒã¤ã®ãƒã‚¤ãƒ³ãƒˆãŒã‚ã‚‹ [ç”»åƒã®ã‚¯ãƒªãƒƒã‚¯ã§æ‹¡å¤§è¡¨ç¤º] ä»¥ä¸‹ã§ã¯ï¼Œï¼ˆ1ï¼‰ãƒ‡ãƒ¼ã‚¿ã«ãŸã©ã‚Šç€ãæœ€çŸã®é“ã‚’é¸ã¶ä»•çµ„ã¿ã¨ï¼Œï¼ˆ2ï¼‰ã‚¢ã‚¯ã‚»ã‚¹ã®ã‚¹ãƒ”ãƒ¼ãƒ‰ã‚’ä¸Šã’ã‚‹ä»•çµ„ã¿ã®
otom 2007/09/12
mysql
ãƒªãƒ³ã‚¯
mixiã®ç”Ÿã¿ã®è¦ªâ€œãƒã‚¿ãƒ©æ°â€ãŒèªžã‚‹MySQLã®æ„å¤–ãªåˆ©ç”¨æ³• ï¼ TechTargetã‚¸ãƒ£ãƒ‘ãƒ³
æ—¥è¨˜ã ã‘ã§4å„„ä»¶ã®ãƒ‡ãƒ¼ã‚¿ ãƒŸã‚¯ã‚·ã‚£ãŒé‹å–¶ã™ã‚‹SNSã€Œmixiã€ã¯ã€2007å¹´7æœˆæœ«æ®µéšŽã§ãƒ¦ãƒ¼ã‚¶ãƒ¼æ•°ãŒ1110ä¸‡äººã€‚äººãŒ12äººé›†ã¾ã‚Œã°ã€1äººã¯mixiãƒ¦ãƒ¼ã‚¶ãƒ¼ã¨ã„ã†ã‚ã‘ã ã€‚ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®ã‚¢ã‚¯ãƒ†ã‚£ãƒ–çŽ‡ï¼ˆãƒã‚°ã‚¤ãƒ³é–“éš”ãŒ3æ—¥ä»¥å†…ï¼‰ã¯ç´„62ï¼…ã¨é«˜ãã€2007å¹´4æœˆã‹ã‚‰6æœˆã®æœˆé–“å¹³å‡ãƒšãƒ¼ã‚¸ãƒ“ãƒ¥ãƒ¼ã¯117.5å„„ã«é”ã—ãŸã€‚æ—¥è¨˜ã ã‘ã§ã‚‚4å„„ä»¶ä»¥ä¸Šã«ä¸Šã‚‹ãªã©ã€è“„ç©ã™ã‚‹ãƒ‡ãƒ¼ã‚¿é‡ã‚‚èŽ«å¤§ã€‚2004å¹´3æœˆã®ã‚µãƒ¼ãƒ“ã‚¹é–‹å§‹ã‹ã‚‰ã€ã‚ãšã‹3å¹´åŠã§ç¾åœ¨ã®å·¨å¤§ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒ¼ã¸ã¨ç™ºå±•ã—ãŸã®ã ã€‚ ãƒŸã‚¯ã‚·ã‚£ã¯ã€ã€ŒLAMPï¼ˆOSã®Linuxã€Webã‚µãƒ¼ãƒã®Apacheã€DBMSã®MySQLã€é–‹ç™ºè¨€èªžã®Perlã€PHPã€Pythonï¼‰ã€ã¨å‘¼ã°ã‚Œã‚‹Webã‚·ã‚¹ãƒ†ãƒ å‘ã‘ã®æ¨™æº–çš„ãªã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ï¼ˆä»¥ä¸‹ã€OSSï¼‰ã§ã‚·ã‚¹ãƒ†ãƒ ã‚’è‡ªç¤¾é–‹ç™ºã—ã€å®‰ä¾¡ãªPCã‚µãƒ¼ãƒã‚’1000å°ä»¥ä¸Šé€£ãã‚‹è¶…åˆ†æ•£æ§‹æˆã§mixiã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’æ”¯ãˆã¦ã„ã‚‹ï¼ˆåºƒå‘Šé…ä¿¡ãªã©å‘¨è¾ºæ©Ÿèƒ½ã§ã¯
otom 2007/09/12
mysql

mixi
ãƒªãƒ³ã‚¯
ã‚¦ãƒŽã‚¦ãƒ©ãƒœ Unoh Labs: MySQL ã‚ªãƒšãƒŸã‚¹ã§ãƒ‡ãƒ¼ã‚¿ãŒç ´æã—ã¦ã—ã¾ã£ãŸå ´åˆã®å¾©æ—§æ–¹æ³•
ã“ã‚“ã«ã¡ã¯ satoã§ã™ã€‚ ã‚ªãƒšãƒŸã‚¹ã§ update ã« whereå¥ã‚’ä»˜ã‘å¿˜ã‚ŒãŸã‚Šã€ãƒ—ãƒã‚°ãƒ©ãƒ ã®ãƒã‚°ã§ãƒ‡ãƒ¼ã‚¿ãŒç ´æã—ã¦ã—ã¾ã£ãŸã‚Šã—ãŸå ´åˆã§ã‚‚ã€ãƒã‚¤ãƒŠãƒªãƒã‚°ã«ã¯æ›´æ–°SQLãŒã™ã¹ã¦æ›¸ãè¾¼ã¾ã‚Œã‚‹ã®ã§ã€ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ã‚¿ã‹ã‚‰ã‚ªãƒšãƒŸã‚¹ãŒèµ·ã“ã‚‹ã¾ã§ã®å…¨ã¦ã®SQLã‚’æµã—è¾¼ã‚ã‚Œã°ã€å…ƒã®çŠ¶æ…‹ã«æˆ»ã™ã“ã¨ã¯å¯èƒ½ã§ã™ã€‚ â€¢ãƒã‚¤ãƒŠãƒªãƒã‚°ã‚’å–ã£ã¦ã„ã‚‹ â€¢ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’ã¨ã£ã¦ã„ã‚‹(mysqldumpã‚„MySQLã‚’æ¢ã‚ãŸçŠ¶æ…‹ã§ã®cpã«ã‚ˆã‚‹ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¨ãƒã‚¤ãƒŠãƒªãƒã‚°) â€¢ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—æ™‚ç‚¹ã§ã®ãƒã‚¤ãƒŠãƒªãƒã‚°ã®æ›¸ãè¾¼ã¿ä½ç½®ã‚’ä¿å˜ã—ã¦ã„ã‚‹ ä»¥ä¸Šã®ã‚ˆã†ãªçŠ¶æ…‹ã§ãƒ‡ãƒ¼ã‚¿ãŒå£Šã‚ŒãŸæ™‚ã®å¾©æ—§æ‰‹é †ã‚’ã¾ã¨ã‚ã¦ã¿ã¾ã—ãŸã€‚ã‚·ãƒŠãƒªã‚ªã¨ã—ã¦ â€¢ã‚ã‚‹1ã‚«ãƒ©ãƒ em ail ã‚’updateã—ã‚ˆã†ã¨ã—ãŸã‚‰ã€é–“é•ã£ã¦where å¥ã‚’ä»˜ã‘å¿˜ã‚Œ å…¨ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’updateã—ã¦ã—ã¾ã£ãŸ â€¢æ°—ãŒã¤ã„ãŸã®ãŒåŠæ—¥å¾Œ ã¨ã„ã†ã‚ªãƒšãƒŸã‚¹ãŒç™ºç”Ÿã—ãŸã¨ã—ã¾ã™ 1) ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼
otom 2007/08/22
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

mysql

å¾©æ—§
ãƒªãƒ³ã‚¯
http://yamipro.ameblo.jp/entry-3872463068e49e3f9e00f7198926c6dd.html
otom 2007/08/06
mysql
ãƒªãƒ³ã‚¯
MySQLãƒŽã‚¦ãƒã‚¦
ã„ã‚ã„ã‚ãªæœ¬ã‹ã‚‰ãƒ¡ãƒ¢ã£ã¦ããŸãƒ¡ãƒ¢ã®ãƒ¡ãƒ¢ã€‚å‡ºå…¸ã‚’æ›¸ã„ã¦ãŠãã®ã‚’å¿˜ã‚ŒãŸã€‚æ€ã„å‡ºã—æ¬¡ç¬¬è£œå®Œã™ã‚‹ã‹ã‚‚ã€‚ deleteã®ã‚³ã‚¹ãƒˆã¯é«˜ã„ã®ã§ã€ç„¡åŠ¹åŒ–ã‚’ç¤ºã™ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã‚’ä½œã£ã¦updateã™ã¹ã slow query logã«è¦æ³¨æ„ å¤šãã®ã‚¨ãƒ³ãƒˆãƒªã§ã»ã¨ã‚“ã©ã®ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ãŒåŒã˜å€¤ã‚’æŒã¤å ´åˆã¯ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åŠ¹æžœãŒå°ã•ã„ â†’è¤‡åˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åŠ¹æžœãŒå¤§ãã„ è¤‡åˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯æŒ‡å®šã®é †ç•ªãŒå¤§åˆ‡ã€‚Aã¨Bã¨ã„ã†æŒ‡å®šã®å ´åˆã€Aå˜ç‹¬ã§ã‚‚ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åŠ¹æžœãŒã‚ã‚‹ã€‚é€†ã¯çœŸã§ãªã„ã€‚ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒä½¿ã‚ã‚Œã‚‹å ´é¢ã¯ ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰å€¤ã‚’å®šæ•°ã¨æ¯”è¼ƒã™ã‚‹ã¨ã (where name = 'hogehoge') ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰å€¤ã§JOINã™ã‚‹ã¨ã (where a.name = b.name) ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰å€¤ã®ç¯„å›²ã‚’æ±‚ã‚ã‚‹ã¨ã (<,>,between) LIKEå¥ãŒæ–‡å—åˆ—ã‹ã‚‰å§‹ã¾ã‚‹ã¨ã (where name like 'hoge%') min(),
otom 2007/07/12
mysql

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹
ãƒªãƒ³ã‚¯
MySQL :: MySQL 5.6 ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ« :: 8.11.2 ã‚µãƒ¼ãƒãƒ¼ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
æ¬¡ã®ã‚³ãƒžãƒ³ãƒ‰ã‚’ä½¿ç”¨ã—ã¦ã€mysqld ã‚µãƒ¼ãƒãƒ¼ã§ä½¿ç”¨ã•ã‚Œã‚‹ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®ãƒãƒƒãƒ•ã‚¡ãƒ¼ã‚µã‚¤ã‚ºã‚’åˆ¤æ–ã§ãã¾ã™ã€‚ shell> mysqld --verbose --help ã“ã®ã‚³ãƒžãƒ³ãƒ‰ã«ã‚ˆã£ã¦ã€ã™ã¹ã¦ã® mysqld ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã¨æ§‹æˆå¯èƒ½ãªã‚·ã‚¹ãƒ†ãƒ å¤‰æ•°ã®ãƒªã‚¹ãƒˆãŒç”Ÿæˆã•ã‚Œã¾ã™ã€‚ã“ã®å‡ºåŠ›ã«ã¯ã€ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®å¤‰æ•°å€¤ã‚‚å«ã¾ã‚Œã€æ¬¡ã®ã‚ˆã†ã«è¦‹ãˆã¾ã™ã€‚ abort-slave-event-count 0 allow-suspicious-udfs FALSE archive ON auto-increment-increment 1 auto-increment-offset 1 autocommit TRUE automatic-sp-privileges TRUE back-log 80 basedir /home/jon/bin/mysql-5.6/ big-tables FALSE bind-addre
otom 2006/12/18
ãƒ¡ãƒ¢ãƒ¡ãƒ¢

mysql

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
[MySQL]ãƒ¡ãƒ¢ãƒªè¨å®šã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°: ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢é–‹ç™ºæŠ€è¡“è€…ã¨ã—ã¦é€ããŸã‹ã£ãŸã§ã™ã€€ï¼ˆï½ƒï¼‰ã¦ã‚‹ã¨ã¿
ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢é–‹ç™ºã®ãŠä»•äº‹ãƒ¡ãƒ¢ã‚„ã€ãƒ•ã‚§ã‚¤ã‚ãƒƒã‚¯IOLã®æ‰‹è¡“ä½“é¨“è«‡ã‚’ãƒžã‚¤ãƒšãƒ¼ã‚¹ã«æ®‹ã—ã¦ã„ã¾ã—ãŸã€‚ ã‚‚ã†ã‚ã®é ƒã¸ã¯æˆ»ã‚Œãªã„ãƒ»ãƒ»ãƒ» MySQLï¼ˆ3.23æ™‚ä»£ï¼‰ã¯è²§å¼±ãªã‚¹ãƒšãƒƒã‚¯ã®ç«¯æœ«ã§ã‚‚å‹•ãã‚ˆã†ã«ã€ æ—¢å®šå€¤ã§ãƒ¡ãƒ¢ãƒªã‚’æœ€å°é™ã«ä½¿ã†è¨å®šã«ãªã£ã¦ã„ã‚‹ã‚ˆã†ã§ã™ã€‚ ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆå…¬é–‹ã®é‹ç”¨ã¨ãªã‚‹ã¨ã€ã“ã‚Œã§ã¯ æ€§èƒ½ãŒãƒ•ãƒ«ã«ç™ºæ®ã§ãã¦ã„ã¾ã›ã‚“ã€‚ ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ãŒå¿…è¦ãªã‚ã‘ã§ã™ã€‚ ã§ã€ãŠæ‰‹è»½ãªãƒã‚§ãƒƒã‚¯é …ç›®ã¨ã—ã¦ã¯ä»¥ä¸‹ã®è¨å®šã‚’ è¦‹ç›´ã™ã®ãŒè‰¯ã„ã‹ã¨ã€‚ ãƒ»key_buffer_size ãƒ»table_cache ãƒ»record_buffer ãƒ»thread_cache_size ã¨ã‚Šã‚ãˆãšã€ç§ã®é–‹ç™ºç’°å¢ƒï¼ˆãƒ¡ãƒ¢ãƒª512MBï¼‰ã§è©¦ã—ãŸ è¨å®šä¾‹ãŒä»¥ä¸‹ã§ã™ã€‚ ï½žï½žï½žï½žï½ž [mysqld] #ï¼ˆç•¥ï¼‰ set-variable=key_buffer_size=256M set-variable=table_cache=256 set-
otom 2006/12/12
ã‚‚ã†ã¡ã‚‡ã£ã¨å‰ã«ç™ºè¦‹ã—ã¦ãŸã‹ã£ãŸã‹ãªã€‚ã€‚

mysql

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
æ–°èžã¤ã‚“ã©ã ãƒ¬ãƒ“ãƒ¥ãƒ¼ MOONGIFT
æ–°èžã¤ã‚“ã©ã ãƒ¬ãƒ“ãƒ¥ãƒ¼ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« ï¼ˆã‚¯ãƒªãƒƒã‚¯ã™ã‚‹ã¨æ‹¡å¤§ã—ã¾ã™) èµ·å‹• ï¼ˆã‚¯ãƒªãƒƒã‚¯ã™ã‚‹ã¨æ‹¡å¤§ã—ã¾ã™) è¨˜äº‹ ï¼ˆã‚¯ãƒªãƒƒã‚¯ã™ã‚‹ã¨æ‹¡å¤§ã—ã¾ã™) é–¢é€£è¨˜äº‹ ï¼ˆã‚¯ãƒªãƒƒã‚¯ã™ã‚‹ã¨æ‹¡å¤§ã—ã¾ã™) æ¤œç´¢çµæžœ æ¤œç´¢éƒ¨åˆ†ã§ãƒã‚¤ãƒ©ã‚¤ãƒˆè¡¨ç¤ºã•ã‚Œã¾ã™ã€‚ ï¼ˆã‚¯ãƒªãƒƒã‚¯ã™ã‚‹ã¨æ‹¡å¤§ã—ã¾ã™) å„ç¨®è¨å®š è¨å®š1 ï¼ˆã‚¯ãƒªãƒƒã‚¯ã™ã‚‹ã¨æ‹¡å¤§ã—ã¾ã™) è¨å®š2 ï¼ˆã‚¯ãƒªãƒƒã‚¯ã™ã‚‹ã¨æ‹¡å¤§ã—ã¾ã™) æ–°èžã¤ã‚“ã©ã ç´¹ä»‹ã¯ã“ã¡ã‚‰
otom 2006/12/04
PHP+MySQL

mysql

php

ã‚¢ãƒ³ã‚±ãƒ¼ãƒˆ
ãƒªãƒ³ã‚¯
Windowsã«PHPã¨MySQLã‚’ä¸€æ‹¬ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã§ãã‚‹ç„¡å„Ÿãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã€ŒXAMPPã€ï¼Œæ—¥æœ¬èªžåŒ–ã•ã‚Œ24æ™‚é–“ã‚µãƒãƒ¼ãƒˆã‚‚é–‹å§‹
ã‚¨ã‚°ã‚¶ã‚¯ã‚½ãƒ³ã¯12æœˆ1æ—¥ï¼Œã€ŒXAMPPã€ã®24æ™‚é–“ã‚µãƒãƒ¼ãƒˆã‚’é–‹å§‹ã—ãŸã€‚XAMPã¯Windowsã‚„Linuxã«Apacheï¼ŒMySQLï¼ŒPHPã‚’ä¸€æ‹¬ã—ã¦ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ï¼Œç®¡ç†ã§ãã‚‹ç„¡å„Ÿã®ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã€‚ã‚¶ãƒ³ãƒ—ï¼Œã¾ãŸã¯ã‚¨ã‚°ã‚¶ãƒ³ãƒ—ã¨èªã‚€ã€‚éžå–¶åˆ©çµ„ç¹”ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆApache friendsãŒé–‹ç™ºï¼Œé…å¸ƒã—ã¦ãŠã‚Šï¼Œ11æœˆ27æ—¥ã«å…¬é–‹ã•ã‚ŒãŸXampp1.5.5ã‹ã‚‰ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ©ã‚„ç®¡ç†ãƒ„ãƒ¼ãƒ«ãŒæ—¥æœ¬èªžåŒ–ã•ã‚ŒãŸã€‚ Windowsã§ã¯ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ©ã‚’èµ·å‹•ã—ã¦ï¼Œãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã‚’ãªã©ã‚’æŒ‡å®šã™ã‚‹ã ã‘ã§Apacheï¼ŒMySQLï¼ŒPHPã‚’ä¸€åº¦ã«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ï¼ŒWindowsã®ã‚µãƒ¼ãƒ“ã‚¹ã«ç™»éŒ²ã§ãã‚‹ã€‚ã¾ãŸã‚³ãƒ³ãƒˆãƒãƒ¼ãƒ«ãƒ‘ãƒãƒ«ã¨å‘¼ã¶GUIãƒ„ãƒ¼ãƒ«ã«ã‚ˆã‚Šï¼ŒApacheï¼ŒMySQLãªã©ã‚’èµ·å‹•ï¼Œåœæ¢ã§ãã‚‹ã€‚ã‚¢ãƒ³ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ©ã‚‚ä»˜å±žã—ï¼Œä¸€æ‹¬ã—ã¦ã‚¢ãƒ³ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã§ãã‚‹ã€‚Linuxã§ã¯ã‚·ã‚§ãƒ«ã‚¹ã‚¯ãƒªãƒ—ãƒˆã«ã‚ˆã‚Šä¸€æ‹¬ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¨èµ·å‹•ï¼Œåœæ¢ãŒå¯èƒ½ã€‚ phpmyad
otom 2006/12/04
php

windows

xampp

mysql
ãƒªãƒ³ã‚¯
MySQL
HeatWave Use automated and integrated generative AI and machine learning (ML) in one cloud service for transactions and lakehouse scale analytics. Get faster insights from all your data with unmatched performance and deploy apps in your choice of cloud providers. Learn More Â» MySQL Enterprise Edition The most comprehensive set of advanced features, management tools and technical support to achieve
otom 2006/11/21
è‹±èªžã ã‘ã©ãƒ»ãƒ»

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹

mysql
ãƒªãƒ³ã‚¯
MySQL æ–‡å—åŒ–ã‘å•é¡Œã‚’æœ¬æ°—ã§ç›´ã™
mysql> status; -------------- mysql Ver 14.7 Distrib 4.1.20, for redhat-linux-gnu (i386) using readline 4.3 Connection id: 36 Current database: staff2006 Current user: maiha@localhost SSL: Not in use Current pager: lv Using outfile: '' Using delimiter: ; Server version: 4.1.20 Protocol version: 10 Connection: Localhost via UNIX socket Server characterset: latin1 Db characterset: latin1 Client char
otom 2006/10/20
mysql

æ–‡å—åŒ–ã‘

æ–‡å—ã‚³ãƒ¼ãƒ‰
ãƒªãƒ³ã‚¯
dublish.com - Simple Optimization for PHP and MySQL
Simple Optimization for PHP and MySQL Saturday April 29 2006 03:23 Here is a list of a few very simple tips for optimizing your php/mysql applications. Keep these in mind while developing. MySQL MySQL is interpreted from right to left so you should put the most significant limiters as far to the right as possible. Only select fields you need, instead of selecting * (everything). Don't put things t
otom 2006/07/08
PHP

MySql
ãƒªãƒ³ã‚¯
Excelã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚’MySQLã®ãƒ‡ãƒ¼ã‚¿å½¢å¼ã«å¤‰æ›:phpspoté–‹ç™ºæ—¥èªŒ
xls2mysql To ensure maximum compatibility please use Excel 97 filesPlease browse your Excel file and press send (Max file size for PHP upload : 2M)Excelã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚’MySQLã®ãƒ‡ãƒ¼ã‚¿å½¢å¼ã«å¤‰æ›ã™ã‚‹ã‚µãƒ¼ãƒ“ã‚¹ã€‚ xlsãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã‚¢ãƒƒãƒ—ãƒãƒ¼ãƒ‰ã™ã‚‹ã“ã¨ã§ç°¡å˜ã«å¤‰æ›ã§ãã‚‹ã‚ˆã†ã§ã™ã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«ã®ãƒ‡ãƒ¼ã‚¿ã‚’Excelã§ç·¨é›†ã™ã‚‹ã£ã¦ãƒ—ãƒã‚°ãƒ©ãƒžä»¥å¤–ã®æ–¹ã«ã¯çµæ§‹ä¾¿åˆ©ã ã£ãŸã‚Šã—ã¾ã™ãŒã€ã“ã†ã„ã£ãŸã‚‚ã®ã§å¤‰æ›ã§ãã‚‹ã‚ˆã†ã«ã—ã¦ãŠãã¨ä¾¿åˆ©ã§ã™ãã€‚ PHPã‹ã‚‰Excelã‚’æ‰±ã†å ´åˆã€æ¬¡ã®PEARãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ãŒä¾¿åˆ©ã€‚ Spreadsheet_Excel_Writer Spreadsheet_Excel_Reader (proposal) Structures_DataGrid_R
otom 2006/06/29
PHP

MySql
ãƒªãƒ³ã‚¯
MySQLã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãƒ„ãƒ¼ãƒ«: phpMyBackupPro:phpspoté–‹ç™ºæ—¥èªŒ
MOONGIFT - phpMyBackupPro - ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã«ã‚ˆã‚‹ITæˆ¦ç•¥æ”¯æ´ - ä»Šå›žç´¹ä»‹ã™ã‚‹ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã¯phpMyBackupProã€PHPã«ã‚ˆã‚‹MySQLãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚·ã‚¹ãƒ†ãƒ ã ã€‚ phpMyBackupProÂ ã¨ã„ã†PHPã§æ›¸ã‹ã‚ŒãŸMySQLã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãƒ„ãƒ¼ãƒ«ã®ãƒ¬ãƒ“ãƒ¥ãƒ¼è¨˜äº‹ã®ç´¹ä»‹ã€‚ MySQLã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—æ‰‹æ³•ã«ã¯mysqldumpã‚’ä½¿ã£ãŸæ–¹æ³•ã‚„ã€mysqlhotcopyã‚’ä½¿ã£ãŸæ–¹æ³•ãŒã‚ã‚Šã¾ã™ãŒã€ ã“ã®ãƒ„ãƒ¼ãƒ«ã®ã‚ˆã†ã«WEBãƒ™ãƒ¼ã‚¹ã§å°‚ç”¨ã®ç®¡ç†ç”»é¢ãŒã‚ã£ã¦ã„ã¤ã§ã‚‚æ‰‹è»½ã«ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã§ãã‚‹ã£ã¦ã„ã†ã®ã‚‚é…åŠ›ã§ã™ãã€‚ phpMyAdminãªã‚“ã‹ã§ã‚‚ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆç”»é¢ã§ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¯å¯èƒ½ã§ã™ãŒã€phpMyBackupã¯ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã«ç‰¹åŒ–ã•ã‚Œã¦ã„ã‚‹ãƒ„ãƒ¼ãƒ«ãªã®ã§ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã®å±¥æ´ã‚’æ®‹ã™ã“ã¨ãŒã§ããŸã‚Šã™ã‚‹ã‚ˆã†ã§ã™ã€‚
otom 2006/03/26
MySql
ãƒªãƒ³ã‚¯
1