[B! mysql][ä½¿ã£ãŸ] sea_mountainã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

sea_mountain id:sea_mountain

mysqlã¨ä½¿ã£ãŸã«é–¢ã™ã‚‹sea_mountainã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (6)

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

MacOSXã«MySQLã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹æ–¹æ³• | Macã®ãƒ›ãƒ¼ãƒ ãƒšãƒ¼ã‚¸ä½œæˆã‚¬ã‚¤ãƒ‰
MacOSXã«MySQLã¨ã„ã†ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹æ–¹æ³•ã‚’è§£èª¬ã—ã¾ã™ã€‚MySQLã¯ãƒ–ãƒã‚°ã‚·ã‚¹ãƒ†ãƒ ã®Movable Typeï¼ˆãƒ ãƒ¼ãƒãƒ–ãƒ«ã‚¿ã‚¤ãƒ—ï¼‰ãªã©ã§ã‚‚ä½¿ç”¨ã§ãã¾ã™ã€‚ ã“ã“ã§ã¯.dmgã®ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¦ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¾ã™ã€‚ æœ€æ–°ã®MySQLã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã™ã‚‹ MySQLã®å…¬å¼ã‚µã‚¤ãƒˆã‹ã‚‰æœ€æ–°ç‰ˆã®MySQLã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¾ã™ã€‚å…¬å¼ã‚µã‚¤ãƒˆã¯æ—¥æœ¬èªžç‰ˆã‚‚ç”¨æ„ã•ã‚Œã¦ã„ã‚‹ã®ã§ã™ãŒã€ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ãƒšãƒ¼ã‚¸ã ã‘ã¯è‹±èªžã§ã™ã€‚ ã—ã‹ã—ã€ãã‚Œã»ã©é›£ã—ãã¯ã‚ã‚Šã¾ã›ã‚“ã®ã§å¦™ã«æ§‹ãˆã‚‹å¿…è¦ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ ä¸‹è¨˜ã®URLã‹ã‚‰ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ãŸã„ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã®ã€ŒPick a mirrorã€ãƒªãƒ³ã‚¯ã‚’ã‚¯ãƒªãƒƒã‚¯ã—ã¦é¸æŠžã—ã¾ã™ã€‚MacOSXã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã”ã¨ã«åˆ†ã‹ã‚Œã¦ã„ã¾ã™ã®ã§ã€ä½¿ç”¨ã—ã¦ã„ã‚‹OSã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã«åˆã£ãŸã‚‚ã®ã‚’é¸æŠžã—ã¦ãã ã•ã„ã€‚ http://dev.mysql.com/downloads/m
sea_mountain 2011/04/21
mysql

mac

è¨å®š

ä½¿ã£ãŸ

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

åŠ©ã‹ã£ãŸ
ãƒªãƒ³ã‚¯
MySQL ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ã‚»ãƒƒãƒˆã‚¢ãƒƒãƒ—æ‰‹é † - ã‚ãã‚ãæŠ€è¡“ãƒ©ãƒ³ãƒ‰
æƒ³å®šã—ã¦ã„ã‚‹ã“ã¨ â€ MySQL5.0 MySQLãŒã™ã§ã«ç¨¼å‹•ä¸ã€‚ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®è¨å®šã¯ã—ã¦ã„ãªã„ ä»Šå›žMySQLã‚’ã‚‚ã†ä¸€å°å¢—ã‚„ã—ã¦2å°æ§‹æˆã¨ã—ã€masterã€slaveã®æ§‹æˆã«ã™ã‚‹ â€»ä»Šå›žã¨çŠ¶æ³ãŒç•°ãªã‚‹å ´åˆã¯ã€MySQLã®ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã‚’èªã‚€ã¨ã„ã„ã§ã™ã€‚ â†‘ 1. ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ç”¨ãƒ¦ãƒ¼ã‚¶ã‚’ä½œæˆã™ã‚‹ â€ ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ç”¨ãƒ¦ãƒ¼ã‚¶ã‚’ä½œæˆã™ã‚‹ ä½œæˆã™ã‚‹ãƒ¦ãƒ¼ã‚¶ãƒ¼ã¯ã‚¹ãƒ¬ãƒ¼ãƒ–ãŒãƒžã‚¹ã‚¿ã®ãƒã‚¤ãƒŠãƒª ãƒã‚°ã‚’èªã¿è¾¼ã‚€ã¨ãã«æŽ¥ç¶šã™ã‚‹ãƒ¦ãƒ¼ã‚¶ãƒ¼ã¨ãªã‚‹ã€‚ æ—¢å˜ã®ãƒ¦ãƒ¼ã‚¶ãƒ¼ã§ã‚‚ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯å¯èƒ½ã ãŒã€ãƒ¦ãƒ¼ã‚¶åã¨ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ãŒ master.info ãƒ•ã‚¡ã‚¤ãƒ«å†…ã«ãƒ†ã‚ã‚¹ãƒˆã§ä¿å˜ã•ã‚Œã‚‹ãŸã‚ã€å®‰å…¨ã®ãŸã‚ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãƒ—ãƒã‚»ã‚¹ã«ã ã‘æ¨©é™ãŒã‚ã‚‹ãƒ¦ãƒ¼ã‚¶ã‚’ä½œæˆã™ã‚‹ è¨å®šä¾‹(ãƒžã‚¹ã‚¿ã®ã»ã†ã«è¨å®š) 192.168.23.0/24 å†…ã®ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ã§è¨±å¯ ãƒ¦ãƒ¼ã‚¶ãƒ¼åï¼šrepl ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ï¼šslavepass mysql >
sea_mountain 2011/03/10
5ã§.dbã‚’ã‚¤ãƒ³ãƒãƒ¼ãƒˆã—ã¦ã„ã‚‹ãŒã€ã‚¨ãƒ©ãƒ¼ãŒå‡ºãŸã®ã§.sqlã§å…¥ã‚ŒãŸã€€ãƒžã‚¹ã‚¿ãƒ¼ã«ä½œæˆã—ãŸãƒ¦ãƒ¼ã‚¶ã¯IPã‚¢ãƒ‰ãƒ¬ã‚¹ç›´æŽ¥æŒ‡å®šã«ã™ã‚Œã°ã€ã‚¢ã‚¯ã‚»ã‚¹ã§ãã‚‹ã‚ˆã†ã«ãªã£ãŸ

mysql

ã‚µãƒ¼ãƒ

ä½¿ã£ãŸ
ãƒªãƒ³ã‚¯
MySQLã®ãƒ‡ãƒ¼ã‚¿ã‚’Windowsã‹ã‚‰Linuxã¸ç§»è¡Œã™ã‚‹æ‰‹é † - ãŸã“ã¯ã¡ã®ã€Œã¸ã®ã‹ã£ã±ã€æ—¥è¨˜
Windowsã§ä½œæˆã—ãŸMySQLã®ã‚¹ã‚ãƒ¼ãƒžã¨ãƒ‡ãƒ¼ã‚¿ã‚’ã”ã£ãã‚ŠLinuxã¸ç§»ã™ã“ã¨ã«ã—ãŸã®ã ãŒã€ä¾‹ã«ã‚ˆã£ã¦æ–‡å—ã‚³ãƒ¼ãƒ‰ãªã©ã®å•é¡ŒãŒã‚ã‚Šã€ç´ ç›´ã«ã¯è¡Œã‹ãªã‹ã£ãŸã€‚ãƒ¡ãƒ¢ã¨ã—ã¦æ®‹ã—ã¦ãŠã“ã†ã€‚mysqldumpã‚’ç”¨ã„ã¦Windowsã®MySQLã§ä½œæˆã—ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã—ã€ãã‚Œã‚’Linuxã®MySQLã«mysqlã‚’ä½¿ã£ã¦ãƒªã‚¹ãƒˆã‚¢ã™ã‚‹æ‰‹é †ãªã®ã ãŒã€2ç‚¹ã»ã©æ³¨æ„ãŒå¿…è¦ã ã£ãŸã€‚ ãã‚Œãžã‚Œã®MySQLã¯ä»¥ä¸‹ã®ã‚ˆã†ãªæ§‹æˆã«ãªã£ã¦ã„ã‚‹ã€‚create database test; ã¨ã™ã‚‹ã¨testã¨ã„ã†databaseãŒä½œæˆã•ã‚Œã‚‹ã€‚DBã®å®Ÿä½“ã¯Linuxå´ã§ã¯/var/lib/mysql/testã¨ãªã‚‹ã€‚åŒã˜æ§‹æˆã§Windowsã®MySQLã«ã‚‚testã¨ã„ã†databaseãŒã‚ã‚‹ã¨ã™ã‚‹ã€‚ â– Windowså´ +-- C:/Program Files/MySQL/MySQL Server 5.x/ | +-
sea_mountain 2011/02/14
mysql

ã‚µãƒ¼ãƒ

ä½¿ã£ãŸ

åŠ©ã‹ã£ãŸ
ãƒªãƒ³ã‚¯
ã€ŽMySQL å¤§æ–‡å—å°æ–‡å—è˜åˆ¥ã€
MySQLã®å¤§æ–‡å—å°æ–‡å—è˜åˆ¥ã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆè¨å®šã¯OSã«ã‚ˆã‚Š ç•°ãªã‚‹ãã†ã§ã™ã€‚Winã¯ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆå¤§æ–‡å—å°æ–‡å— ã®åŒºåˆ¥ãªã—ã€‚ ãªã®ã§ã€æœ¬ç•ªç’°å¢ƒãŒUNIXç³»ã§é–‹ç™ºç’°å¢ƒãŒWindowsã®å ´åˆã€ ãƒ†ãƒ¼ãƒ–ãƒ«åã‚„ã‚«ãƒ©ãƒ åã«å¤§æ–‡å—ã¨å°æ–‡å—ã‚’æ„è˜ã—ã¦ ãŠã‹ãªã„ã¨ã€UNIXç³»ã®ç’°å¢ƒã§çªç„¶DBã‚¢ã‚¯ã‚»ã‚¹ã«å¤±æ•—ã™ã‚‹ ã“ã¨ãŒã‚ã‚‹ã€‚ ãã®è¨å®šã¯ã€€mysql.iniã€€ã«ä»¥ä¸‹ã®ã‚ˆã†ã«è¨å®šã‚’ è¿½åŠ ã—ã¦MySQLã‚’å†èµ·å‹•ã™ã‚‹ lower_case_table_name = 0
sea_mountain 2011/02/14
ã‚µãƒ¼ãƒ

mysql

ä½¿ã£ãŸ
ãƒªãƒ³ã‚¯
MySQL 5.1 ã§æ–‡å—ã‚³ãƒ¼ãƒ‰ã‚’è¨å®š ( UTF-8 ) - Mac OS X v10.5 ã§ web ã‚¢ãƒ—ãƒªé–‹ç™º
/etc/my.cnf ã‚’ç·¨é›†ã—ã¾ã™ã€‚ /etc/my.cnf ãŒå˜åœ¨ã—ãªã„å ´åˆã¯ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸ MySQL ã®ä¸ã®ã‚µãƒ³ãƒ—ãƒ«ã‚’ã‚³ãƒ”ãƒ¼ã—ã¦ãã¾ã™ã€‚ ã‚¿ãƒ¼ãƒŸãƒŠãƒ«ã‹ã‚‰ä»¥ä¸‹ã®ã‚³ãƒžãƒ³ãƒ‰ã‚’å…¥åŠ›ã—ã¾ã™ã€‚ ä¸€èˆ¬ãƒ¦ãƒ¼ã‚¶ã«ã¯è¨±å¯ã•ã‚Œã¦ã„ãªã„ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã¸ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã‚³ãƒ”ãƒ¼ã™ã‚‹ã®ã§ sudo ã‚³ãƒžãƒ³ãƒ‰ã‚’åˆ©ç”¨ã—ã¾ã™ã€‚ $ sudo cp /usr/local/mysql/support-files/my-medium.cnf /etc/my.cnf vi ç‰ã®ã‚¨ãƒ‡ã‚£ã‚¿ã§ /etc/my.cnf ã‚’é–‹ãã¾ã™ã€‚ [client]ã€[mysqldump]ã€[mysql] ã®å„é …ç›®ã¸ä»¥ä¸‹ã® 1 è¡Œã‚’è¿½åŠ ã—ã¾ã™ã€‚ default-character-set=utf8 [mysqld] ã®é …ç›®ã¸ä»¥ä¸‹ã® 5 è¡Œã‚’è¿½åŠ ã—ã¾ã™ã€‚ default-character-set = utf8 skip-character-set-cli
sea_mountain 2010/11/12
mysql

è¨å®š

mac

ä½¿ã£ãŸ
ãƒªãƒ³ã‚¯
é›‘å¦ | ruby1.8.6(mswin332)+rails2.3.4+mysql5.1.37 ã§MySQLã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ã‚¨ãƒ©ãƒ¼
<< October 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 31 >> ã‚¿ã‚¤ãƒˆãƒ«ã®æ§‹æˆã§Railsã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã‚’ä½œæˆã—ãŸã¨ã“ã‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ“ä½œã™ã‚‹éš›ã«ã‚¨ãƒ©ãƒ¼ãŒç™ºç”Ÿã—ã¦ã—ã¾ã„ã¾ã—ãŸ(TT depot>rake db:migrate --trace (in D:/Projects/RoR/depot) ** Invoke db:migrate (first_time) ** Invoke environment (first_time) ** Execute environment ** Execute db:migrate rake aborted! Mysql::Error: query: not connected:
sea_mountain 2010/10/21
c:\program files\ruby-1.8\bin ã«å…¥ã‚Œã‚‹ã ã‘ã§migrateã§ããŸï¼

rails

mysql

ä½¿ã£ãŸ
ãƒªãƒ³ã‚¯
1