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

okosou id:okosou

mysqlã«é–¢ã™ã‚‹okosouã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

mysqldump ã®çµæžœã‚’ãã®ã¾ã¾åœ§ç¸®ã—ãŸã‚Šè»¢é€ã—ãŸã‚Šã™ã‚‹ã‚³ãƒžãƒ³ãƒ‰ä¾‹ | ãƒã‚·ãƒ£ãƒã‚°ã€‚
ã¡ã‚‡ã£ã¨é…ã‚ã®å¤ä¼‘ã¿ã‚’ã‚‚ã‚‰ã£ã¦å…«ä¸ˆå³¶ã«è¡Œã£ã¦ãã¾ã—ãŸ nakamura ã§ã™ï¼ã„ã„æ‰€ã™ãŽã¦å±ã†ããã®ã¾ã¾ç§»ä½ã™ã‚‹ã¨ã“ã‚ã§ã—ãŸã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ç§»è¡Œã‚’ã™ã‚‹éš›ã¿ãªã•ã‚“ã©ã‚“ãªæµã‚Œã§ä½œæ¥ã—ã¦ã„ã‚‹ã§ã—ã‚‡ã†ã‹ã€‚ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ã§ãƒ€ãƒ³ãƒ—ã‚’å–ã£ã¦ã€ã‚µã‚¤ã‚ºãŒå¤§ãã‹ã£ãŸã‚‰ gzip ã§åœ§ç¸®ã—ã¦ã€WinSCP ã§ãã‚Œã‚’ãƒãƒ¼ã‚«ãƒ«ã«è½ã¨ã—ã¦ãã¦ã€ãã‚Œã‚’ã¾ãŸåˆ¥ã®ã‚µãƒ¼ãƒã«ã‚¢ãƒƒãƒ—ãƒãƒ¼ãƒ‰ã—ã¦ãƒ»ãƒ»ãƒ»ãƒ»ãªã‚“ã¦äº‹ã—ã¦ãŸã‚Šã—ã¾ã›ã‚“ã‹ï¼Ÿ ã‚·ã‚§ãƒ«ã®ãƒ‘ã‚¤ãƒ—ã‚„ãƒªãƒ€ã‚¤ãƒ¬ã‚¯ãƒˆã‚’ã†ã¾ãä½¿ã£ã¦ã‚ã’ã‚Œã°ã€ã“ã®è¾ºã‚Šã¯ã‚³ãƒžãƒ³ãƒ‰ä¸€ç™ºã§ã„ã‘ã¡ã‚ƒã£ãŸã‚Šã™ã‚‹ã®ã§ã™ã€‚ä»Šæ—¥ã¯ãã‚“ãªã‚³ãƒžãƒ³ãƒ‰ä¾‹ã®ã”ç´¹ä»‹ã§ã™ã€‚ å®Ÿéš›ã«ã‚ˆãä½¿ã†ã‚³ãƒžãƒ³ãƒ‰ã®ä¾‹ã‚’ç®‡æ¡æ›¸ãã§ã€‚ ã¨ã‚Šã‚ãˆãšãƒ€ãƒ³ãƒ—ã®çµæžœã‚’ãã®ã¾ã¾åœ§ç¸®ã™ã‚‹ã€‚ mysqldump -udb_user db_name -pdb_pass | gzip > db_name.dump.sql.gz ç‰¹å®šã®æ–‡å—åˆ—ã‚’ç½®æ›ã—ãŸä¸Šã§åœ§ç¸®ã™ã‚‹ã€‚ MT
okosou 2010/09/30
mysql
ãƒªãƒ³ã‚¯
Zen-Cartæ–‡å—åŒ–ã‘ã—ãŸå ´åˆã®èª¿æ•´ at faq.infolinux.jp
okosou 2009/06/15
æ–‡å—åŒ–ã‘

ecommerce

mysql

php
ãƒªãƒ³ã‚¯
[è§£æ±º]æ–‡å—åŒ–ã‘ï¼ˆè£œè¶³ãƒšãƒ¼ã‚¸ï¼‰ | Words in the WWW
okosou 2009/06/14
ecommerce

mysql

php
ãƒªãƒ³ã‚¯
XAMPPã§ã®ã‚¨ãƒ©ãƒ¼
MySQLã®rootã«ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’è¨å®šã—ã¦ã„ã¾ã›ã‚“ã‹ï¼Ÿã€€æ¨™æº–ã§ã¯ã€phpMyAdminã¯ã€rootãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ãªã—ã§ãƒã‚°ã‚¤ãƒ³ã‚’è¡Œã„ã¾ã™ã®ã§ã€ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ãŒè¨å®šã•ã‚Œã¦ã„ã‚‹ã¨ãƒã‚°ã‚¤ãƒ³ã«å¤±æ•—ã—ã¾ã™ã€‚ XAMPPã®phpmyadminã®ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªå†…ã«ã€config.inc.phpã¨ã„ã†ãƒ•ã‚¡ã‚¤ãƒ«ãŒã‚ã‚Šã¾ã™ã€‚ã“ã‚Œã‚’é–‹ãã€ä»¥ä¸‹ã®è¡Œã‚’æ¤œç´¢ã—ã¦ãƒã‚°ã‚¤ãƒ³ã™ã‚‹ãƒ¦ãƒ¼ã‚¶åã¨ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã®å€¤ã‚’å¤‰æ›´ã—ã¦ãã ã•ã„ã€‚ $cfg['Servers'][$i]['user'] = 'root'; // MySQL user $cfg['Servers'][$i]['password'] = ''; // MySQL password ã“ã®å›žç”ã¸ã®è£œè¶³ ãŠè¿”äº‹ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ configinc.phpã‚’ç¢ºèªã—ãŸã¨ã“ã‚å•é¡Œã¯ãªã„ã‚ˆã†ã«æ€ã†ã®ã§ã™ãŒè‡ªä¿¡ãŒãªã„ã‚‚ã®ã§å‚è€ƒã«ã‚½ãƒ¼ã‚¹ã‚’è¼‰ã›ã¦ã¿ã¾ã™ã€‚ 71ï½ž73è¡Œç›®ã¯ $cfg['Ser
okosou 2009/06/14
phpMyadmin

mysql

server
ãƒªãƒ³ã‚¯
WordPressã®DBã®wp_postsãŒã‚¯ãƒ©ãƒƒã‚·ãƒ¥ã—ãŸæ™‚ã®ä¿®å¾©æ–¹æ³•
WordPressã®DBã®wp_postsã®ãƒ†ãƒ¼ãƒ–ãƒ«ãŒã‚¯ãƒ©ãƒƒã‚·ãƒ¥ã—ã¦ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã®ã™ã¹ã¦ãŒé–²è¦§ã§ããªããªã£ã¦ã—ã¾ã„ã¾ã—ãŸã€‚ â€»ç¾åœ¨ã¯ä¿®å¾©æ¸ˆã¿ãªã®ã§ã€é€šå¸¸é€šã‚Šé–²è¦§ã§ãã¾ã™ã€‚ ä¸‹è¨˜ã®ã‚µã‚¤ãƒˆã‚’å‚è€ƒã«å¾©æ´»ã§ãã¦è‰¯ã‹ã£ãŸã§ã™ã€‚ MySQLã®ãƒ†ãƒ¼ãƒ–ãƒ«ä¿®å¾© å®Ÿæ–½ã—ãŸä¿®å¾©æ–¹æ³•ã¯ã€ä¸‹è¨˜ã®æ‰‹é †ã§ã™ã€‚ phpMyAdmin ã«ã‚¢ã‚¯ã‚»ã‚¹ã€‚ è©²å½“ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã€Œæ§‹é€ ã€ã«ã‚¢ã‚¯ã‚»ã‚¹ã€‚ ã€Œwp_postsã€ã®ãƒã‚§ãƒƒã‚¯ãƒœãƒƒã‚¯ã‚¹ã‚’ãƒã‚§ãƒƒã‚¯ã€‚ â€»æŽ¥é ï¼ˆwpï¼‰ã¯å„è‡ªã®è¨å®šã«åˆã‚ã›ã¦ãã ã•ã„ã€‚ ãƒšãƒ¼ã‚¸ä¸‹ã®ã€Œãƒã‚§ãƒƒã‚¯ã—ãŸã‚‚ã®ã‚’ã€ã‹ã‚‰ã€ã€Œãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä¿®å¾©ã™ã‚‹ã€ã‚’é¸æŠžã€‚
okosou 2009/04/30
wordpress

mysql
ãƒªãƒ³ã‚¯
MySQLã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«
ç¾åœ¨ MySQL ã¯ MySQL Enterprise Edition ã¨ MySQL Community Server ã®2ã¤ã®ã‚¿ã‚¤ãƒ—ãŒã‚ã‚Šã¾ã™ã€‚ MySQL Enterprise ã¯å•†ç”¨ç‰ˆã® MySQL ã¨ãªã‚Šã‚ªãƒ•ã‚£ã‚·ãƒ£ãƒ«ã‚µãƒãƒ¼ãƒˆã®æä¾›ã‚„ç®¡ç†ãƒ„ãƒ¼ãƒ«ãŒä»˜éšã—ã¦ãã¾ã™ã€‚ã“ã‚Œã«å¯¾ã—ã¦ MySQL Community Server ã¯ å¾“æ¥é€šã‚Šã®ç„¡å„Ÿãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ãªã‚Šã¾ã™ã€‚ã“ã“ã§ã¯ MySQL Community Server ã®æœ€æ–°ç‰ˆã®ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰æ–¹æ³•åŠã³ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ–¹æ³•ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚
okosou 2008/05/18
mysql
ãƒªãƒ³ã‚¯
ã•ãã‚‰ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆã§mysqlã®è‡ªå‹•ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— | ãƒ©ãƒ³ã‚µãƒ¼ã‚ºç¤¾é•·æ—¥è¨˜
ã„ã„ãï¼ 4 ãƒ„ã‚¤ãƒ¼ãƒˆ B! ã¯ã¦ãƒ– 185 Pocket 22 ã•ãã‚‰ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆã®ãƒ¬ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒãƒ¼ã¯éžå¸¸ã«é«˜æ©Ÿèƒ½ãªã‚“ã§ã™ãŒã€ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—æ©Ÿèƒ½ã ã‘ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ï¼ˆç§ãŒç¢ºèªã™ã‚‹é™ã‚Šã€‚ï¼‰ HTMLã‚„GIFã€PHPãªã©ã®ãƒ•ã‚¡ã‚¤ãƒ«ã¯ãƒãƒ¼ã‚«ãƒ«ã®PCã§æŒã£ã¦ã„ã‚‹ã‹ã‚‰å¤§æŠµã¯å¤§ä¸ˆå¤«ã ã¨ã—ã¦ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç³»ã¯é–“é•ã£ã¦å…¨éƒ¨æ¶ˆã—ã¦ã—ã¾ã£ãŸæ—¥ã«ã¯ç›®ã‚‚å½“ã¦ã‚‰ã‚Œã¾ã›ã‚“ã€‚ã€‚å®šæœŸçš„ã«ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’å–ã‚‹ã‚ˆã†ã«ã—ã¦ã„ã¾ã™ãŒã€å¿˜ã‚Œã‚‹ã“ã¨ã‚‚ã‚ˆãã‚ã‚‹ã®ã§ã€è‡ªå‹•ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’cronã«ç™»éŒ²ã—ã¨ãã¾ã—ãŸã€‚ ã‚ˆãã‚ã‚‹ã‚¹ã‚¯ãƒªãƒ—ãƒˆã§ã™ãŒã€å‚è€ƒã¾ã§ã«å¼µã£ã¦ãŠãã¾ã™ã€‚3æ—¥é–“åˆ†ã®MYSQLã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ã‚¿ã‚’ä¿æŒã—ã¾ã™ã€‚mysqlã®ID/PWãªã©ã¯æ›¸ãæ›ãˆã¦ä¸‹ã•ã„ã€‚ ä½•ã‚‚ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãªã‚“ã¦ã—ã¦ãªã„ï¼ã¨ã„ã†äººã¯ã€è‡ªå·±è²¬ä»»ã§ä½¿ã£ã¦ã¿ã¦ä¸‹ã•ã„ã€‚ #!/bin/sh PATH=/bin:/usr/bin:/sbin:/usr/sbin:/
okosou 2007/08/11
mysql
ãƒªãƒ³ã‚¯
netatalkãƒ»ãƒ•ã‚¡ã‚¤ãƒ«å…±æœ‰è¬›åº§ | netatalkè¬›åº§ [Smart]
å››è§’ã®æž ã«å›²ã£ã¦ã‚ã‚‹æ®µè½ã§ã€> ã¨ã„ã†ãƒžãƒ¼ã‚¯ã¯å‡ºåŠ›è¡Œã€ã‚‚ã—ãã¯ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ã‚’æ„å‘³ã—ã¾ã™ã€‚ ä¾‹ print "Hello\n"; > Hello è¬è¾ž ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆã®ãŠã‹ã’ã§ç„¡æ–™ã§å‹‰å¼·ã§ãã€ãƒ—ãƒã‚°ãƒ©ãƒ ã®ä»•äº‹ã‚’ã™ã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã€‚ã¨ã¦ã‚‚æ„Ÿè¬ã§ã™ã€‚ãã®ãŠè¿”ã—ã¨ã„ã†ç¨‹ã§ã‚‚ã‚ã‚Šã¾ã›ã‚“ãŒã€å‹‰å¼·ã®æˆæžœã‚’å…¬é–‹ã™ã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã€‚ ã“ã®è¬›åº§ã«æŽ²è¼‰ã—ãŸæƒ…å ±ã®ã™ã¹ã¦ã¯ã€ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆã‹ã‚‰ã‹ãé›†ã‚ãŸã‚‚ã®ãŒå¤§åŠã§ã™ã€‚ãã®æƒ…å ±ãŒæ£ã—ã„ã‚‚ã®ã‹ã©ã†ã‹ã¯ç¢ºã‹ã‚ãŸã®ã§ã™ãŒã€ãã‚Œã¯ã¡ã‚‡ã£ã¨æ€ªã—ã„ã‚‚ã®ã§ã™ã®ã§ã€é–“é•ã„ã‚„èª¤è§£ãªã©ãŒå«ã¾ã‚Œã¦ã„ã‚‹å¯èƒ½æ€§ãŒã‚ã‚Šã¾ã™ã€‚ ã¨ã„ã†ã“ã¨ã§ã€ã¡ã‚‡ã£ã¨ãŠã‹ã—ã„ãªã¨æ€ã£ãŸã‚‰ã”å ±å‘ŠãŠé¡˜ã„ã—ã¾ã™ã€‚ æ¬¡ã«ã“ã®è¬›åº§ã«ããŸã¨ãã¯ã€ãŸã ã—ã„æ–‡ç« ãŒæŽ²è¼‰ã•ã‚Œã¦ã„ã‚‹ã¨æ€ã„ã¾ã™ã€ãŸã¶ã‚“ã€‚
okosou 2007/07/06
mysql
ãƒªãƒ³ã‚¯
1