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

glover id:glover

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

Macã«MySQLã¨phpMyAdmminã‚’å…¥ã‚Œã€XAMPPã‚„MAMPã‚’ä½¿ã‚ãšã«LAMPç’°å¢ƒã‚’æ§‹ç¯‰ã™ã‚‹æ–¹æ³•ã¨ã€ãƒãƒ¼ãƒãƒ£ãƒ«ãƒ›ã‚¹ãƒˆã®è¨å®š | Macã¨ã‹ã®é›‘è¨˜å¸³
XAMPPã‚„MAMPã‚’ä½¿ãˆã°Macã§ã‚‚ç°¡å˜ã«LAMPç’°å¢ƒã‚’å°Žå…¥ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ãŒã€ãã‚Œã‚‰ã‚’ä½¿ã‚ãšã«æ§‹ç¯‰ã™ã‚‹æ–¹æ³•ã§ã™ã€‚LAMPæ§‹ç¯‰ã«ã¯[Apache] [MySQL] [PHP/Perl/Python] ãŒå¿…è¦ã§ã™ãŒã€Macã¯ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§Apacheã¨PHPï¼PerlãŒå°Žå…¥ã•ã‚Œã¦ã„ã‚‹ã®ã§ã€MySQLã¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ç”¨ã«phpMyAdminã‚’å…¥ã‚Œã¦LAMPç’°å¢ƒã‚’æ§‹ç¯‰ã—ã¾ã™ã€‚ã¤ã„ã§ã«ãƒãƒ¼ãƒãƒ£ãƒ«ãƒ›ã‚¹ãƒˆã®è¨å®šã‚’ã—ã¦ã‚µã‚¤ãƒˆã”ã¨ã«å°‚ç”¨ã®ãƒ‰ãƒ¡ã‚¤ãƒ³ã‚’å‰²ã‚Šå½“ã¦ã¾ã™ã€‚ MySQLã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« ä¸‹è¨˜ã‚µã‚¤ãƒˆã‚ˆã‚ŠMySQLã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¾ã™ã€‚ Download MySQL Community Server â€»ï¼šMacPortsã‹ã‚‰ã‚‚MySQLã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã§ãã¾ã™ãŒã€æ™‚é–“ãŒã‹ã‹ã‚‹ä¸Šã«ã€å¾Œè¿°ã™ã‚‹ã‚·ã‚¹ãƒ†ãƒ ç’°å¢ƒè¨å®šã®é …ç›®ãŒè¿½åŠ ã•ã‚Œãªã„ã®ã§æ‰‹å‹•ã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¾ã™ã€‚ ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã€å±•é–‹orãƒžã‚¦ãƒ³ãƒˆã—ã¦é–‹ãã¨ã‚¤ãƒ³ã‚¹ãƒˆ
glover 2011/08/07
mac

lion

mysql

phpmyadmin

develop
ãƒªãƒ³ã‚¯
http://www.yuriko.net/wp-content/uploads/2011/08/wp-local-lion.pdf
2 â€¢ wï· wï· wï· 2 3 â€¢ wï· wï· wï· 3 4 â€¢ â€¢ wï· wï· 4 5 â€¢ â€¢ wï· â€¢ $ mysql vï¶ 5 6 â€¢ â€¢ 6 7 â€¢ 7 8 â€¢ â€¢ â€¢ â€¢ â€¢ âœ´ 8 9 â€¢ http://dev.mysql.com/downloads/mysql/5.5.html wï· 9 10 â€¢ â€¢ 10 11 â€¢ wï· 11 12 â€¢ 12 13 $ /usr/local/mysql/bin/mysql -u root" mysql> SET PASSWORD FOR root@â€™localhostâ€™ = PASSWORD(â€˜ â€™);" mysql> SET PASSWORD FOR root@â€™127.0.0.1â€™ = PASSWORD(â€˜ â€™);" mysql> SET PASSWORD FOR root@â€™::1â€™ = PASSWORD(â€˜ â€™);" ( )" l
glover 2011/08/07
[filetype:pdf][media:document]

mac

lion

mysql

php

cgi
ãƒªãƒ³ã‚¯
PHPã§èª°ã§ã‚‚ç°¡å˜Webã‚µãƒ¼ãƒ“ã‚¹è£½ä½œï¼ã§ãªã‚“ã‹ä½œã£ã¦å…¬é–‹ã—ãŸå¥´ã¡ã‚‡ã£ã¨æ¥ã„ - ç”˜å‘³å¿—å‘ï¼ ã¯ã¦ãª
ã‚¿ã‚¤ãƒˆãƒ«ã¯å‡ºæ¥ã‚Œã°é–¢é€£ã™ã‚‹æ–¹ã«èªã‚“ã§æ¬²ã—ã‹ã£ãŸã®ã§ã€è»½ãé‡£ã‚Šé‡ã«ã—ã¾ã—ãŸã€‚ã™ã¿ã¾ã›ã‚“ã€‚:*) æœ€è¿‘ã¯ã‚„ã‚Šã®ãƒ’ã‚¦ã‚£ãƒƒãƒ’ãƒ’ãƒ¼ï¼ˆTwitterï¼‰ã§ã‚‚ã€ã‚ˆãã€Œâ—‹â—‹ã£ãŸãƒ¼ã€ã¿ãŸã„ãªã‚µãƒ¼ãƒ“ã‚¹ãŒã°ã‚“ã°ã‚“ç™»å ´ã—ã¦ã¾ã™ãï¼ ãŠã‹ã’ã§ã¾ã™ã¾ã™ãƒ„ã‚¤ãƒƒã‚¿ãƒ¼ãŒé¢ç™½ã„æ„Ÿã˜ã«ãªã£ã¦ã¦ã€ã„ã„æµã‚Œã§ã™ãï¼ ã§ã‚‚ï½¥ï½¥ï½¥ã¡ã‚‡ã£ã¨æ°—ã«ãªã‚‹ã“ã¨ãŒï½¥ï½¥ï½¥ æœ€è¿‘ã€Œã‚‚ã†ãƒ—ãƒã‚°ãƒ©ãƒžã«ã¯é ¼ã‚‰ãªã„ï¼ç°¡å˜ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ï¼ã€ã ã¨ã‹ï½¥ï½¥ï½¥ ã€ŒPHPã§èª°ã§ã‚‚ç°¡å˜Webã‚µãƒ¼ãƒ“ã‚¹ä½œæˆï¼ã€ã ã¨ã‹ï½¥ï½¥ï½¥ ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ã®ãƒ›ãƒƒãƒ†ãƒ³ãƒˆãƒªã§è¦‹ã‹ã‘ã¾ã™ã‚ˆãï½¥ï½¥ï½¥ ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã™ã‚‹äººãŒå¢—ãˆã‚‹ã®ã¯ç´ æ•µã§ã™ï¼ãƒ¬ãƒƒãƒ„ï½¥ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ãªã†ï¼ ãªã‚“ã§ã™ã‘ã©ï½¥ï½¥ï½¥ ã¡ã‚ƒã‚“ã¨ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã®ã“ã¨è€ƒãˆã¦ã¾ã™ã‹ï½¥ï½¥ï½¥ï¼ï¼Ÿ ã€Žã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£å¯¾ç–ã¨ã‹é›£ã—ã„ã—é¢å€’ãã›ãƒ¼ã—ã€ä¿ºã®é©å½“ã«ä½œã£ãŸã‚µãƒ¼ãƒ“ã‚¹ã¨ã‹ã©ã†ãªã£ã¦ã‚‚ã‚¤ã‚¤ã—ï½—ï½—ã€ ã„ã„ã‚“ã§ã™ã„ã„ã‚“ã§ã™ï¼ åˆ¥ã«ãã†æ€ã£ã¦ã‚‹ãªã‚‰ã©ã†ã§ã‚‚ã„ã„ã‚“ã§ã™ï¼
glover 2010/02/23
php

security

programming

mysql

xss
ãƒªãƒ³ã‚¯
[ThinkIT] ç¬¬2å›žï¼šMyISAMã¨InnoDB (1/3)
ä»Šå›žã¯ã€MySQLã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã®ä¸ã§ã‚‚ç‰¹ã«æœ‰åãªã€ŒMyISAMã€ã¨ã€ŒInnoDBã€ã®2ã¤ã‚’å–ã‚Šä¸Šã’ã¾ã™ã€‚MyISAMã¯MySQLã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã§ã€ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã‚’æŒ‡å®šã›ãšã«ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œæˆã™ã‚‹ã¨MyISAMãŒé¸æŠžã•ã‚Œã¾ã™ã€‚ã‚‚ã†ä¸€æ–¹ã®InnoDBã‚¨ãƒ³ã‚¸ãƒ³ã¯ã€MySQLã«è±Šå¯Œãªãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ã‚’æä¾›ã™ã‚‹ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã¨ã—ã¦æœ‰åã§ã™ã€‚ ã¾ãšã¯ãã‚Œãžã‚Œã®ãƒ†ãƒ¼ãƒ–ãƒ«ãƒ•ã‚¡ã‚¤ãƒ«ã®æ§‹é€ ã«ã¤ã„ã¦è§£èª¬ã—ã€æœ€å¾Œã«InnoDBã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ å„ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã®ãƒ•ã‚¡ã‚¤ãƒ«æ§‹é€ ã‚’èª¬æ˜Žã™ã‚‹å‰ã«ã€å‰çŸ¥è˜ã¨ã—ã¦MySQLã®ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªæ§‹é€ ã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã™ã€‚ MySQLã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã«ã¯ã€ãƒã‚¤ãƒŠãƒªãƒã‚°ã¨å‘¼ã¶ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ›´æ–°æƒ…å ±ã‚’æ ¼ç´ã™ã‚‹ãƒ•ã‚¡ã‚¤ãƒ«ã¨ã€2ã¤ã®ã‚µãƒ–ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªãŒå˜åœ¨ã—ã¾ã™ï¼ˆå›³1ï¼‰ã€‚ ã€Œmysqlã€ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã«ã¯æ¨©é™ãƒ†ãƒ¼ãƒ–ãƒ«ã¨å‘¼ã°ã‚Œã‚‹MySQ
glover 2008/07/08
mysql

myisam

innodb
ãƒªãƒ³ã‚¯
Amazon.co.jp: åˆã‚ã¦ã®PHP & MySQL ç¬¬2ç‰ˆ: Michele E. Davis (è‘—), Jon A. Phillips (è‘—), è¥¿æ²¢ç›´æœ¨ (ç¿»è¨³): æœ¬
glover 2008/06/16
ä¸€å¿œè²·ã†ã‹ã‚‚ã€‚

php

mysql

amazon

book
ãƒªãƒ³ã‚¯
ã‘ã‚“ã™ã†ãƒ©ã‚¤ãƒ•ãƒã‚°
glover 2008/04/14
heteml

ruby

mysql
ãƒªãƒ³ã‚¯
æ›´æ–°ãŒã‚ã‚‹ã‚·ã‚¹ãƒ†ãƒ ã«ã¯InnoDBã‚’é¸ã¼ã†ã€‚MyISAMã‚’é¸æŠžã™ã‚‹ãªã‚‰ãã‚Œãªã‚Šã®ç†ç”±ãŒå¿…è¦ã€‚ãã‚Œã«InnoDBã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã¯ãã‚“ãªã«æ‚ªããªã„ã‚ˆã€‚ || ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°Blog: ã‚¤ãƒ³ã‚¿ãƒ¼ã‚ªãƒ•
AWSã‚¢ãƒ‰ãƒãƒ³ã‚¹ãƒ‰ã‚³ãƒ³ã‚µãƒ«ãƒ†ã‚£ãƒ³ã‚°ãƒ‘ãƒ¼ãƒˆãƒŠãƒ¼ã®ä¸€å“¡ã¨ã—ã¦æ´»å‹•ã™ã‚‹æ ªå¼ä¼šç¤¾ã‚¹ã‚¿ã‚¤ãƒ«ã‚ºãŒã€AWSå°Žå…¥ã€ç§»è¡Œã€é–‹ç™ºã€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã€é‹ç”¨ä¿å®ˆãªã©ã€ã™ã¹ã¦ã®ã”ç›¸è«‡ã«ä¹—ã‚‰ã›ã¦ã„ãŸã ãã¾ã™ã€‚ AWSã‚’å°Žå…¥ã—ãŸã„ãŒä½•ã‹ã‚‰å§‹ã‚ãŸã‚‰ã„ã„ã‹ã‚ã‹ã‚‰ãªã„ æ—¢å˜ã®ãƒ™ãƒ³ãƒ€ãƒ¼ãŒæ–°æŠ€è¡“ã«å¼±ãã€è‰¯ã„ææ¡ˆãŒã‚‚ã‚‰ãˆãªã„ ã‚¯ãƒ©ã‚¦ãƒ‰ã®å°Žå…¥ã«ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã®ä¸å®‰ãŒã‚ã‚‹ AWSã‚’ã¨ã‚Šã‚ãˆãšå°Žå…¥ã—ãŸãŒã€ã•ã‚‰ã«æ´»ç”¨ã—ã¦ã„ããŸã„ ç¤¾å†…ã«AWSã®çŸ¥è¦‹ã‚’æŒã£ã¦ã„ã‚‹äººãŒã„ãªã„ AWSãªã‚‰ã§ã¯ã®ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã‚’è©³ã—ãçŸ¥ã‚ŠãŸã„
glover 2007/07/01
imported

db

mysql
ãƒªãƒ³ã‚¯
MySQLã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’è¡Œã†mysqldumpæ©Ÿèƒ½ã‚’æä¾›ã™ã‚‹PHPã‚¯ãƒ©ã‚¹:phpspoté–‹ç™ºæ—¥èªŒ
Coders4fun PHP backup of a mysql database First of all, I searched for a php script that makes the direct dump of the database. MySQLã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’è¡Œã†mysqldumpæ©Ÿèƒ½ã‚’æä¾›ã™ã‚‹PHPã‚¯ãƒ©ã‚¹ãŒå…¬é–‹ã•ã‚Œã¦ã„ã¾ã—ãŸã€‚ ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ã‹ã‚‰ä½¿ã†mysqldumpã¨ã„ã†ãƒ„ãƒ¼ãƒ«ãŒã‚ã‚Šã¾ã™ãŒã€ä»Šå›žç´¹ä»‹ã®ã‚‚ã®ã¯æ¬¡ã®ã‚ˆã†ã«PHPã®ã‚¯ãƒ©ã‚¹ã¨ã—ã¦ä½¿ã†ã“ã¨ãŒå¯èƒ½ã§ã™ã€‚ new MySQLDump("localhost", "root", ""); PHPã®ã‚¯ãƒ©ã‚¹ã«ã™ã‚‹ã“ã¨ã§ã€åˆ¶å¾¡ãŒã‚ˆã‚Šç°¡å˜ã«ãªã‚‹ä¸Šã€WEBã®ã‚¤ãƒ³ã‚¿ãƒ•ã‚§ãƒ¼ã‚¹ã¨ã—ã¦æ©Ÿèƒ½ã‚’çµ„ã¿è¾¼ã‚€ã®ã«ã‚‚ä¾¿åˆ©ã§ã™ãã€‚ é–¢é€£ã‚¨ãƒ³ãƒˆãƒª MySQLãƒ‡ãƒ¼ã‚¿ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—æ–¹æ³• MySQLã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãƒ„ãƒ¼ãƒ«: phpMyBackupPro
glover 2007/06/27
imported

mysql

php
ãƒªãƒ³ã‚¯
1