[B! æ–‡å—åŒ–ã‘] love210ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

love210 id:love210

æ–‡å—åŒ–ã‘ã«é–¢ã™ã‚‹love210ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

hori-uchi.com: mysqldumpã§æ–‡å—åŒ–ã‘ã—ãªã„ãŸã‚ã®ãƒ¡ãƒ¢
ãƒãƒ¼ã‚«ãƒ«ã®é–‹ç™ºç’°å¢ƒã§ä½¿ã£ã¦ã„ãŸMySQLãªã‚“ã§ã™ãŒã€ä½•ã‚‚è€ƒãˆãšãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®è¨å®šã§ä½¿ã£ã¦ã„ãŸã‚‰ã€mysqldumpã—ãŸéš›ã«ã€ãƒ‡ãƒ¼ã‚¿ãŒæ–‡å—åŒ–ã‘ã—ã¦ã€ã¡ã‚‡ã£ã¨ã¯å¾…ã£ãŸã®ã§ãƒ¡ãƒ¢ã€‚ MySQLã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯4.1.20ã€‚ æ–‡å—åŒ–ã‘ã™ã‚‹åŽŸå› ã¯ã€mysqldumpãŒãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ã¯ã€æ–‡å—ã‚³ãƒ¼ãƒ‰ã‚’UTF-8ã§å‡ºåŠ›ã™ã‚‹ã‚ˆã†ã«ãªã£ã¦ã„ã¦ã€ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã®åž‹ãŒUTF-8ã§ãªã„å ´åˆã¯ã€è‡ªå‹•ã§UTF-8ã«å¤‰æ›ã™ã‚‹ãŸã‚ã®ã‚ˆã†ã§ã™ã€‚ åƒ•ãŒä½¿ã£ã¦ã„ãŸDBã¯æ–‡å—ã‚³ãƒ¼ãƒ‰ã«ã¤ã„ã¦ç‰¹ã«ä½•ã‚‚è¨å®šã—ã¦ã„ãªã‹ã£ãŸã®ã§ã€ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®æ–‡å—ã‚³ãƒ¼ãƒ‰ã§ã‚ã‚‹latin1ã«ãªã£ã¦ã„ã¾ã—ãŸã€‚ ãªã®ã§ã€ã“ã‚Œã‚‚mysqldumpã™ã‚‹ã¨lain1 -> UTF-8ãªå¤‰æ›ãŒè‡ªå‹•ã§è¡Œã‚ã‚Œæ–‡å—åŒ–ã‘ã—ãŸã¨ã„ã†ã“ã¨ã®ã‚ˆã†ã§ã™ã€‚ç´å¾—ã€‚ ã“ã®è‡ªå‹•å¤‰æ›ã‚’è¡Œã‚ãªã„ã‚ˆã†ã«ã™ã‚Œã°è§£æ±ºã™ã‚‹ã¯ãšã€‚ã¨ã„ã†ã“ã¨ã§èª¿ã¹ã¦ã¿ã‚‹ã¨ã€--default-character-setã¨ã„ã†ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚’ä½¿
love210 2008/06/17
mysql

æ–‡å—åŒ–ã‘
ãƒªãƒ³ã‚¯
MySQL æ–‡å—åŒ–ã‘å•é¡Œã‚’æœ¬æ°—ã§ç›´ã™
mysql> status; -------------- mysql Ver 14.7 Distrib 4.1.20, for redhat-linux-gnu (i386) using readline 4.3 Connection id: 36 Current database: staff2006 Current user: maiha@localhost SSL: Not in use Current pager: lv Using outfile: '' Using delimiter: ; Server version: 4.1.20 Protocol version: 10 Connection: Localhost via UNIX socket Server characterset: latin1 Db characterset: latin1 Client char
love210 2008/05/16
mysql

æ–‡å—åŒ–ã‘
ãƒªãƒ³ã‚¯
è‡ªåˆ†ã®ã‚µã‚¤ãƒˆã§åˆ©ç”¨ã—ã¦ã„ã‚‹ãƒ¬ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒã‚’XREAã‹ã‚‰sakuraã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆã«ç§»ãã†ã¨æ€ã£ã¦ã„ã¾ã™ã€‚â€¦
è‡ªåˆ†ã®ã‚µã‚¤ãƒˆã§åˆ©ç”¨ã—ã¦ã„ã‚‹ãƒ¬ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒã‚’XREAã‹ã‚‰sakuraã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆã«ç§»ãã†ã¨æ€ã£ã¦ã„ã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦MySQLã‚’åˆ©ç”¨ã—ã¦ã„ã‚‹ã®ã§ã™ãŒã€ã“ã‚Œã‚’phpMyAdminã‹ã‚‰ã€sqlå½¢å¼ã§ã€XREAã§ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã€ãã—ã¦ã€sakuraã«ã‚¤ãƒ³ãƒãƒ¼ãƒˆã™ã‚Œã°ã€å•é¡Œç„¡ã„ã¨è€ƒãˆã¦ã„ã¾ã—ãŸã€‚ ã¨ã“ã‚ãŒã€sakuraã«ã‚¤ãƒ³ãƒãƒ¼ãƒˆã—ã¦è¦‹ã¦ã¿ã¾ã™ã¨æ–‡å—åŒ–ã‘ã—ã¦ã—ã¾ã„ã¾ã—ãŸã€‚ XREAã§è‡ªåˆ†ã®ãƒ‘ã‚½ã‚³ãƒ³ã«ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã—ãŸsqlãƒ•ã‚¡ã‚¤ãƒ«ã¯æ—¥æœ¬èªžéƒ¨åˆ†ã¯æ™®é€šã«è¦‹ã‚‹ã“ã¨ãŒå‡ºæ¥ã¦ã„ã¾ã™ã€‚ã¨ã„ã†ã“ã¨ã¯ã€sakuraã«ã‚¤ãƒ³ãƒãƒ¼ãƒˆæ™‚ã®ä¸å…·åˆãªã®ã§ã—ã‚‡ã†ã‹ï¼Ÿ ã¡ãªã¿ã«ã€MySQLã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯ã€ã©ã¡ã‚‰ã®ãƒ¬ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒã‚‚4.0ç³»ã§ã™ã€‚ æ”¹å–„ã™ã‚‹æ–¹æ³•ã‚’ã”å˜çŸ¥ã®æ–¹ãŒã„ã¾ã—ãŸã‚‰ã€ãœã²æ•™ãˆã¦ã„ãŸã ã‘ãªã„ã§ã—ã‚‡ã†ã‹ï¼Ÿ
love210 2008/05/10
mysql

æ–‡å—åŒ–ã‘
ãƒªãƒ³ã‚¯
hiromasa.zone :o) Â» æ–‡å—ã‚³ãƒ¼ãƒ‰ã«å±ˆã™ã‚‹
ã©ã†ã‚‚æœ€è¿‘è»Ÿå¼±ã«ãªã£ãŸã‚‚ã®ã§ã€ã‚¹ãƒ‘ãƒ ã°ã£ã¡ã“ã„ãã‚‰ã„ã®å‹¢ã„ã ã£ãŸã®ã¯ã„ã¤ã®ã“ã‚ã‚„ã‚‰ã€æœ€è¿‘ã¯ Akismet ã‚’ã„ã‚Œã¦å¹³ç©ãªæ—¥ã€…ã‚’ã™ã”ã—ã¦ã„ã‚‹ã²ã‚ã¾ã•ã§ã™ã€‚ã€€ãã—ã¦ä»Šæ—¥ã¯æ–‡å—ã‚³ãƒ¼ãƒ‰å•é¡Œã«å±ˆã—ã¾ã—ãŸã€‚ ðŸ˜³ hiromasa.zone ã¯ Shift_JIS ã§ã‹ã‹ã‚Œã¦ã„ã‚‹ã®ã§ã™ãŒã€ã©ã†ã‚‚ WP 2.0 ç³»ã«ã—ã¦ã‹ã‚‰èª¿åãŒæ‚ªã„ã€‚ã€€å…·ä½“çš„ã«ã„ã†ã¨ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ã‚¹ã‚±ãƒ¼ãƒ— (â€˜ ã¨ã‹ \ ã¨ã‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ç›´æŽ¥å…¥ã‚Œã‚‰ã‚Œãªã„æ–‡å—ã‚’å¤‰æ›ã—ã¦å…¥ã‚Œã‚‹ï¼‰ãŒã†ã¾ãåƒã‹ãªãã¦ã€ã€Œã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã€ãªã‚“ã¦æ›¸ãã¨ã€Œã‚½ã€ã®éƒ¨åˆ†ãŒæ–‡å—åŒ–ã‘ã—ã¦ã—ã¾ã£ãŸã‚Šã—ã¦ã„ã¾ã—ãŸã€‚ æ˜¨æ—¥ã®ã‚¨ãƒ³ãƒˆãƒªã§ã€ŒSoftwareã€ãªã‚“ã¦æ›¸ã„ã¦ã„ãŸã®ã¯è‹¦è‚‰ã®ç–(ç¬‘)ã€‚ã€€åŽŸå› ã¯ã€Œã‚½ã€ç‰ã®æ–‡å—ã§ãŠã—ã‚Š 1Byte ãŒ \ ã¨åŒã˜ã‚³ãƒ¼ãƒ‰ã§ã‚ã‚‹ã“ã¨ã§ã¡ã‚ƒã‚“ã¨ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ã—ã¦ã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æ ¼ç´ã—ãªã„ã¨ã€ãŠã—ã‚ŠãŒã¨ã‚‰ã‚Œã¡ã‚ƒã£ã¦æ–‡å—åŒ–ã‘ã—ã¡ã‚ƒã†ã“ã¨ã«ã‚ã‚Šã¾ã™ã€‚ 1
love210 2008/05/10
mysql

æ–‡å—åŒ–ã‘
ãƒªãƒ³ã‚¯
https://www.openvista.jp/archives/note/2007/copying-wordpress/?2007/copying-wordpress/
love210 2008/05/05
ã“ã‚Œã¯è©¦ã™ï¼

wordpress

æ–‡å—åŒ–ã‘
ãƒªãƒ³ã‚¯
wordpressã‚’ãƒãƒ¼ã‚«ãƒ«ã«ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—
WordPressã®ãƒ†ãƒ¼ãƒžã‚’ã‚«ã‚¹ã‚¿ãƒžã‚¤ã‚ºã™ã‚‹ã®ã«ã€ãƒãƒ¼ã‚«ãƒ«ã§ä½œæ¥ã—ã‚ˆã†ã¨æ€ã£ã¦MAMPä¸Šã«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸã‚‰æ–‡å—åŒ–ã‘ãŒã€‚ è§£æ±ºæ–¹æ³•ã‚’è¦šãˆæ›¸ãã¨ã—ã¦ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã€‚ WordPress Database Backupã§å®šæœŸçš„ã«ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã—ã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ•ã‚¡ã‚¤ãƒ«ã®æœ€æ–°ã®ã‚‚ã®ã‚’ãƒãƒ¼ã‚«ãƒ«ã®phpMyAdminã§ã‚¤ãƒ³ãƒãƒ¼ãƒˆã—ã¦ã€wp-config.phpã®è¨å®šã‚’ãƒãƒ¼ã‚«ãƒ«ç”¨ã«æ›¸ãæ›ãˆã¦Wordpressã«ã‚¢ã‚¯ã‚»ã‚¹ã€‚ ã“ã‚Œã ã¨ã€ãªãœã‹æ—¥æœ¬èªžãŒæ–‡å—åŒ–ã‘ã€‚ ã¾ãšMAMPã®PHPã®php.iniã®è¨å®šã‹ãªï¼Ÿã¨æ€ã£ã¦ /Applications/MAMP/conf/php4/php.ini /Applications/MAMP/conf/php5/php.ini ã®400è¡Œç›®ã‚’ ;default_charset = "utf-8" ã«ã—ã¦ã¿ãŸã‘ã©ãƒ€ãƒ¡ã€‚ ï¼ˆã“ã®è¨å®šã¯çµå±€ã“ã®ã¾ã¾ã€‚å¤šåˆ†ã“ã®å¤‰æ›´ã¯é–¢ä¿‚ãªã‹ã£ãŸã¨
love210 2008/05/05
phpMyAdminã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½œæˆã™ã‚‹éš›ã«ç…§ä¼šé †åºã‚’utf8_unicode_ciã‚’é¸ã‚“ã§ä½œæˆã—ãŸã¨ã“ã‚ã€ ã‚¤ãƒ³ãƒãƒ¼ãƒˆã—ãŸå¾Œã‚‚ãƒ‡ãƒ¼ã‚¿ãŒæ–‡å—åŒ–ã‘ã—ã¾ã›ã‚“ã§ã—ãŸã€‚

wordpress

æ–‡å—åŒ–ã‘
ãƒªãƒ³ã‚¯
1