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

shirohare777 id:shirohare777

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

${{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ã®ãƒ‡ãƒ¼ã‚¿ã‚’ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã™ã‚‹(mysqldump) - bnote
MySQL ã«ã¯ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã®å®šç¾©ã‚„ãƒ‡ãƒ¼ã‚¿ã‚’è¿½åŠ ã™ã‚‹ãŸã‚ã® SQL æ–‡ã‚’å‡ºåŠ›ã™ã‚‹ãŸã‚ã® mysqldump ãŒç”¨æ„ã•ã‚Œã¦ã„ã¾ã™ã€‚ ã™ã¹ã¦ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã™ã‚‹ã«ã¯ã€æ¬¡ã®ã‚ˆã†ã«æŒ‡å®šã—ã¾ã™ã€‚ $ mysqldump -A -u root -p ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ --opt > ãƒ€ãƒ³ãƒ—ãƒ•ã‚¡ã‚¤ãƒ«å æŒ‡å®šã—ã¦ã‚ã‚‹ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã®æ„å‘³ã¯ã€æ¬¡ã®ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚ -aï¼šå…¨ã¦ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’å¯¾è±¡ã«ã—ã¾ã™ã€‚ -optï¼šã‚¯ã‚¨ãƒªã‚’ãƒãƒƒãƒ•ã‚¡ã›ãšã€stdou ã«ç›´æŽ¥ãƒ€ãƒ³ãƒ—ã™ã‚‹ã€‚ drop table ã‚’è¿½åŠ ã™ã‚‹ã€‚ å„ãƒ†ãƒ¼ãƒ–ãƒ«ãƒ€ãƒ³ãƒ—ã®å‰ã« LOCK TABLES ã‚’è¿½åŠ ã—ã€å¾Œã« UNLOCK TABLE ã‚’è¿½åŠ ã™ã‚‹ã€‚ è¤‡æ•°è¡Œ INSERT æ§‹æ–‡ã‚’ä½¿ç”¨ã™ã‚‹ã€‚ ãƒ€ãƒ³ãƒ—ã‚’é–‹å§‹ã™ã‚‹å‰ã«ã™ã¹ã¦ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ãƒãƒƒã‚¯ã™ã‚‹ã€‚ ç‰¹å®šã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã™ã‚‹å ´åˆã€æ¬¡ã®ã‚ˆã†ã«æŒ‡å®šã—ã¾ã™ã€‚ $ mysqldump ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å -u r
shirohare777 2012/12/27
MySQL
ãƒªãƒ³ã‚¯
ï¼°ï¼¨ï¼°ã®é–‹ç™ºåŠ¹çŽ‡ã‚’ä¸Šã’ã‚‹ï¼‘ï¼å€‹ã®é–¢æ•° - PHP,MySQL,Flex,JSãªæ—¥ã€…ï¼‹ã‚¤ãƒ©ã‚¹ãƒˆã¨ã‹
ã€Œè¿½è¨˜ã¨ã‹ã€ã«ã‚³ãƒ¡ãƒ³ãƒˆã®è¿”ç”ã‚„è¿½è¨˜ã‚’ã—ã¦ã¾ã™ã®ã§åˆã‚ã›ã¦ã©ã†ãžã€‚ ã‹ã‚Œã“ã‚Œï¼“å¹´ãã‚‰ã„PHPã‚’ã‚„ã£ã¦ã„ã‚‹ã®ã§ã€ã›ã£ã‹ããªã®ã§ï¼‘ï¼å€‹ã®ä¾¿åˆ©ãªé–¢æ•°ã‚’ä¸¦ã¹ã¦ã¿ã¾ã—ãŸã€‚ ä½œæ¥åŠ¹çŽ‡ãŒã‹ãªã‚Šã‚¢ãƒƒãƒ—ã™ã‚‹ã®ã§ã€ã“ã‚Œã‹ã‚‰PHPã‚’ã‚„ã£ã¦ã¿ã‚ˆã†ã‹ãªãã£ã¦æ€ã†æ–¹ã¯çŸ¥ã£ã¦ãŠãã¨ä¾¿åˆ©ã ã¨æ€ã„ã¾ã™ã€‚ å¤‰æ•°ã€é…åˆ—ã®å†…å®¹ã‚’ã‚ãƒ¬ã‚¤ã«è¡¨ç¤ºã™ã‚‹é–¢æ•°ã€Œdã€ å¤‰æ•°ã‚„é…åˆ—ã®å†…å®¹ã‚’HTMLæ§‹æ–‡ã§ã‚ãƒ¬ã‚¤ã«è¡¨ç¤ºã—ã¦ãã‚Œã¾ã™ã€‚ ã—ã‹ã‚‚ã€var_dumpã¨æ›¸ãã¨ã‚¿ã‚¤ãƒ”ãƒ³ã‚°ãŒå¤§å¤‰ãªã®ã§ã€Œd($hoge)ã€ã¨ã—ã¦ç°¡å˜ã«è¨˜è¿°ã€‚ ã“ã‚Œã ã‘ã§ã‚‚ä½œæ¥åŠ¹çŽ‡8å€ function d() { echo '<pre style="background:#fff;color:#333;border:1px solid #ccc;margin:2px;padding:4px;font-family:monospace;font-size:12px">'; foreac
shirohare777 2012/06/21
PHP

MySQL
ãƒªãƒ³ã‚¯
MySQL 5.0ã®æ–‡å—ã‚³ãƒ¼ãƒ‰è¨å®š - ã‚ã‚‹ç•°é‚¦äººã®æŠ€è¡“ãƒ¡ãƒ¢
æ™®é€šã«apt-get install mysqlã¨ã‹ã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸã¨ã“ã‚ã€æ™®é€šã«ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆæ–‡å—ã‚³ãƒ¼ãƒ‰ãŒlatin1ã¨ã‹ã«ãªã‚Šã‚„ãŒã£ã¦ãã‚Œã¾ã—ãŸã€‚ Create databaseã™ã‚‹ã¨ãã« create database some_database DEFAULT CHARACTER SET utf8; ã¨ã‹ã‚„ã£ã¦ã‚‚æ–‡å—ã‚³ãƒ¼ãƒ‰ã‚’æŒ‡å®šã§ãã‚‹ã¿ãŸã„ã ã‘ã©ã€ãã‚Œã ã¨create databaseã™ã‚‹ãŸã³ã«æŒ‡å®šã™ã‚‹ã®ãŒã†ã–ã²ã€‚ ã®ã§ã€/etc/mysql/my.confã€€ã‚ãŸã‚Šã«ä»¥ä¸‹è¨å®šã‚’è¿½åŠ ã—ã¦ã‚„ã‚Œã°ã‚ˆã„ã“ã¨ãŒã‚ã‹ã£ãŸã€‚ubuntuã§æ™®é€šã«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸmysql(5.0)ã®my.confã¯ /etc/mysql/conf.d/* ã«ã‚ã‚‹ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã“ã¨ã”ã¨ãæœ€å¾Œã«includeã™ã‚‹ã‚ˆã†ãªã®ã§ã€/etc/mysql/conf.d/ã« character_set.cnfã¨ã„ã†ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ä»¥ä¸‹å†…å®¹ã§
shirohare777 2011/11/01
MySQL

ubuntu
ãƒªãƒ³ã‚¯
MySQLã§mysqld.sockã¾ã‚ã‚Šã§ã‚¨ãƒ©ãƒ¼ãŒã§ãŸå ´åˆã®å¯¾å‡¦æ³• - æµ·ã®éŸ¿ãã‚’æ‡ã‹ã—ã‚€
ã€referenceã€‘ http://www.jabberdoc.org/AdminGuide http://devdoodles.wordpress.com/2009/03/19/installing-jabberd2-and-mysql-on-ubuntu-810/ http://dev.mysql.com/doc/refman/4.1/ja/can-not-connect-to-server.html Ubuntuä¸Šã§MySQLã‚’ã„ã˜ã£ã¦ã„ã¦ã€ã„ã‚ã„ã‚ä¸æ…£ã‚Œãªã¾ã¾ãƒãƒ¥ãƒ¼ãƒˆãƒªã‚¢ãƒ«ã‚’ã¾ã˜ã‚ã«èªã¾ãšã«èµ·å‹•ï¼åœæ¢ã‚’ç¹°ã‚Šè¿”ã—ã¦ã„ãŸã‚‰ã€ ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) ã¨ã„ã†ã‚¨ãƒ©ãƒ¼ãŒã§ãŸã€‚ä»¥ä¸‹ã«ãã®å¯¾å‡¦æ³•ã‚’ç¤ºã™ã€‚ ã¾ãš[
shirohare777 2011/11/01
MySQL

è¨å®š
ãƒªãƒ³ã‚¯
Wikipediaãƒ‡ãƒ¼ã‚¿ã®åˆ©ç”¨æ–¹æ³•ã«ã¤ã„ã¦ - FreeStyleWiki
ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ http://download.wikimedia.org/ã®ã€Database XML and SQL dumpsã®ãƒªãƒ³ã‚¯ã‹ã‚‰, XMLå½¢å¼, ãŠã‚ˆã³SQLå½¢å¼ã§ã®å–å¾—ãŒå¯èƒ½ã€‚ã¾ãŸ, ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ãƒšãƒ¼ã‚¸ã«ã¦ã€ŒDump in progressã€ã¨ãªã£ã¦ã„ã‚‹ã‚‚ã®ã¯å‡¦ç†ä¸ã®ã‚‚ã®ãªã®ã§ã€ŒDump completeã€ã¨ãªã£ã¦ã„ã‚‹ç®‡æ‰€ã‚’æŽ¢ã™ã€‚è‹±èªžç‰ˆWikipediaã®ãƒ‡ãƒ¼ã‚¿ã¯ enwiki, æ—¥æœ¬èªžç‰ˆWikipediaã®ãƒ‡ãƒ¼ã‚¿ã¯ jawikiã®ãƒªãƒ³ã‚¯ãŒè¨å®šã•ã‚Œã¦ã„ã‚‹ç®‡æ‰€ã‹ã‚‰, å€‹åˆ¥ã®ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ãƒšãƒ¼ã‚¸ã«ç§»å‹•ã—å–å¾—ã™ã‚‹ã€‚ ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰(è£å£) ä¸Šè¨˜ã—ãŸãƒšãƒ¼ã‚¸ã‹ã‚‰ã§ã¯, ã€Œdump abortedã€ã‚„ã€ŒDump in progressã€ã¸ã®ãƒªãƒ³ã‚¯ã—ã‹ãªã, ç›®çš„ã®è¨€èªžç‰ˆã¸ã®ãƒªãƒ³ã‚¯ãŒè¦‹ä»˜ã‹ã‚‰ãªã„å ´åˆãŒã¾ã‚Œã«ã‚ã‚‹ã€‚ãã®ã‚ˆã†ãªå ´åˆ, ä»¥ä¸‹ã®URLã‹ã‚‰ç›´æŽ¥æŽ¥ç¶šã™ã‚‹ã€‚ æ—¥æœ¬èªžç‰ˆ è‹±èªžç‰ˆ ä¸å›½èªžç‰ˆ
shirohare777 2011/10/20
MySQL
ãƒªãƒ³ã‚¯
1