DB/MySQL
¤Ï¤¸¤á¤Ë†
MySQL ¤Ë´Ø¤¹¤ë½ô¡¹¡£
¥×¥í¥ó¥×¥È¤ËÆþ¤ë†
# ¥Ñ¥¹¥ï¡¼¥É¤Ê¤·¥æ¡¼¥¶ mysql -u <username> # ¥Ñ¥¹¥ï¡¼¥É¤¢¤ê¥æ¡¼¥¶ mysql -u <username> -p
root ¤Î¥Ñ¥¹¥ï¡¼¥ÉÊѹ¹†
set password for root@localhost=password('<password>');
¥¨¥¯¥¹¥Ý¡¼¥È¤È¥¤¥ó¥Ý¡¼¥È†
¥Ð¥Ã¥¯¥¢¥Ã¥×¤ÈÉü¸µ¤Ê¤É¤Ë¡£
¥¨¥¯¥¹¥Ý¡¼¥È¡Ê¥À¥ó¥×¤Î¼èÆÀ¡Ë†
# ÆÃÄê¤Î¥Ç¡¼¥¿¥Ù¡¼¥¹¤Î¤ß¤Î¥À¥ó¥×¤ò¼èÆÀ mysqldump -u <username> <database-name> > hoge.dmp # Á´ÂΤΥÀ¥ó¥×¤ò¼èÆÀ mysqldump -u root -x --all-databases > hoge.dmp
¥¤¥ó¥Ý¡¼¥È¡Ê¥À¥ó¥×¤«¤éÉü¸µ¡Ë†
# ÆÃÄê¤Î¥Ç¡¼¥¿¥Ù¡¼¥¹¤Î¤ß¤ò¥À¥ó¥×¤«¤éÉü¸µ mysql -u <username> <database-name> < hoge.dmp # Á´ÂΤò¥À¥ó¥×¤«¤éÉü¸µ # ¥æ¡¼¥¶¤Ë¥Ñ¥¹¥ï¡¼¥É¤¬Ìµ¤¤¤Ê¤é -p ¤ÏÉÔÍ× mysql -u <username> -p < hoge.dmp
Last-modified: 2011-10-26 (¿å) 14:40:23