Ω¾¾¤Ç¤¹¡£

> Ä̾ï¤Î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
> > ¾åµ­¤Î¥ê¥ó¥¯¤¬»²¹Í¤Ë¤Ê¤ê¤Þ¤»¤ó¤«¤Í¡£
> 
>