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

egaku id:egaku

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

${{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}}

ã€Œã¡ã‚‡ã£ã¨å¾…ã¦ã€ çœŸãƒ»MySQLã®ã‚¯ã‚¨ãƒªã‚’æœ€é©åŒ–ã™ã‚‹10ã®Tips
Jaslabs: High performance phpã§ç´¹ä»‹ã•ã‚ŒãŸã€ŒMySQLã®ã‚¯ã‚¨ãƒªã‚’æœ€é©åŒ–ã™ã‚‹10ã®Tipsã€ã«å¯¾ã—ã¦ã€åè«–ã—ã¦ã„ã‚‹äººãŒã„ã‚‹ã€‚ãƒ–ãƒã‚°ã€Œ20bitsã€ã®Jesseæ°ã ã€‚å½¼ã¯ã€Œ10 Tips for Optimizing MySQL Queries (That donâ€™t suck)ã€ã¨ã„ã†ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã§ã€Jaslabsæ°ã®è¨˜äº‹ã¯é©åˆ‡ã§ãªã„ã¨ã—ã¦ã„ã‚‹ã€‚ Jesseæ°ã®çµŒé¨“ã«ã‚ˆã‚Œã°ã€SQLæœ€é©åŒ–ã§æœ€ã‚‚é‡è¦ãªã“ã¨ã¯SQLã‚„DBã®åŸºæœ¬ã‚’ã—ã£ã‹ã‚Šã¨ç†è§£ã™ã‚‹ã“ã¨ã§ã‚ã‚Šã€60ï¼…ãŒã“ã‚Œã§è§£æ±ºã™ã‚‹ã¨ã„ã†ã€‚æ®‹ã‚Š35ï¼…ã¯DBã‚„ã‚¯ã‚¨ãƒªã®ç‰¹æ®Šãªæ€§è³ªã«å¯¾ã™ã‚‹å¯¾å‡¦ã§ã‚ã‚Šã€æœ€å¾Œã®5ï¼…ã§ç™ºæƒ³ã®è»¢æ›ãªã©ã‚’æ±‚ã‚ã‚‰ã‚Œã‚‹ã€‚Jaslabsæ°ã¯ã“ã“ã«ã°ã‹ã‚ŠåŠ›ã‚’å…¥ã‚Œã¦ãŠã‚Šã€ãã‚Œã¯ã¾ã£ãŸãã‚‚ã£ã¦æ™‚é–“ã®ç„¡é§„ã ã¨è¿°ã¹ã¦ã„ã‚‹ï¼ˆJesseæ°ã¯ã€ŒSQL_SMALL_RESULTãªã‚“ã¦ã€ç”Ÿã¾ã‚Œã¦ã“ã®æ–¹ä½¿ã£ãŸã“ã¨ã™ã‚‰ãªã„ã€ã¨ã¾ã§è¨€ã£
egaku 2011/06/27
mysql

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
MySQLã§æœ€æ–°ã®ç‰¹å®šã‚°ãƒ«ãƒ¼ãƒ—ã”ã¨ã«æœ€æ–°ãƒ¬ã‚³ãƒ¼ãƒ‰ã®â—‹ä»¶ã ã‘ã‚’è¡¨ç¤ºã™ã‚‹æ–¹æ³• - Database Expertä¼šè°å®¤
ï¼ IT MONOistä¼šè°å®¤çµ‚äº†ï¼ˆ2011å¹´3æœˆ31æ—¥ï¼‰ã®ãŠçŸ¥ã‚‰ã› ï¼ IT MONOistã¯4æœˆ1æ—¥ã‚ˆã‚Šã€ã‚¢ã‚¤ãƒ†ã‚£ãƒ¡ãƒ‡ã‚£ã‚¢IDã§ã®èªè€…ç™»éŒ²ã‚’é–‹å§‹ã—ã¾ã—ãŸã€‚ã“ã‚Œã«ä¼´ã„ã€ï¼ IT MONOistã§ã®ï¼ ITã‚¯ãƒ©ãƒ–ã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’2011å¹´3æœˆ31æ—¥ã§çµ‚äº†ã—ã€ï¼ IT MONOistä¼šè°å®¤ã¸ã®æ–°è¦æ›¸ãè¾¼ã¿ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ãªãŠã€ãã®ä»–ã®ï¼ ITä¼šè°å®¤ã€ï¼ ITæƒ…å ±ãƒžãƒã‚¸ãƒ¡ãƒ³ãƒˆä¼šè°å®¤ã€ï¼ ITè‡ªåˆ†æˆ¦ç•¥ç ”ç©¶æ‰€ä¼šè°å®¤ã¯ä»Šå¾Œã‚‚ç¶™ç¶šã—ã¦ã”åˆ©ç”¨ã®ã»ã©ãŠé¡˜ã„ã—ã¾ã™ã€‚ ã§ããã†ã§ã§ããªãã¦æ‚©ã‚“ã§ã‚‹ã®ã€åŠ©ã‘ã¦ã„ãŸã ããŸã„ã§ã™ã€‚ mysql> select * from test; +----+------+-------+---------------------+ | id | name | class | created | +----+------+-------+---------------------+ | 1
egaku 2011/06/22
mysql

æŠ½å‡º
ãƒªãƒ³ã‚¯
CentOS5ã®MySQL5ã‚’å…¥ã‚Œæ›¿ãˆã‚‹ - satospo
CentOS5æ¨™æº–ã®MySQL(5.0.77)ã‚’å‰Šé™¤ã—ã€MySQLå…¬å¼ã‚µã‚¤ãƒˆã®æœ€æ–°ç‰ˆã«å…¥ã‚Œç›´ã™æ–¹æ³•ã«ã¤ã„ã¦ã€‚æ—¢å˜ã®ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã‚’ã‚¢ãƒ³ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸå¾Œã«ã€rpmã‚³ãƒžãƒ³ãƒ‰ã§æ–°ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¾ã™ã€‚ã¾ãŸã€Perlãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã¯CPANã‹ã‚‰ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã‚’å…¥æ‰‹ã—ã¦ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ç›´ã—ã¾ã™ã€‚ è©¦ã—ãŸç’°å¢ƒã€‚ é …ç›® ãƒãƒ¼ã‚¸ãƒ§ãƒ³ ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰å…ˆã®MySQLã€‚ MySQL CommunityServer 5.0.89 RedHatEnterpriseLinux5(x86) æ—¢å˜MySQLã®ã‚¢ãƒ³ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« æ—¢ã«CentOS5ä¸Šã«ã‚ã‚‹MySQLã‚’ã‚¢ãƒ³ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¾ã™ã€‚ã“ã®ã¨ãã«Perlãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚‚ã‚¢ãƒ³ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¾ã™ã€‚ä»¥ä¸‹ã®é †ç•ªã§rpmã‚³ãƒžãƒ³ãƒ‰ã‚’å®Ÿè¡Œã—ã¦ã„ãã¾ã™ã€‚ â€»mysqldãŒèµ·å‹•ã—ã¦ã‚‹å ´åˆã¯åœæ¢ã™ã‚‹ã€‚ [root]# service mysqld stop â€»ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã®ã‚¢ãƒ³ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã€‚
egaku 2011/06/01
mysql

CentOS

ã‚¢ãƒ³ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«

ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«
ãƒªãƒ³ã‚¯
http://www.wdsdx.com/mysql_install
egaku 2011/05/30
mysql

CentOS

ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«
ãƒªãƒ³ã‚¯
MySQL | ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹å†æ§‹ç¯‰ å†ä½œæˆ | REPAIR TABLE | Create it!
PHPã€AJAXã€Javascriptã€XHTMLã€CSSã€SEOã€ã‚¢ãƒ•ã‚§ãƒªã‚¨ã‚¤ãƒˆã€WEBãªã‚‰ãªã‚“ã§ã‚‚æ¥ã„ã€‚ << April 2009 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 >>
egaku 2011/05/27
mysql

ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹

å†æ§‹ç¯‰
ãƒªãƒ³ã‚¯
Perl Tips | MySQL ã§ã€é‡è¤‡ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’æŠ½å‡ºã™ã‚‹æ–¹æ³•
MySQL ï¼ˆã¾ãã€å˜ãªã‚‹ SQLï¼‰ã§ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ä¸ã®é‡è¤‡ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’é™¤ã„ã¦æ¤œç´¢ã™ã‚‹ã«ã¯ distinct ã‚’ä½¿ã†ã®ãŒå®šçŸ³ã ãŒã€ãã®é€†ã«é‡è¤‡ãƒ¬ã‚³ãƒ¼ãƒ‰ã®ã¿æŠ½å‡ºãƒ»å–å¾—ã—ãŸã„å ´åˆã¯ã©ã®ã‚ˆã†ã«ã—ãŸã‚‰ã‚ˆã„ã®ã ã‚ã†ï¼Ÿçµè«–ã¯ã€ä»¥ä¸‹ã®ã‚ˆã†ã«ã™ã‚Œã°ã‚ˆã„ã€‚ select * from ãƒ†ãƒ¼ãƒ–ãƒ«A where åˆ—A in (select åˆ—A from ãƒ†ãƒ¼ãƒ–ãƒ«A group by åˆ—A having count(*) > 1); é‡è¤‡é …ç›®ã®ã‚ã‚‹ãƒ‡ãƒ¼ã‚¿ã‚’æŠ½å‡º ï¼ˆæ•™ãˆã¦ SQLï¼‰ ã€é‡è¤‡ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’å–å¾—ã™ã‚‹ã€‘ ï¼ˆMy wonderful livingï¼‰
egaku 2011/05/12
mysql

é‡è¤‡

æŠ½å‡º
ãƒªãƒ³ã‚¯
quall.netÂ -Â ã“ã®ã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã¯è²©å£²ç”¨ã§ã™ï¼Â -Â quall ãƒªã‚½ãƒ¼ã‚¹ãŠã‚ˆã³æƒ…å ±
This webpage was generated by the domain owner using Sedo Domain Parking. Disclaimer: Sedo maintains no relationship with third party advertisers. Reference to any specific service or trade mark is not controlled by Sedo nor does it constitute or imply its association, endorsement or recommendation.
egaku 2011/04/27
mysql

CentOS

è¨å®š
ãƒªãƒ³ã‚¯
â„–1997 centos5.5ã§mysqlã®å†ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« - Web Patio - CentOSã§è‡ªå®…ã‚µãƒ¼ãƒãƒ¼æ§‹ç¯‰
æ—¥æ™‚ï¼šÂ 2010/11/14 22:27 åå‰ï¼šÂ R_Kan ã¯ã˜ã‚ã¾ã—ã¦ã€‚ centos5.5ã«mysqlã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦ ä¸€é€šã‚Šè¨å®šã‚’å®Œäº†ã•ã›ã¦ã€ãƒã‚°ã‚¤ãƒ³ã—ã‚ˆã†ã¨ã—ãŸã‚‰ãƒã‚°ã‚¤ãƒ³ãŒã§ãã¾ã›ã‚“ã§ã—ãŸã€‚ ãªã®ã§ã€ yum remove mysql-server ã‚’å®Ÿè¡Œã—ãŸã‚ã¨ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã‚ˆã†ã¨ã—ãŸã®ã§ã™ãŒã€ 1 packages excluded due to repository priority protections Setting up Install Process Package mysql-server-5.0.77-4.el5_5.4.i386 already installed and latest version Nothing to do ã¨å‡ºã¦ã—ã¾ã„ã€ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã§ãã¾ã›ã‚“ï¼ˆã¨ã„ã†æ§˜ã«æ„Ÿã˜ã¦ã„ã¾ã™ãŒã€ä½•ã‹é•ã†ã®ã§ã—ã‚‡ã†ã‹ï¼Ÿï¼‰ ä¸€åº¦ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹å‰ã®çŠ¶æ…‹ã«æˆ»ã—ã€å†
egaku 2011/04/27
mysql

CentOS

ã‚¢ãƒ³ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«

ãƒˆãƒ©ãƒ–ãƒ«
ãƒªãƒ³ã‚¯
MySQL 5.0.45ã‚’ã‚½ãƒ¼ã‚¹ã‹ã‚‰ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ on CentOS4.4 - Developerâ˜†STYLE
ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ–¹æ³•ã¯æ›¸ç±ã‚„Webã‚µã‚¤ãƒˆå„æ‰€ã«ãŸãã•ã‚“ã‚ã‚Šã¾ã™ãŒã€ä»¥å¤–ã¨ä¸€ç™ºã§ã„ã‹ãªã„ã‚‚ã®ã§ã™ãã€‚ ãã‚“ãªã‚ã‘ã§ä»¥ä¸‹ã®ç’°å¢ƒã«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸã°ã‹ã‚Šã§ã™ã®ã§ã€ãƒ¡ãƒ¢ã—ã¦ãŠããŸã„ã¨æ€ã„ã¾ã™ã€‚ MySQL5.0.45 OSã¯CentOS4.4 mysqlãƒ¦ãƒ¼ã‚¶ã®è¿½åŠ # groupadd mysql # useradd -g mysql mysql ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ ã‚½ãƒ¼ã‚¹ã®ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã‚’ä»¥ä¸‹URLã‹ã‚‰è¡Œã„ã¾ã™ã€‚ MySQL AB :: MySQL 5.0 Downloads http://dev.mysql.com/downloads/mysql/5.0.html#source ã“ã“ã§ã¯5.0.45ã®ã‚½ãƒ¼ã‚¹(tar.gz)ã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¾ã™ã€‚ # cd /usr/local/src # wget http://dev.mysql.com/get/Downloads/MySQL-5.0/mysql-5.
egaku 2011/04/26
mysql

ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«

CentOS
ãƒªãƒ³ã‚¯
rottel.net
This domain may be for sale!
egaku 2011/04/26
mysql

ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«

linux
ãƒªãƒ³ã‚¯
ã‚«ãƒªãƒ“ã‚¢ãƒ³ã‚³ãƒ æœŸé–“é™å®šã‚¹ãƒšã‚·ãƒ£ãƒ«ãƒ¼ç„¡æ–™ãŠè©¦ã—é–‹å§‹ï¼
egaku 2011/03/25
mysql

ã‚µãƒ¼ãƒç®¡ç†

innodb
ãƒªãƒ³ã‚¯
ibdata1ã®ã‚µã‚¤ã‚ºã‚’æ¸›ã‚‰ã™æ–¹æ³• - ä¸»å¤«ã¨ãã©ããƒ—ãƒã‚°ãƒ©ãƒž
mysqlã®ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚©ãƒ«ãƒ€ãŒå¤§ãããªã£ã¦ã„ã‚‹ã€‚ã©ã†ã‚‚ibdata1ã¨ã„ã†ãƒ•ã‚¡ã‚¤ãƒ«ãŒè‚¥å¤§åŒ–ã—ã¦ã„ã‚‹ã€‚èª¿ã¹ã¦ã¿ã‚‹ã¨ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆè¨å®šã§InnoDbã‚’é•·æœŸé–“ä½¿ã£ã¦ã„ã‚‹ã¨ã€ãã®ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚¡ã‚¤ãƒ«ã§ã‚ã‚‹ibdata1ãŒå®Ÿéš›ã®ãƒ‡ãƒ¼ã‚¿ã‚ˆã‚Šã‚‚å¤§ãã„ãƒ•ã‚¡ã‚¤ãƒ«ã«ãªã£ã¦ã—ã¾ã†ã€‚ã—ã‹ã‚‚ã“ã®ibdata1ã¯å…¨ã¦ã®InnoDbãŒå…±é€šã§ä½¿ã†ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚¡ã‚¤ãƒ«ã®ã‚ˆã†ã ã€‚ ã“ã‚Œã¯ã„ã‹ã‚“ã€ã¨ã„ã†ã“ã¨ã§ibdata1ã®ã‚µã‚¤ã‚ºã‚’æ¸›ã‚‰ã—ã€tableã”ã¨ã«ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ä½œæˆã™ã‚‹æ–¹æ³•ã®ã¾ã¨ã‚ã€‚ 1.databaseã‚’ã™ã¹ã¦ãƒ€ãƒ³ãƒ— DBã«ç™»éŒ²ã•ã‚Œã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ã‚’ã™ã¹ã¦ãƒ€ãƒ³ãƒ—ã—ã¦ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’ã¤ãã‚Šã¾ã™ã€‚--single-transaction ã®ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚’ã¤ã‘ã‚‹ã“ã¨ã§ã€ãƒ€ãƒ³ãƒ—ä¸ã®ãƒ‡ãƒ¼ã‚¿å¤‰æ›´ã‚’ç¦æ¢ã—ã¾ã™ã€‚ # mysqldump -u root -p --all-database --single-transaction > /tmp/all-da
egaku 2011/03/25
mysql

ibdata1

ã‚µãƒ¼ãƒç®¡ç†
ãƒªãƒ³ã‚¯
mysqldumpã§å‡ºåŠ›ã—ãŸsqlã‚’å®Ÿè¡Œã™ã‚‹ã¨ãã«ã¯LOCK TABLESã‚ªãƒ—ã‚·ãƒ§ãƒ³ã«æ³¨æ„ã™ã‚‹
ä»•äº‹ã§MySQLã‚’è§¦ã‚‹æ™‚é–“ãŒå¢—ãˆã¦ãã‚‹ã¨ã€ã„ã‚ã„ã‚çŸ¥ã‚‰ãªã‹ã£ãŸã“ã¨ã‚„ãƒãƒžã‚ŠãŒå‡ºã¦ãã‚‹ã€‚ã„ã‚ã„ã‚å‹‰å¼·ã«ãªã£ã¦æ¥½ã—ã„ãªãã¨æ€ã„ã¤ã¤ã€ä»Šé€±å¼•ã£ã‹ã‹ã£ãŸãƒã‚¿ã‚’ã²ã¨ã¤ã”ç´¹ä»‹ã€‚ æ¦‚è¦mysqldumpã‚³ãƒžãƒ³ãƒ‰ã§ãƒ€ãƒ³ãƒ—ã—ãŸSQLã¯ã€ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã‚ªãƒ—ã‚·ãƒ§ãƒ³ã§ã¯ãƒ†ãƒ¼ãƒ–ãƒ«ãƒãƒƒã‚¯ãŒä»˜ä¸Žã•ã‚Œã¦ã„ã‚‹ã€‚INSERTã‚’é«˜é€Ÿã«ã™ã‚‹åŠ¹ç”¨ãŒã‚ã‚‹ãŒã€æŠ•å…¥ã™ã‚‹ãƒ¦ãƒ¼ã‚¶ã«ã€ŒLOCK TABLESã€ã®æ¨©é™ãŒãªã„ã¨å¤±æ•—ã™ã‚‹ã€‚ % mysql -u{username} -p{password} {database} < dump.sql error: 1044: Access denied for user '{username}'@'localhost' to database '{database}' when using LOCK TABLES è©³ç´°ã¨å¯¾ç–ãƒ€ãƒ³ãƒ—æ™‚ã«å¯¾ç–ã™ã‚‹ã‹ã€ãƒ¦ãƒ¼ã‚¶ã«æ¨©é™ã‚’ä»˜ä¸Žã™ã‚‹ã“ã¨ã§æŠ•å…¥ã§ãã‚‹ã‚ˆã†ã«ãªã‚‹ã€‚ä»Šå‹•ã„ã¦
egaku 2011/03/24
mysql

ã‚³ãƒžãƒ³ãƒ‰

dump

ãƒãƒƒã‚¯

æ¨©é™å¤‰æ›´
ãƒªãƒ³ã‚¯
MySQLã®ãƒ¦ãƒ¼ã‚¶ç®¡ç†
MySQL ã®ãƒ¦ãƒ¼ã‚¶ç®¡ç†ã«ã¤ã„ã¦è§£èª¬ã—ã¦ã„ãã¾ã™ã€‚èª°ã§ã‚‚å¤§åˆ‡ãªãƒ‡ãƒ¼ã‚¿ã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹äº‹ãŒã§ãã¦ã—ã¾ã£ã¦ã¯å›°ã‚‹ã®ã§ã€ãã¡ã‚“ã¨ãƒ¦ãƒ¼ã‚¶ã”ã¨ã«ç®¡ç†ã—ã¦ãŠãã‚ˆã†ã«ã—ã¾ã—ã‚‡ã†ã€‚ â– ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä½œæˆ ã¾ãšã€root ã§ãƒã‚°ã‚¤ãƒ³ã—ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œæˆã—ã¦ãŠãã¾ã™ã€‚show databases;ã§db1ãƒ†ãƒ¼ãƒ–ãƒ«ãŒä½œæˆã•ã‚ŒãŸã“ã¨ã‚’ç¢ºèªã—ã¦ãã ã•ã„ã€‚ãªãŠã€SQLæ–‡ã®æœ€å¾Œã«ã¯å¿…ãšã€Œ; ã€ãŒå¿…è¦ã«ãªã‚Šã¾ã™ã€‚ã€Œ; ã€ã¯ã€Œ\g ã€ã§ã‚‚ä»£ç”¨ã§ãã¾ã™ã€‚
egaku 2011/03/24
mysql

ãƒ¦ãƒ¼ã‚¶ç®¡ç†

æ¨©é™å¤‰æ›´
ãƒªãƒ³ã‚¯
cl.pocari.org - æ‹¡å¼µã•ã‚Œç¶šã‘ã‚‹ InnoDB ã®ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚¡ã‚¤ãƒ«ã®ã‚µã‚¤ã‚ºã‚’å°ã•ãã™ã‚‹æ–¹æ³•
æ‹¡å¼µã•ã‚Œç¶šã‘ã‚‹ InnoDB ã®ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚¡ã‚¤ãƒ«ã®ã‚µã‚¤ã‚ºã‚’å°ã•ãã™ã‚‹æ–¹æ³• 2006-07-07-2: [MySQL] MySQL ã§ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’å¯èƒ½ã«ã™ã‚‹ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã¨ã—ã¦ InnoDB ãŒã‚ã‚Šã¾ã™ï¼Ž InnoDB ã®ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚¡ã‚¤ãƒ«ã¯ï¼ŒMyISAM ãƒ†ãƒ¼ãƒ–ãƒ«ã¨ç•°ãªã£ã¦ï¼Œãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ã¯ ibdata1 ã¨ã„ã†ãƒ•ã‚¡ã‚¤ãƒ«ã«ãƒ‡ãƒ¼ã‚¿ãŒè“„ç©ã•ã‚Œã¦ã„ãã¨ã“ã«ãªã‚Šã¾ã™ï¼Ž MySQL ã® datadir ã«è‡ªå‹•æ‹¡å¼µã™ã‚‹ 10 MB ã® ibdata1 ãƒ•ã‚¡ã‚¤ãƒ«ãŒ 1 ã¤ã¨ã€5 MB ã® ib_logfile ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ãŒ 2 ã¤ä½œæˆã•ã‚Œã¾ã™ - 7.5.3. InnoDB èµ·å‹•ã‚ªãƒ—ã‚·ãƒ§ãƒ³ http://dev.mysql.com/doc/refman/4.1/ja/innodb-start.html ã“ã® ibdata1 ã¯ï¼Œå¤§é‡ã®ãƒ‡ãƒ¼ã‚¿ã‚’è¿½åŠ ã—ã¦ã„ãã¨ï¼Œè‡ªå‹•çš„ã«ã‚µã‚¤ã‚ºã‚’æ‹¡å¼µã—ã¦ã„ãã¾ã™ï¼Ž ãŸã
egaku 2011/03/24
mysql

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

é‹ç”¨

innodb
ãƒªãƒ³ã‚¯
MySQL/ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— - ãŒã—ã¾ã£ãã™
SELECT INTO OUTFILE â€ MYSQL (ãƒ†ã‚ã‚¹ãƒˆãƒ•ã‚¡ã‚¤ãƒ«ã¸ã®æ›¸ãå‡ºã—ã¨èªã¿è¾¼ã¿ï¼‰ mysql> select [åˆ—å, â€¦] into outfile '[ãƒ•ã‚¡ã‚¤ãƒ«å]' fields terminated by '[åŒºåˆ‡ã‚Šæ–‡å—]' enclosed by '[å›²ã¿æ–‡å—]' lines terminated by '[æ”¹è¡Œã‚³ãƒ¼ãƒ‰]' from [ãƒ†ãƒ¼ãƒ–ãƒ«å] [whereãªã©æ¡ä»¶æ–‡]; â†‘ mysqldumpã§å‡ºåŠ› â€ Using mysqldump to save data to CSV files $ mysqldump -p --skip-lock-tables -T ./ --fields-enclosed-by=\" --fields-terminated-by=, -t [ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹] [ãƒ†ãƒ¼ãƒ–ãƒ«] â†‘ ä½¿ã„æ–¹ â€ å®šç¾©ã®ã¿ã€ãƒ†ãƒ¼ãƒ–ãƒ«ãƒãƒƒã‚¯ãªã— mysqld
egaku 2011/03/23
mysql

dump

ãƒãƒƒã‚¯
ãƒªãƒ³ã‚¯
ç¬¬1å›žã€€é€£ç•ªã®ç‰¹æ€§ã‚’åˆ©ç”¨ã—ã¦ãƒ‡ãƒ¼ã‚¿æ“ä½œã‚’ã‚‚ã£ã¨è‡ªç”±ã«ã€€SQLã§é€£ç•ªã‚’æ‰±ã†ã€€ï¼ˆ2ï¼‰è¡Œé›†åˆã«é€£ç•ªã‚’å‰²ã‚Šå½“ã¦ã‚‹ | gihyo.jp
ã¾ãšã€ROW_NUMBERã‚’ä½¿ã†å ´åˆã«ã¯ã€ç‰¹ã«æ‚©ã‚€å¿…è¦ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ORDER BYã®ã‚ãƒ¼ã«è¿½åŠ ã—ã¾ã—ã‚‡ã†ï¼ˆãƒªã‚¹ãƒˆ3â ï¼‰â ã€‚å®Ÿè¡Œçµæžœã¯å›³2ã§ã™ã€‚ ãƒªã‚¹ãƒˆ3ã€€ä¸»ã‚ãƒ¼ãŒè¤‡æ•°åˆ—ã®å ´åˆ(ROW_NUMBER) SELECT class, student_id, ROW_NUMBER() OVER (ORDER BY class, student_id) AS seq FROM Weights2; å›³2ã€€ãƒªã‚¹ãƒˆ3ã€4ã®å®Ÿè¡Œçµæžœ class student_id seq ----- ------------ --- 1 100 1 1 101 2 1 102 3 2 100 4 2 101 5 2 102 6 2 103 7 ä¸€æ–¹ã€ç›¸é–¢ã‚µãƒ–ã‚¯ã‚¨ãƒªã®å ´åˆã¯ã©ã†ã§ã—ã‚‡ã†ã€‚ã„ãã¤ã‹æ–¹æ³•ãŒã‚ã‚‹ã®ã§ã™ãŒã€ç§ãŒæœ€ã‚‚ã‚·ãƒ³ãƒ—ãƒ«ã¨æ€ã†ã®ã¯ã€è¤‡åˆã‚ãƒ¼ã‚’æ–‡å—åˆ—ã¨ã¿ãªã—ã¦é€£çµã—ã€å¼·å¼•ã«1åˆ—ã®ã‚ãƒ¼ã«ä½œã‚Šå¤‰ãˆã¦ã—ã¾ã†ã“ã¨ã§ã™ã€‚ã
egaku 2011/03/23
mysql

é€£ç•ª
ãƒªãƒ³ã‚¯
PHPã‹ã‚‰MySQLã«ç™»éŒ²ã•ã‚Œã¦ã„ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚â€¦
PHPã‹ã‚‰MySQLã«ç™»éŒ²ã•ã‚Œã¦ã„ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ãã‚Œã§ä»¥ä¸‹ã®ã‚ˆã†ãªã‚³ãƒ¼ãƒ‰ã‚’æ›¸ã„ãŸã®ã§ã™ãŒã€å®Ÿè¡Œã•ã‚Œã¾ã›ã‚“ã€‚ $sql = "mysqldump table_name > 'c:\backup.sql' -u root -p aaaa"; $res = mysql_query($sql,$conn); â€»ã€Œtable_nameã€ã¯ã€ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã—ãŸã„ãƒ†ãƒ¼ãƒ–ãƒ«åã§ã™ã€‚ ã‚³ãƒžãƒ³ãƒ‰ãƒ–ãƒƒã‚¯ã‚’è¦‹ã‚‹ã¨ã€ãƒ¦ãƒ¼ã‚¶åã‚„ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚‚å…¥ã‚Œã‚‹ã®ã§ã€ PHPã‹ã‚‰ã¯å®Ÿè¡Œã§ããªã„ã®ã‹ãªï¼Ÿã£ã¨æ€ã£ã¦ã„ã‚‹ã®ã§ã™ãŒã€ã‚‚ã—å¯èƒ½ãªã‚‰ã”æŒ‡æ‘˜ã€ä¿®æ£ãŠé¡˜ã„ã—ã¾ã™ã€‚ ã€ãƒ†ã‚¹ãƒˆç’°å¢ƒã€‘ php5.2.0 MySQL4.0.26 WindowsXPä¸Šã®Apache2.0.58ã§ãƒ†ã‚¹ãƒˆ
egaku 2011/03/23
mysql

dump

PHP
ãƒªãƒ³ã‚¯
[ThinkIT] ç¬¬5å›žï¼šFederatedã‚¨ãƒ³ã‚¸ãƒ³ (1/3)
ä»Šå›žã¯ã€ŒFederatedã€ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã‚’å–ã‚Šä¸Šã’ã¾ã™ã€‚Federatedã‚¨ãƒ³ã‚¸ãƒ³ã¯ã€MySQL 5.0ã‹ã‚‰æä¾›ã•ã‚ŒãŸéžå¸¸ã«æ–°ã—ã„ã‚¨ãƒ³ã‚¸ãƒ³ã§ã™ã€‚ä»Šå›žã¯ã€Federatedã‚¨ãƒ³ã‚¸ãƒ³ã®ç‰¹é•·ã‚„å‹•ä½œã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ è‹±å˜èªžã®ã€ŒFederatedã€ã‚’ç›´è¨³ã™ã‚‹ã¨ã€Œé€£åˆã—ãŸã€ã¨ã„ã£ãŸæ„å‘³ã«ãªã‚Šã¾ã™ã€‚ã“ã®æ„å‘³ã®é€šã‚ŠFederatedã‚¨ãƒ³ã‚¸ãƒ³ã¯ã€ã“ã®ã‚¨ãƒ³ã‚¸ãƒ³ã‚’å‹•ä½œã•ã›ã‚‹MySQLã‚µãƒ¼ãƒå˜ç‹¬ã§å‹•ä½œã™ã‚‹ã‚‚ã®ã§ã¯ãªãã€ä»–ã®MySQLã‚µãƒ¼ãƒã¨é€£æºã—ã¦å‹•ä½œã™ã‚‹ã‚¨ãƒ³ã‚¸ãƒ³ã§ã™ã€‚ Federatedã‚¨ãƒ³ã‚¸ãƒ³ã¯ã€ãƒ†ãƒ¼ãƒ–ãƒ«ãƒ‡ãƒ¼ã‚¿ã‚’Federatedã‚¨ãƒ³ã‚¸ãƒ³è‡ªèº«ãŒå‹•ä½œã™ã‚‹MySQLã‚µãƒ¼ãƒï¼ˆFederatedã§ã¯ã“ã‚Œã‚’ãƒãƒ¼ã‚«ãƒ«ã‚µãƒ¼ãƒã¨å‘¼ã¶ï¼‰ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å†…ã«æ ¼ç´ã›ãšã€ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ã«æŽ¥ç¶šã•ã‚ŒãŸä»–ã®MySQLã‚µãƒ¼ãƒï¼ˆãƒªãƒ¢ãƒ¼ãƒˆã‚µãƒ¼ãƒï¼‰ä¸Šã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å†…ã«æ ¼ç´ã—ã¾ã™ã€‚ã‚ˆã£ã¦ã€Federatedã‚¨ãƒ³ã‚¸ãƒ³ãŒå‹•ä½œã™ã‚‹ãƒãƒ¼ã‚«ãƒ«ã‚µãƒ¼ãƒä¸Šã«
egaku 2011/03/22
mysql

federated
ãƒªãƒ³ã‚¯
http://www.res-system.com/weblog/item/550
egaku 2011/03/22
mysql

index
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸