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

stingray id:stingray

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

${{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ã‚’æ“ä½œã™ã‚‹ã€ŒMySQL Quick Adminã€ãŒã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹åŒ–
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã‚ã‚‹MySQLã‚’æ“ä½œã™ã‚‹ã€ŒMySQL Quick Adminã€ãŒã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹åŒ–ã•ã‚Œã€èª°ã§ã‚‚è‡ªç”±ã«ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¦ä½¿ã†ã“ã¨ãŒã§ãã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã€‚åå‰ã®é€šã‚Šã€é«˜é€Ÿã«å‹•ä½œã™ã‚‹ã®ãŒã‚¦ãƒªã ãã†ã§ã€‚ ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã¯ä¸‹è¨˜ã‚µã‚¤ãƒˆã‹ã‚‰ã€‚ MySQL Quick Admin http://mysqlquickadmin.com/index.php æ©Ÿèƒ½ã‚„å¿…è¦ãªãƒ¢ãƒŽã¯ä»¥ä¸‹ã®é€šã‚Šã€‚ Feature Listãƒ»Requirements http://mysqlquickadmin.com/features.php ãƒ‡ãƒ¢ã«ã¯ä»¥ä¸‹ã‹ã‚‰ãƒã‚°ã‚¤ãƒ³ã§ãã¾ã™ã€‚ MySQL Quick Admin Demo http://demo.mysqlquickadmin.com/login.php åŒæ§˜ã®ã“ã¨ãŒã§ãã‚‹æœ‰åã©ã“ã‚ã¯ä»¥ä¸‹ã®é€šã‚Šã€‚ phpMyAdmin | MySQL Database Administra
stingray 2006/07/28
mysql
ãƒªãƒ³ã‚¯
ç¾å ´æŒ‡å‘ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³è©³èª¬
ã“ã®æ–‡æ›¸ã¯ã€æŠ€è¡“è©•è«–ç¤¾åˆŠã€ŽWEB+DB PRESS Vol.22ã€ã«åŸ·ç†ã—ãŸè¨˜äº‹ã‚’æŠ€è¡“è©•è«–ç¤¾ã® è¨±å¯ã‚’å¾—ã¦WWWã§å…¬é–‹ã—ã¦ã„ã‚‹ã‚‚ã®ã§ã™ã€‚ ã“ã®WWWç‰ˆã¯æ ¡æ£å‰ã®åŽŸç¨¿ã‚’å…ƒã«ã—ã¦ã„ã‚‹ç‚¹ã€WWWå…¬é–‹å¾Œã«å¿…è¦ãŒã‚ã‚Œã°ä¿®æ£ã™ã‚‹ç‚¹ã§ã€é›‘èªŒç‰ˆã®æ–‡ç« ã¨ã¯ç•°ãªã‚‹éƒ¨åˆ†ãŒã‚ã‚Šã¾ã™ã€‚ã¾ãŸã€å›³è¡¨ã‚‚é›‘èªŒç‰ˆã¨ã¯ç•°ãªã‚Šã¾ã™ã€‚ äºˆã‚ã”äº†æ‰¿ãã ã•ã„ã€‚ ã¾ãŸã€ã“ã®æ–‡ç« ãŒå¯¾è±¡ã—ã¦ã„ã‚‹ã®ã¯MySQL 4.0ç³»ãªã®ã§ã€æœ€æ–°ã®ãƒªãƒªãƒ¼ã‚¹ç‰ˆã¨æ¯”ã¹ã‚‹ã¨èª¬æ˜Žä¸è¶³ãªç‚¹ãªã©ãŒå¤šã€…ã‚ã‚‹ã¨æ€ã„ã¾ã™ã€‚ ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®åŸºæœ¬ã‚’ãŠã•ãˆã‚‹ã«ã¯ã€ã“ã®æ–‡æ›¸ã¯ã¾ã æœ‰ç›Šã ã¨æ€ã„ã¾ã™ãŒã€è¨å®šãƒ¬ãƒ™ãƒ«ã®èª¬æ˜Žã¯æœ€æ–°ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚’å‚ç…§ã™ã‚‹ã‚ˆã†ã«ã—ã¦ãã ã•ã„ã€‚
stingray 2005/09/26
mysql

db
ãƒªãƒ³ã‚¯
http://dev.mysql.com/doc/mysql/ja/old-client.html
stingray 2005/06/21
4.1*ã§ã¯ã‚¹ãƒ¯ãƒ¼ãƒ‰ãƒãƒƒã‚·ãƒ¥ã‚¢ãƒ«ã‚´ãƒªã‚ºãƒ ã«ä¸‹ä½äº’æ›æ€§ãŒãªã„ï¼ï¼

MySQL
ãƒªãƒ³ã‚¯
http://jp.xoops.org/modules/newbb/viewtopic.php?forum=11&topic_id=5912
stingray 2005/06/21
4.1.7 ã§ã®å¯¾å¿œã«ã¤ã„ã¦

XOOPS

MySQL
ãƒªãƒ³ã‚¯
http://tsuttayo.sytes.net/mysql/setting/
stingray 2005/06/20
ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«ã¤ã„ã¦

MySQL
ãƒªãƒ³ã‚¯
http://jp.xoops.org/modules/newbb/viewtopic.php?viewmode=flat&topic_id=8085&forum=14
stingray 2005/06/20
MySQLã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«é–¢ã—ã¦

XOOPS

MySQL

memo
ãƒªãƒ³ã‚¯
MySQLã‚¯ã‚¤ãƒƒã‚¯ãƒ»ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹
ã“ã®æ–‡æ›¸ã¯ã€osCommerceã§ä½¿ç”¨ã—ã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹MySQLã®åŸºæœ¬çš„ãªä½¿ã„æ–¹ã«ã¤ã„ã¦è§£èª¬ã—ã¦ã„ã¾ã™ã€‚ãŠã‚‚ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ç®¡ç†è€…ã‚ˆã‚Šã‚‚ã€ãƒ¦ãƒ¼ã‚¶ã«å‘ã‘ã¦æ›¸ã‹ã‚Œã¦ã„ã¾ã™ã€‚ ã¯ã˜ã‚ã« ã“ã“ã§ã¯ã€MySQLã‚µãƒ¼ãƒã¯èµ·å‹•ã—ã¦ã„ã‚‹ã‚‚ã®ã¨ã—ã¦èª¬æ˜Žã—ã¾ã™ã€‚ MySQLã®æ–‡å—ã«ã¤ã„ã¦ MySQLã§ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åã‚„ãƒ†ãƒ¼ãƒ–ãƒ«åã®å¤§æ–‡å—ã¨å°æ–‡å—ã‚’åŒºåˆ¥ã—ã¦ã„ã¾ã™ã€‚ãã‚Œä»¥å¤–ã¯åŒºåˆ¥ã—ã¾ã›ã‚“ã€‚ MySQLã®ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰åã‚„ãƒ†ãƒ¼ãƒ–ãƒ«åã«ä½¿ãˆã‚‹æ–‡å—ã¯ã€è‹±æ•°å—ã¨_ï¼ˆã‚¢ãƒ³ãƒ€ãƒ¼ãƒãƒ¼ï¼‰ã€$ã€ã‚µãƒ¼ãƒã®ã‚ãƒ£ãƒ©ã‚¯ã‚¿ã‚»ãƒƒãƒˆã«ã‚ã‚‹æ–‡å—ã§ã™ã€‚ çŸ¥ã£ã¦ãŠããŸã„ã‚³ãƒžãƒ³ãƒ‰ mysqladminï¼ˆãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä½œæˆãƒ»å‰Šé™¤ã‚„ã€MySQLã‚µãƒ¼ãƒã®æƒ…å ±ã‚’å¾—ã‚‹ï¼‰ mysqlshowï¼ˆãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã®æƒ…å ±ã‚’è¡¨ç¤ºã™ã‚‹ï¼‰ mysqlï¼ˆMySQLã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã®èµ·å‹•ï¼‰ mysqldumpï¼ˆãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ãƒ€ãƒ³ãƒ—ã™ã‚‹ï¼‰ myisamchkï¼ˆãƒ†ãƒ¼ãƒ–ãƒ«
stingray 2005/06/02
ã‚«ãƒ©ãƒ ã‚’æŒ‡å®šã—ã¦æ›´æ–°ã™ã‚‹ã“ã¨ãŒå¯èƒ½

mysql
ãƒªãƒ³ã‚¯
http://www.softagency.co.jp/mysql/TIPS/one_way_replication.html
stingray 2005/04/28
MySQL
ãƒªãƒ³ã‚¯
1