mysql:12066
From: tatematsu <tatematsu <tatemax@xxxxxxxxxx>>
Date: Sat, 03 Sep 2005 12:26:44 +0900
Subject: [mysql 12066] Re: SQL¥À¥ó¥×¥Ç¡¼¥¿¤Î½èÍý¤Î·ï
Ω¾¾¤Ç¤¹¡£ > Ä̾ï¤Îcreate database,table¤äinsert,load¤Ç¤Î > ¥Ç¡¼¥¿¥Ù¡¼¥¹¤ÏºîÀ®½ÐÍè¤Þ¤¹¤Î¤Ç¡¢¥Ñ¥¹¤ÏÄÌ¤Ã¤Æ > ¤¤¤Þ¤¹¤·¡¢¥¯¥é¥¤¥¢¥ó¥È¤â¥¤¥ó¥¹¥È¡¼¥ë¤µ¤ì¤Æ¤¤¤ë¤È > »×¤¤¤Þ¤¹¡ÊMySQL4..0.20a-nt¤ÇWinMySQLadmin1.4 > ¤Ç¸«¤¿¤ê¤·¤Æ¤¤¤Þ¤¹¡Ë¡£ C:\> C:\mysql\bin\mysql¤¢¤¿¤ê¤Ë¤¢¤ë¤Ã¤Æ¤³¤È¤Ç¤¹¤Í¡£ > ¤´¶µ¼¨Äº¤¤¤¿URL¤Ï»²¹Í¤Ë¤·¤Æ¤ª¤ê¡¢¥Ç¡¼¥¿¥Ù¡¼¥¹ > ´ÉÍý¤Î¹àÌܤǡ¢dump¤Ï¿§¡¹¤È¤¢¤ë¤Î¤Ç¤¹¤¬¡¢¤½¤ÎµÕ > ¤ò¤ä¤ê¤¿¤¤¤È»×¤Ã¤Æ¤ª¤ê¡¢import¤ò»î¤¹¤Î¤Ç¤¹¤¬¾å¼ê¤¯ > ¤¤¤¤Þ¤»¤ó¡Êmysqlimport ¥Ç¡¼¥¿¥Ù¡¼¥¹Ì¾¡¡geohase.sql)¡£ > > geohase.sql¤Î¥Ç¡¼¥¿¤ÏXOOPS¤Î¥Ç¡¼¥¿¤Ç¤¹¤¬¡¢°ìÉô > ²¼µ¤Î¤è¤¦¤Ë¤Ê¤Ã¤Æ¤¤¤Þ¤¹¡¨ ¤³¤Î¾ì¹çmysqlimport¤Ï»È¤ï¤Ê¤¤¤È»×¤¤¤Þ¤¹¡£ geohase.sql¤ÏSQLʸ¤òµ½Ò¤·¤¿¤â¤Î¤Ê¤Î¤Ç¡¢Linux¤Î¾ì¹ç¤À¤È shell> /usr/local/mysql/bin/mysql -u YourName -p YourPassword < geohase.sql ¤È¤·¤Þ¤¹¡£ ¤Á¤ç¤Ã¤Èwindows¤Ï»È¤Ã¤¿¤³¤È¤¬Ìµ¤¤¤Î¤Ç¶ñÂÎŪ¤Ê¥³¥Þ¥ó¥É¤¬µ ¤»¤Þ¤»¤ó¤¬ C:\> C:\mysql\bin\mysql -u YourName -p YourPassword < geohase.sql ¤³¤ó¤Ê´¶¤¸¤«¤Ê¡£¡Ê¼«¿®¤Ê¤¤¤Ç¤¹¡Ë > > > ----- Original Message ----- > From: "tatematsu" <tatemax@xxxxxxxxxx> > To: <ml@xxxxxxxxxx> > Sent: Saturday, September 03, 2005 9:30 AM > Subject: [mysql 12059] Re: SQL¥À¥ó¥×¥Ç¡¼¥¿¤Î½èÍý¤Î·ï > > > > ¤ª¤Ï¤è¤¦¤´¤¶¤¤¤Þ¤¹¡£Î©¾¾¤Ç¤¹¡£ > > > >> ¥³¥Þ¥ó¥É¤«¤é¡¡mysql<geohase.sql¡¡¤ÏÀ®¸ù¤·¤Þ¤»¤ó¡ÊÉÔÌÀ¤Î¥³¥Þ¥ó¥É¤È > >> ¥¨¥é¡¼¤¬Ìá¤ê¤Þ¤¹¡Ë¡£¡¡ > > > > ¥Ñ¥¹¤¬Ä̤äƤʤ¤¤Î¤Ç¤Ï¡©¼ã¤·¤¯¤Ï¡¢mysql¥¯¥é¥¤¥¢¥ó¥È¤¬¥¤¥ó¥¹¥È¡¼¥ë > > ¤µ¤ì¤Æ¤¤¤Ê¤¤¤Î¤Ç¤Ï¡© > > > > http://dev.mysql.com/doc/mysql/ja/windows-installation.html > > ¾åµ¤Î¥ê¥ó¥¯¤¬»²¹Í¤Ë¤Ê¤ê¤Þ¤»¤ó¤«¤Í¡£ > >
12055 2005-09-02 18:48 ["safe" <geohase@xxxx] SQL¥À¥ó¥×¥Ç¡¼¥¿¤Î½èÍý¤Î·ï 12056 2005-09-02 19:08 ¨±[tatematsu <tatemax@x] 12057 2005-09-02 19:28 ¡¡¨±[tatematsu <tatemax@x] 12058 2005-09-02 23:19 ¡¡¡¡¨±["safe" <geohase@xxxx] 12059 2005-09-03 09:30 ¡¡¡¡¡¡¨±[tatematsu <tatemax@x] 12061 2005-09-03 11:34 ¡¡¡¡¡¡¡¡¨±["safe" <geohase@xxxx] -> 12066 2005-09-03 12:26 ¡¡¡¡¡¡¡¡¡¡¨±[tatematsu <tatemax@x] 12067 2005-09-03 15:23 ¡¡¡¡¡¡¡¡¡¡¡¡¨±["safe" <geohase@xxxx] 12068 2005-09-03 16:11 ¡¡¡¡¡¡¡¡¡¡¡¡¡¡¨²[SUGIMURA Takashi ¿ùÂ] 12069 2005-09-03 16:24 ¡¡¡¡¡¡¡¡¡¡¡¡¡¡¨±[tatematsu <tatemax@x]