[B! MySQL] nantanã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

nantan id:nantan

MySQLã«é–¢ã™ã‚‹nantanã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (44)

${{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 ã®ã‚¤ãƒ³ãƒ‡ã‚¯ã‚¹ãŒåˆ©ç”¨ã•ã‚Œãªã„ã‚¯ã‚¨ãƒªç‰ã‚’è‡ªå‹•æ¤œå‡ºã™ã‚‹ ExplainPolice ã®é‹ç”¨ã«ã¤ã„ã¦
LINEæ ªå¼ä¼šç¤¾ã¯ã€2023å¹´10æœˆ1æ—¥ã«LINEãƒ¤ãƒ•ãƒ¼æ ªå¼ä¼šç¤¾ã«ãªã‚Šã¾ã—ãŸã€‚LINEãƒ¤ãƒ•ãƒ¼æ ªå¼ä¼šç¤¾ã®æ–°ã—ã„ãƒ–ãƒã‚°ã¯ã“ã¡ã‚‰ã§ã™ã€‚ LINEãƒ¤ãƒ•ãƒ¼ Tech Blog LINE æ ªå¼ä¼šç¤¾ B2B Platform é–‹ç™ºæ‹…å½“ãƒ•ã‚§ãƒãƒ¼ã® Matsuno ã§ã™ã€‚ LINE ã® Business Platform ã§ã¯ãƒ¡ã‚¤ãƒ³ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦ MySQL ã‚’åˆ©ç”¨ã—ã¦ã„ã¾ã™ã€‚MySQL ã¯éžå¸¸ã«é«˜é€Ÿã«å‹•ã OSS ã® RDBMS ãªã®ã§ã€ã¨ã¦ã‚‚ä¾¿åˆ©ã«åˆ©ç”¨ã•ã›ã¦ã„ãŸã ã„ã¦ãŠã‚Šã¾ã™ã€‚ MySQL ã¯ã¨ã¦ã‚‚é«˜é€Ÿãªã®ã§ã™ãŒã€ã†ã£ã‹ã‚Š index ã‚’ä½¿ã‚ãªã„ã‚¯ã‚¨ãƒªã‚’ç™ºè¡Œã—ãŸå ´åˆã«å®Ÿè¡ŒãŒã¨ã¦ã‚‚é…ããªã£ã¦ã—ã¾ã†ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚LINE ã® Business Platform ã¯ã¨ã¦ã‚‚å¤šãã®ãŠå®¢æ§˜ãŒåˆ©ç”¨ã•ã‚Œã‚‹ã®ã§ã€B2B ã¨ã—ã¦ã¯ç•°ä¾‹ãªã»ã©ãƒˆãƒ©ãƒ•ã‚£ãƒƒã‚¯ãŒå¤šãã€å°‘ã—é…ã„ã‚¯ã‚¨ãƒªãŒç™ºç”Ÿã—ãŸçµæžœã¨ã—ã¦ã‚µã‚¤ãƒˆå…¨ä½“ãŒãƒ€ã‚¦ãƒ³ã—ã¦
nantan 2022/12/01
mysql
ãƒªãƒ³ã‚¯
Sequel Pro
Full MySQL Support Sequel Pro is a fast, easy-to-use Mac database management application for working with MySQL databases. Perfect Web Development Companion Whether you are a Mac Web Developer, Programmer or Software Developer your workflow will be streamlined with a native Mac OS X Application! Flexible Connectivity Sequel Pro gives you direct access to your MySQL Databases on local and remote se
nantan 2017/03/29
MySQL

mac
ãƒªãƒ³ã‚¯
CentOS 6.x ã« MySQL 5.7ã‚’yumã§ç°¡å˜ã«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ - Qiita
# ãƒ‡ã‚¸ã‚¿ãƒ«ç½²åã‚’ã‚¤ãƒ³ãƒãƒ¼ãƒˆã™ã‚‹ $ sudo rpm --import http://dev.mysql.com/doc/refman/5.7/en/checking-gpg-signature.html # yumãƒªãƒã‚¸ãƒˆãƒªã®è¨å®šã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ $ sudo rpm -ihv http://dev.mysql.com/get/mysql57-community-release-el6-7.noarch.rpm # yumãƒªãƒã‚¸ãƒˆãƒªã‚’listã™ã‚‹ $ yum --disablerepo=\* --enablerepo='mysql57-community*' list available # MySQL Server 5.7ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ $ sudo yum --enablerepo='mysql57-community*' install -y mysql-community
nantan 2016/06/08
MySQL

CentOS
ãƒªãƒ³ã‚¯
ã‚½ã‚·ãƒ£ã‚²ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®è‡ªåˆ†ãŒã‚³ãƒ¼ãƒ‰ãƒ¬ãƒ“ãƒ¥ãƒ¼æ™‚ã«é‡è¦–ã™ã‚‹ç®‡æ‰€33é¸ ã€éšæ™‚è¿½åŠ ã€‘ - Qiita
ã‚³ãƒ¼ãƒ‰ãƒ¬ãƒ“ãƒ¥ãƒ¼ã§åœŸæ—¥ã«å®‰å¯§ã‚’ ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã¯ã€ãƒ¦ãƒ¼ã‚¶ã‚¢ã‚¯ã‚»ã‚¹é›†ä¸ã¨ã€ãã‚Œã«ä¼´ã†ãƒ¦ãƒ¼ã‚¶ãƒ‡ãƒ¼ã‚¿å¢—åŠ ã«ã‚ˆã£ã¦åŠ‡çš„ã«è² è·ãŒä¸ŠãŒã‚Šã€ï¼ˆä¸»ã«åœŸæ—¥ã«ï¼‰ã‚µãƒ¼ãƒ“ã‚¹ã«å½±éŸ¿ã‚’ä¸ŽãˆãŒã¡ã§ã™ã€‚ å•é¡ŒãŒã‚ã‚‹ã‚³ãƒ¼ãƒ‰ã¯ã€ãŸã¨ãˆè² è·ãƒ†ã‚¹ãƒˆã‚’è¡Œã£ã¦ã‚‚ã€ä½œæˆã—ãŸã‚·ãƒŠãƒªã‚ªã«ã‚ˆã£ã¦ã¯è¦‹ã¤ã‘ã‚‰ã‚Œãªã„å¯èƒ½æ€§ã‚‚ã‚ã‚Šã¾ã™ã€‚ ãã†ã„ã£ãŸè¦‹ãˆãªã„ä¸å®‰ã‚’æ‰•æ‹ã™ã‚‹ã¨ã„ã†æ„å‘³ã§ã‚‚ã€ã‚³ãƒ¼ãƒ‰ãƒ¬ãƒ“ãƒ¥ãƒ¼ã¯é‡è¦ã ã¨æ€ã£ã¦ã„ã¾ã™ã€‚ ã€ã‚¹ãƒ†ã‚ãƒã‚¤ãƒ³ãƒˆã€‘ ãƒ» ã‚½ãƒ¼ã‚¹ã‚’è¦‹ã‚‹ã“ã¨ã«ã‚ˆã‚Šã€æ™‚é™çˆ†å¼¾ãŒåœŸæ—¥ã«çˆ†ç™ºã™ã‚‹ã®ã‚’è§£é™¤ ãƒ» ã‚¹ã‚ãƒ«å…±æœ‰ã«ã‚ˆã£ã¦ãƒ¡ãƒ³ãƒãƒ¼ãŒãƒ¬ãƒ™ãƒ«ã‚¢ãƒƒãƒ—ã™ã‚‹ã“ã¨ã«ã‚ˆã‚Šã€åœŸæ—¥ã«çˆ†ç™ºã™ã‚‹æ™‚é™çˆ†å¼¾ã®è¨ç½®ç¢ºçŽ‡ä½Žä¸‹ ã¾ãã¾ã¨ã‚ã‚‹ã¨ ã“ã‚Œã«å°½ãã¾ã™ï¼ˆ4æ³ã®æ¯åè«‡ï¼‰ ä»Šã¯ã€gitã®ãƒ—ãƒ«ãƒªã‚¯ã‚¨ã‚¹ãƒˆã¨ã„ã†å¼·åŠ›ãªãƒ¬ãƒ“ãƒ¥ãƒ¼ãƒ„ãƒ¼ãƒ«ã‚‚ã‚ã‚Šã€æ•·å±…ãŒã‹ãªã‚Šä½Žããªã£ãŸã®ã§ã‚ªã‚¹ã‚¹ãƒ¡ã§ã™ï¼ ãƒã‚§ãƒƒã‚¯ã™ã‚‹ãƒã‚¤ãƒ³ãƒˆã¯5ã¤ ã‚³ãƒ¼ãƒ‰ãƒ¬ãƒ“ãƒ¥ãƒ¼ã‚’è¡Œã†ã«ã‚ãŸã‚Šã€*ã€Œã©ã‚“ãªã¨ã“ã‚ã‚’ãƒã‚§ãƒƒã‚¯ã™ã‚Œã°ã„ã„ã®ã‹åˆ†
nantan 2016/04/08
ã‚³ãƒ¼ãƒ‰ãƒ¬ãƒ“ãƒ¥ãƒ¼

Git

MySQL

Redis

Python
ãƒªãƒ³ã‚¯
mycli
mycli BlackLivesMatter We value the diversity of our community. We strive to amplify the voices of the oppressed to eradicate racism and xenophobia. We ask our community to stand together in support of the Black community. MyCLI is a command line interface for MySQL, MariaDB, and Percona with auto-completion and syntax highlighting. Source: https://github.com/dbcli/mycli Bug tracker: https://githu
nantan 2015/07/31
MySQL

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

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
é–‹ç™ºç’°å¢ƒã‚’æ§‹ç¯‰ã™ã‚‹æ™‚ç”¨ã®ãƒ¡ãƒ¢ Apacheãƒ»PHPãƒ»MySQL
Apacheã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« ~~~ $ yum install httpd ~~~ PHP5.3ç³»ãƒ»MySQL5.1ç³»ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« å¿…è¦ãªå¤–éƒ¨ãƒªãƒã‚¸ãƒˆãƒªã‚’è¿½åŠ ã™ã‚‹(2011/1/19æ—¥æ™‚ç‚¹ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³) ~~~ wget http://dl.fedoraproject.org/pub/epel/5/i386/epel-release-5-4.noarch.rpm wget http://rpms.famillecollet.com/enterprise/remi-release-5.rpm rpm -Uvh remi-release-5*.rpm epel-release-5*.rpm ~~~ [20120322è¿½è¨˜]downloadå…ˆã®urlãŒå¤‰ã‚ã£ãŸæ°—ãŒã—ã¾ã™ï¼ English : Repository Configuration â€“ Les RPM de Remi â€“ Blog é–“
nantan 2012/07/05
mysql

php

ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«
ãƒªãƒ³ã‚¯
layer8.sh
This domain may be for sale!
nantan 2012/06/29
mysql

export

csv
ãƒªãƒ³ã‚¯
datetimeåž‹ã®ã‚«ãƒ©ãƒ ã‹ã‚‰æ—¥ä»˜ãƒ‡ãƒ¼ã‚¿ã‚’å¼•ã£å¼µã£ã¦ãã‚‹éš›ã®é«˜é€ŸåŒ– - é©å½“ãªæ—¥ã€…
ãƒ•ãƒªãƒ¼ãƒ©ãƒ³ã‚¹ã§webã®ä»•äº‹ã‚’ã—ãªãŒã‚‰webã‚µãƒ¼ãƒ“ã‚¹ã¨ã‹ã‚’ä½œã£ãŸã‚Šä½œã‚‰ãªã‹ã£ãŸã‚Šã€æˆé•·ã¨æŒ«æŠ˜ã®è¨˜éŒ²ãƒ»ãƒ»ãƒ»ã‹ã‚‚ã—ã‚Œãªã„ã¡ã‚‡ã£ã¨MySQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’ã—ãŸã‚‰ã™ã”ãæ—©ããªã£ãŸã®ã§ã€ãƒ¡ãƒ¢ãƒ¡ãƒ¢ã€‚ datetimeåž‹ã®ã‚«ãƒ©ãƒ ã‹ã‚‰æ—¥ä»˜ã®ã¿ã‚’whereè¨³ã«ãƒ‡ãƒ¼ã‚¿ã‚’å¼•ã£å¼µã£ã¦ãã‚‹ã“ã¨ã¯ã‚ˆãã‚ã‚Šã¾ã™ã€‚ ã§ã€ãƒ¬ã‚³ãƒ¼ãƒ‰ãŒæ•°ä¸‡è¡Œã«ãªã£ã¦ãã‚‹ã¨ã‘ã£ã“ã†é…ããªã£ãŸã‚Šã™ã‚‹ã€‚ ãã—ã¦ã‚«ãƒ©ãƒ ã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’å¼µã£ã¦ã‚‚å…¨ç„¶é€Ÿåº¦ãŒã‚ãŒã‚‰ãªã‹ã£ãŸã‚Šã—ã¾ã™ã€‚ ã“ã‚Œã¯ã‚¯ã‚¨ãƒªãƒ¼ãŒã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ç”¨ã—ã¦ã„ãªã„ã‹ã‚‰ãªã‚“ã§ã™ãã€‚ è‹¦ã—ã¾ãŽã‚Œã«dateåž‹ã®ã‚«ãƒ©ãƒ ã‚’ä½œã£ã¦æ—¥ä»˜ã ã‘ã‚’å…¥ã‚Œã‚‹ã¨ã„ã†æ‰‹æ³•ã‚‚ã‚ã‚Šã¾ã™ãŒã€ã¡ã‚‡ã£ã¨ã‚¹ãƒžãƒ¼ãƒˆã˜ã‚ƒãªã„ã§ã™ã€‚ datetimeåž‹ã‚’ç¶æŒã—ãŸã¾ã¾ã§é«˜é€ŸåŒ–ã§ãã¾ã™ã€‚ ä¾‹ãˆã°ã“ã†ã„ã†ã‚¯ã‚¨ãƒªãƒ¼ [sql ruler="true" lang_name="true"] select * from it em wher
nantan 2012/06/14
MySQL

SQL

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

datetime
ãƒªãƒ³ã‚¯
mysqlã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’mysqldumpã‚³ãƒžãƒ³ãƒ‰ã§ãƒ€ãƒ³ãƒ—ã—ã¦ã‚¤ãƒ³ãƒãƒ¼ãƒˆ Â» LandEscape Graphics
This entry was posted on é‡‘æ›œæ—¥, 1æœˆ 8th, 2010 at 16:51 and is filed under blog. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.
nantan 2012/06/14
mysql

mysqldump

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

ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹
ãƒªãƒ³ã‚¯
å³åº§ã«MySQLãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã®ã‚»ãƒƒãƒˆã‚¢ãƒƒãƒ—
As MySQL gains widespread adoption and moves more broadly into the enterprise, ZRM for MySQL addresses the growing need among database administrators to protect their digital assets with a comprehensive backup and recovery solution. ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ã‚½ãƒ•ãƒˆã®ã¿ã‚’ä½¿ã„ã€15åˆ†é–“ã§ã§ãã‚‹MySQLå°‚ç”¨ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚½ãƒ•ãƒˆã®ã‚»ãƒƒãƒˆã‚¢ãƒƒãƒ—ã¨ç¢ºèªã®æ–¹æ³• è‘—ï¼šShailen Patel å•é¡Œç‚¹ MySQL ã«é‡è¦ãªãƒ‡ãƒ¼ã‚¿ã‚’æ ¼ç´ã™ã‚‹ã“ã¨ãŒå¢—ãˆã¦ãã¦ã„ã¾ã™ã€‚MySQLã‚’ä½¿ç”¨ã—ã¦ã„ã‚‹ä¼æ¥ã«ã¨ã£ã¦ãƒ‡ãƒ¼ã‚¿ã®ç´›å¤±ã¯å¤§ããªå•é¡Œã«ãªã‚ŠåŽç›Šã€é¡§å®¢ã€è©•åˆ¤ã‚’è½ã¨ã—ã‹ãã¾ã›ã‚“ã€‚MySQLã®ãƒãƒƒã‚¯ã‚¢ãƒƒ
nantan 2012/02/28
mysql

zrm

ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—

ãƒªã‚¹ãƒˆã‚¢
ãƒªãƒ³ã‚¯
Zmanda Recovery Manager ã‚’è©¦ã—ã¦ã¿ãŸ | Carpe Diem
ä»Šã¾ã§ã€MySQL ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¯è‡ªä½œã® cron ã‚¹ã‚¯ãƒªãƒ—ãƒˆã§ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’ã—ã¦ã„ãŸãŒã€ZRM(Zmanda Recovery Manager) ã¨ã„ã†ä¾¿åˆ©ãã†ãªãƒ„ãƒ¼ãƒ«ã‚’çŸ¥ã£ãŸã®ã§ã€è©¦ã—ã¦ã¿ãŸã€‚ ãã®å‰ã«ã€ç¾åœ¨ã® MySQL ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—çŠ¶æ³ã‚’èª¬æ˜Žã—ã¦ãŠãã€‚æ™®é€šã® MySQL ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’çµ„ã‚“ã ã‚·ã‚¹ãƒ†ãƒ ã§ã€Master ã¨ Slave 1å°ã«ã€ãã‚Œãžã‚Œã«è‡ªä½œã® cron ã‚’ä½¿ã£ã¦ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã—ã¦ã„ã‚‹ã€‚ Master å´: flush logs ã—ãŸã‚ã¨ã€ãƒªãƒ¬ãƒ¼ãƒã‚°ã‚’ rsync ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã—ã¦ä¸€ã‚«æœˆä»¥ä¸Šã®å‰ã®ãƒªãƒ¬ãƒ¼ãƒã‚°ã‚’å‰Šé™¤ã—ã¦ã„ã‚‹ Slave å´: ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’åœæ¢ã—ã¦ã€flush tables ã—ãŸã‚ã¨ /var/lib/mysql ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªä»¥ä¸‹ã‚’ã¾ã¨ã‚ã¦ rsnyc ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— ä»Šã¯ Master å´ã¨ Slave å´ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—æ™‚é–“ã¯ã»ã¼åŒã˜ãªã£ã¦ã„ã‚‹ã“
nantan 2012/02/28
mysql

ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—

ãƒªã‚«ãƒãƒª

ZRM
ãƒªãƒ³ã‚¯
MySQLãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãƒ„ãƒ¼ãƒ« "MySQL ZRM" - 101å›žç›®ã®ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«
MySQLãƒ‡ãƒ¼ã‚¿ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—æ–¹æ³• | OSDN Magazineã«ã¦ç´¹ä»‹ã•ã‚Œã¦ã„ãŸMySQLç”¨ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãƒ„ãƒ¼ãƒ« Zmanda Recovery Manager for MySQL ã‚’ä½¿ã£ã¦ã¿ã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã€‚Zmanda Recovery Manager for MySQLã®ç‰¹å¾´ã¯ä¸Šè¨˜ã®SourceForgeã®è¨˜äº‹ã®ä¸‹ã®æ–¹ã§ç´¹ä»‹ã—ã¦ã„ã‚‹ç®‡æ‰€ã‚’ã”è¦§ãã ã•ã„ã€‚ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« RedHatç³»ç”¨ã§ã¯RPMãƒ•ã‚¡ã‚¤ãƒ«ãŒé…å¸ƒã•ã‚Œã¦ã„ã‚‹ã®ã§wgetã—ã¦ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¾ã™ã€‚ wget http://www.zmanda.com/downloads/community/ZRM-MySQL/2.2/RPM/MySQL-zrm-2.2.0-1.noarch.rpm rpm -ivh MySQL-zrm-2.2.0-1.noarch.rpm Debianç³»ã¯MySQLãƒ‡ãƒ¼ã‚¿ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—æ–¹æ³• | OSDN M
nantan 2012/02/28
mysql

ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—

ZRM
ãƒªãƒ³ã‚¯
MySQLãƒªã‚«ãƒãƒªæ‰‹é † ï¼ˆLINUXç’°å¢ƒ å¼Šç¤¾æŽ¨å¥¨ï¼‰ | æ ªå¼ä¼šç¤¾ãƒ“ãƒ¼ã‚°ãƒƒãƒ‰ãƒ»ãƒ†ã‚¯ãƒŽãƒã‚¸ãƒ¼ï¼ã‚·ã‚¹ãƒ†ãƒ ç›£è¦– ã‚µãƒ¼ãƒç›£è¦– éšœå®³ç›£è¦– é‹ç”¨ç®¡ç† ã‚¤ãƒ³ãƒ•ãƒ©æ§‹ç¯‰ MySQL
nantan 2012/02/28
mysql

ãƒªã‚«ãƒãƒª
ãƒªãƒ³ã‚¯
XtraBackupã‚’ä½¿ã£ã¦MySQLã‚’ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã—ã‚ˆã† | ã•ã¶ã¿ã£ã¨ï¼JAPAN
XtraBackupã¨ã¯ Perconaç¤¾ ãŒé–‹ç™ºã—ã¦ã„ã‚‹ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®MySQLã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãƒ„ãƒ¼ãƒ«ã§ã™ã€‚InnoDB, XtraDBã¨MyISAMã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã‚’ãƒ–ãƒãƒƒã‚¯ã™ã‚‹ã“ã¨ãªããƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’ã™ã‚‹äº‹ãŒå‡ºæ¥ã¾ã™ã€‚ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã¯GPLv2ã§ç„¡æ–™ã§ä½¿ãˆã¾ã™ã€‚ MySQLã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—æ–¹æ³•ã¨ã—ã¦ã‚ˆãä½¿ã‚ã‚Œã¦ã„ã‚‹mysqldumpã¨ã„ã†ãƒ„ãƒ¼ãƒ«ãŒæœ‰ã‚Šã¾ã™ãŒã€ å¤§é‡ã®ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã—ã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‹ã‚‰ãƒ€ãƒ³ãƒ—ã—ãŸãƒ‡ãƒ¼ã‚¿ã‚’ãƒªã‚¹ãƒˆã‚¢ï¼ˆå¾©æ—§ï¼‰ã™ã‚‹æ™‚ã«éžå¸¸ã«æ™‚é–“ãŒæŽ›ã‹ã£ã¦ã—ã¾ã†ã¨ã„ã†æ¬ ç‚¹ãŒã‚ã‚Šã¾ã™ã€‚ ã“ã“ã§ã¯ã€mysqldumpã¨XtraBackupã‚’ä½¿ã£ã¦ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’å–ã‚Šã€ä¸¡è€…ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¨ãƒªã‚¹ãƒˆã‚¢ã®ã‚¹ãƒ”ãƒ¼ãƒ‰ã®é•ã„ã‚’æ¯”è¼ƒã—ã¦ã¿ã¾ã™ã€‚ ä½¿ç”¨ã™ã‚‹ã‚µãƒ¼ãƒã¯ä»¥ä¸‹ã®é€šã‚Šã§ã™ ã‚µãƒ¼ãƒ ã•ãã‚‰ã®ã‚¯ãƒ©ã‚¦ãƒ‰ã€€ãƒ—ãƒ©ãƒ³8ã€€CPUä»®æƒ³4ã‚³ã‚¢ã€€ãƒ¡ãƒ¢ãƒª24GBã€€HDD100GB OS CentOS 5.7 64bit M
nantan 2012/02/02
mysql

ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—
ãƒªãƒ³ã‚¯
Windows 7(64bit) + MySQL 5.1 (64bit) ã§ gem mysql ã§ã‚¨ãƒ©ãƒ¼ãŒå‡ºãŸã¨ãã®å¯¾å‡¦æ³• - Yaks
Windows 7(64bit) + MySQL 5.1 (64bit) ã§ gem mysql ã§ã‚¨ãƒ©ãƒ¼ãŒå‡ºãŸã¨ãã®å¯¾å‡¦æ³• ã‚¿ã‚¤ãƒˆãƒ«ã®ç’°å¢ƒã§ã€Œæœ‰åŠ¹ãª 32bit ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ã¯ãªã„ã€ã¿ãŸã„ãªã‚¨ãƒ©ãƒ¼ãŒå‡ºã‚‹æ™‚ã®å¯¾å‡¦æ³•ãƒ¡ãƒ¢ã€‚ 32bit ç‰ˆã® MySQL ãªã‚‰ã°ã€[MySQL path]\bin é…ä¸‹ã® libmySQL.dll ã‚’ [ruby path]\bin ã«æ”¾ã‚Šè¾¼ã‚ã°ã„ã„ã‚‰ã—ã„ã®ã ã‘ã©ã€ãã‚Œã§ã‚‚å‹•ã‹ãªã„ã€‚ã§èª¿ã¹ã‚‹ã¨ä»¥ä¸‹ã®ãƒšãƒ¼ã‚¸ã‚’ç™ºè¦‹ã€‚ MySQL driver for Rails in Windows 7 x64 - Stack Overflow: ã©ã†ã‚„ã‚‰ã€InstantRails ã«å«ã¾ã‚Œã‚‹ libmySQL.dll ã‚’ä½¿ãˆã°ã„ã„ã‚‰ã—ã„ã€‚ ã“ã“ã‹ã‚‰ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰å¯èƒ½ã€‚(InstantRails ã® SVN) ãŠãã‚‰ãã€MySQL ã« dll ã‚‚ 64bitãƒã‚¤ãƒŠãƒªãªã®ãŒåŽŸå› ã‹
nantan 2011/09/09
"Windows 7(64bit) + MySQL 5.1 (64bit) ã§ gem mysql ã§ã‚¨ãƒ©ãƒ¼ãŒå‡ºãŸã¨ãã®å¯¾å‡¦æ³• - Yaks"

èªã‚“ã

ruby

mysql
ãƒªãƒ³ã‚¯
Macã§gem install mysqlã‚’ã™ã‚‹æ–¹æ³•
Rails2.2ã‹ã‚‰mysqlã®ã‚¢ãƒ€ãƒ—ã‚¿ãŒä»˜å±žã—ã¦ã„ãªã„ã®ã§å„å€‹äººã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚gemã§å…¥ã‚Œã‚ˆã†ã¨ã™ã‚‹ã¨ã‚¨ãƒ©ãƒ¼ãŒã§ã‚‹ã¨æ€ã†ã®ã§ä»¥ä¸‹ã®ã‚ˆã†ã«å¯¾å¿œã—ã¦ãã ã•ã„ã€‚ $ sudo gem install mysql $ cd /opt/local/lib/ruby/gems/1.8/gems/mysql-2.7/ $ sudo ruby extconf.rb --with-mysql-config=/opt/local/lib/mysql5/bin/mysql_config $ sudo make $ sudo make install ãƒ‘ã‚¹ã«é–¢ã—ã¦ã¯ã€äººã«ã‚ˆã£ã¦é•ã†ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ãŒé©å®œèªã¿æ›¿ãˆã¦ãã ã•ã„ã€‚ è¿½è¨˜ $ sudo gem install mysql -- --with-mysql-config=/opt/local/lib/mysql5/bin/mysql_con
nantan 2011/06/08
ruby

gem

install

mysql
ãƒªãƒ³ã‚¯
ã•ãã‚‰ã‚µãƒ¼ãƒãƒ¼ã« gem ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹éš›ã«ã€Œchown/chgrp: Operation not permittedã€ã¨ã‚¨ãƒ©ãƒ¼ãŒå‡ºãŸå ´åˆ - make world
åŽŸå› ã¯ã€ŒENV['RB_USER_INSTALL']ã€ã«å€¤ãŒæ£ã—ãè¨å®šã•ã‚Œã¦ã„ãªã„ãŸã‚ã§ã‚ã‚‹ã€‚ Ruby/MySQL ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ % gem search --remote mysql *** REMOTE GEMS *** activerecord-jdbcmysql-adapter (0.9) dbd-mysql (0.4.2) do_mysql (0.9.9) jdbc-mysql (5.0.4) motto-mysql (0.1.0) mysql (2.7.3, 2.7) mysql_replication_adapter (0.4.0) mysql_retry_lost_connection (0.0.1) ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã‚’é–‹å§‹ã™ã‚‹ % gem install mysql Building native extensions. This could take a while
nantan 2011/06/07
ruby

ã•ãã‚‰ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆ

mysql
ãƒªãƒ³ã‚¯
http://www.kadoppe.net/archives/2010/01/mysql%E3%81%AEroot%E3%83%91%E3%82%B9%E3%83%AF%E3%83%BC%E3%83%89%E3%82%92%E5%BF%98%E3%82%8C%E3%81%A6%E3%81%97%E3%81%BE%E3%81%A3%E3%81%9F%E6%99%82%E3%81%AE%E5%AF%BE%E5%87%A6%E6%B3%95.html
nantan 2011/06/05
mysql

root

ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰
ãƒªãƒ³ã‚¯
1 2 3 æ¬¡ã®ãƒšãƒ¼ã‚¸