½Ã½ºÅÛ°ü¸®ÀÚÀÇ ½°ÅÍ Ä¿ÇǴнº Ä¿ÇÇÇâÀÌ ³ª´Â *NIX
Ä¿ÇǴнº
½Ã½ºÅÛ/³×Æ®¿÷/º¸¾ÈÀ» ´Ù·ç´Â °÷
 FAQFAQ   °Ë»ö°Ë»ö   ¸â¹ö¸®½ºÆ®¸â¹ö¸®½ºÆ®   »ç¿ëÀÚ ±×·ì»ç¿ëÀÚ ±×·ì   »ç¿ëÀÚ µî·ÏÇϱâ»ç¿ëÀÚ µî·ÏÇϱâ 
 °³ÀÎ Á¤º¸°³ÀÎ Á¤º¸   ºñ°ø°³ ¸Þ½ÃÁö¸¦ È®ÀÎÇÏ·Á¸é ·Î±×ÀÎÇϽʽÿÀºñ°ø°³ ¸Þ½ÃÁö¸¦ È®ÀÎÇÏ·Á¸é ·Î±×ÀÎÇϽʽÿÀ   ·Î±×Àηα×ÀΠ

°¡ÀÔ¾øÀÌ ´©±¸³ª ±ÛÀ» ¾µ ¼ö ÀÖ½À´Ï´Ù. °øÁö»çÇ׿¡ ´ëÇÑ ´ñ±Û±îÁöµµ..




BBS >> ¼³Ä¡, ¿î¿µ Q&A | ³×Æ®¿÷, º¸¾È Q&A | ÀÏ¹Ý Q&A || Á¤º¸¸¶´ç | AWS || ÀÚÀ¯°Ô½ÃÆÇ | ±¸Àα¸Á÷ || °øÁö»çÇ× | ÀÇ°ßÁ¦½Ã
ÀÏ´Ü ´ëÃæ º¹±¸´Â µÆ´Âµ¥.. mysqlÀÌ ¾ÈµÇ³×¿ä..

 
±Û ¾²±â   ´äº¯ ´Þ±â    Ä¿ÇǴнº, ½Ã½ºÅÛ ¿£Áö´Ï¾îÀÇ ½°ÅÍ °Ô½ÃÆÇ À妽º -> ½Ã½ºÅÛ ¼³Ä¡ ¹× ¿î¿µ
ÀÌÀü ÁÖÁ¦ º¸±â :: ´ÙÀ½ ÁÖÁ¦ º¸±â  
±Û¾´ÀÌ ¸Þ½ÃÁö
kobi



°¡ÀÔ: 2003³â 9¿ù 4ÀÏ
¿Ã¸° ±Û: 28

¿Ã¸®±â¿Ã·ÁÁü: 2003.12.10 ¼ö, 6:20 pm    ÁÖÁ¦: ÀÏ´Ü ´ëÃæ º¹±¸´Â µÆ´Âµ¥.. mysqlÀÌ ¾ÈµÇ³×¿ä.. Àοë°ú ÇÔ²² ´äº¯

[root@localhost mysql-3.23.58-pc-linux-i686]# ./configure --prefix=/usr/local/mysql --localstatedir=/usr/local/mysql/data --with-charset=euc_kr
NOTE: This is a MySQL binary distribution. It's ready to run, you don't
need to configure it!

To help you a bit, I am now going to create the needed MySQL databases
and start the MySQL server for you. If you run into any trouble, please
consult the MySQL manual, that you can find in the Docs directory.

Installing all prepared tables
031210 18:21:08 ./bin/mysqld: Shutdown Complete


To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
This is done with:
./bin/mysqladmin -u root password 'new-password'
./bin/mysqladmin -u root -h localhost password 'new-password'
See the manual for more instructions.

NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run
the ./bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!

You can start the MySQL daemon with:
cd . ; ./bin/safe_mysqld &

You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; run-all-tests

Please report any problems with the ./bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com

Starting the mysqld server. You can test that it is up and running
with the command:
./bin/mysqladmin version
[root@localhost mysql-3.23.58-pc-linux-i686]# Starting mysqld daemon with databases from /hosting/koreahumor.com/docs/tmp/mysql-3.23.58-pc-linux-i686/data
031210 18:21:08 mysqld ended


[root@localhost mysql-3.23.58-pc-linux-i686]#

ÀÌ·± ¿À·ù°¡ ³³´Ï´Ù..
¾î¶»°ÔÇؾßÇÏÁÒ??
_________________
¸ð¸£´Â°Ô Âü ¸¹³×¿©..¤Ð¤Ð
À§·Î
»ç¿ëÀÚ Á¤º¸ º¸±â ºñ¹Ð ¸Þ½ÃÁö º¸³»±â ±Û ¿Ã¸°ÀÌÀÇ À¥»çÀÌÆ® ¹æ¹® MSN ¸Þ½ÅÀú
truefeel
Ä«Æä °ü¸®ÀÚ


°¡ÀÔ: 2003³â 7¿ù 24ÀÏ
¿Ã¸° ±Û: 1277
À§Ä¡: ´ëÇѹα¹

¿Ã¸®±â¿Ã·ÁÁü: 2003.12.10 ¼ö, 10:14 pm    ÁÖÁ¦: Re: ±×°Ç mysql ¹ÙÀ̳ʸ® ¼³Ä¡ Àοë°ú ÇÔ²² ´äº¯

kobi ¾¸:
[root@localhost mysql-3.23.58-pc-linux-i686]# ./configure --prefix=/usr/local/mysql --localstatedir=/usr/local/mysql/data --with-charset=euc_kr
NOTE: This is a MySQL binary distribution. It's ready to run, you don't
need to configure it!

... Áß·« ...

ÀÌ·± ¿À·ù°¡ ³³´Ï´Ù..
¾î¶»°ÔÇؾßÇÏÁÒ??


¸Þ½ÃÁö¿¡ ¾ÆÁÖ Àß ³ª¿ÍÀÖ½À´Ï´Ù. ¶ÇÇÑ ÇÁ·ÒÇÁÆ®¸¦ º¸¾Æµµ ¹ÙÀ̳ʸ®·Î ¼³Ä¡ÇÏ½Å°Ô ¹Ù·Î º¸ÀÔ´Ï´Ù.
./configure ... ÇÏ´Â °úÁ¤Àº ¼Ò½º¸¦ °¡Á®´Ù°¡ ÄÄÆÄÀÏ Àü¿¡ ½Ã½ºÅÛ È¯°æ¿¡ ¸Â°Ô MakefileÀ» »ý¼ºÇØÁÖ´Â ¿ªÇÒÀ» ÇÏ´Â °ÍÀÔ´Ï´Ù. Áï, ÀÌ »óȲ¿¡¼­´Â ÇÊ¿ä¾ø´Â °ÍÀÔ´Ï´Ù.

http://www.mysql.com/doc/en/Installing_binary.html ¿¡ ¼³Ä¡ °úÁ¤ÀÌ ¾ÆÁÖ Àß ³ª¿Ô½À´Ï´Ù.

»ç¿ëÀÚ »ý¼ºÇÏ°í -> ¾ÐÃàÇ®°í (¾ÐÃà ǬÈÄ »ç¿ëÀÚ »ý¼ºÇصµ »ó°ü ¾øÀ½) -> DB ÃʱâÈ­ -> ¼ÒÀ¯ÀÚ º¯°æ -> ½ÇÇà

ÄÚµå:

shell> groupadd mysql           (±×·ì »ý¼º)
shell> useradd -g mysql mysql (»ç¿ëÀÚ »ý¼º)
shell> cd /usr/local
shell> tar xvfz /path/to/mysql-VERSION-OS.tar.gz   (¾ÐÃàÀ» Ç®°í)
shell> ln -s mysql-3.23.58-pc-linux-i686 mysql (mysql À̸§À¸·Î ¸µÅ©¸¦ ÇÏ°í)
shell> cd mysql    (/usr/local/mysql/ ·Î À̵¿)
shell> scripts/mysql_install_db (DB ÃʱâÈ­)
shell> chown -R root  .       (¼ÒÀ¯ÀÚ º¯°æ)
shell> chown -R mysql data
shell> chgrp -R mysql .
shell> bin/mysqld_safe --user=mysql & (½ÇÇà. bin/ ¾È¿¡±îÁö µé¾î°¡´Â °Í ¾Æ´Ô. /usr/local/mysql ¾Æ·¡¿¡¼­ ½ÇÇàÇÏ´Â °ÍÀÔ´Ï´Ù.)
À§·Î
»ç¿ëÀÚ Á¤º¸ º¸±â ºñ¹Ð ¸Þ½ÃÁö º¸³»±â ±Û ¿Ã¸°ÀÌÀÇ À¥»çÀÌÆ® ¹æ¹®
kobi



°¡ÀÔ: 2003³â 9¿ù 4ÀÏ
¿Ã¸° ±Û: 28

¿Ã¸®±â¿Ã·ÁÁü: 2003.12.10 ¼ö, 10:49 pm    ÁÖÁ¦: groupadd ¿Í useradd´Â ¾îµð¿¡ ÀÖÁÒ?? Àοë°ú ÇÔ²² ´äº¯

¸ð¸£´Â°Ô ÁÏ´Ï´Ù..
Á˼ÛÇÕ´Ï´Ù.. ÀÚ²Ù ¹°¾î¼­¿ä..
ã¾Æ ´Ù³æ´Âµ¥ ¸øã°Ú¾î¿ä..¤Ð¤Ð
_________________
¸ð¸£´Â°Ô Âü ¸¹³×¿©..¤Ð¤Ð
À§·Î
»ç¿ëÀÚ Á¤º¸ º¸±â ºñ¹Ð ¸Þ½ÃÁö º¸³»±â ±Û ¿Ã¸°ÀÌÀÇ À¥»çÀÌÆ® ¹æ¹® MSN ¸Þ½ÅÀú
truefeel
Ä«Æä °ü¸®ÀÚ


°¡ÀÔ: 2003³â 7¿ù 24ÀÏ
¿Ã¸° ±Û: 1277
À§Ä¡: ´ëÇѹα¹

¿Ã¸®±â¿Ã·ÁÁü: 2003.12.10 ¼ö, 11:15 pm    ÁÖÁ¦: Re: groupadd ¿Í useradd´Â /usr/sbin¿¡ Àοë°ú ÇÔ²² ´äº¯

kobi ¾¸:
¸ð¸£´Â°Ô ÁÏ´Ï´Ù..
Á˼ÛÇÕ´Ï´Ù.. ÀÚ²Ù ¹°¾î¼­¿ä..
ã¾Æ ´Ù³æ´Âµ¥ ¸øã°Ú¾î¿ä..¤Ð¤Ð


/usr/sbin ¿¡ ÀÖ½À´Ï´Ù.

root ȨÀÇ .bash_profile À» º¸¸é PATH ºÎºÐÀÌ ÀÖÀ» °Ì´Ï´Ù.
±× µÚ¿¡ /usr/sbin Ãß°¡ÇØÁÖ¸é ¸Å¹ø °æ·Î¸¦ ÀÔ·ÂÇÏ´Â ºÒÆíÀ» ´ú ¼ö ÀÖ½À´Ï´Ù.

À̸¦Å×¸é ´ÙÀ½°ú °°À» ¶§
ÄÚµå:

PATH=$PATH:$HOME/bin


¾Æ·¡ ó·³

ÄÚµå:

PATH=$PATH:$HOME/bin:/usr/sbin:/usr/local/bin


ÆÄÀÏ Ã£À» ¶§´Â slocate useradd ³ª whereis useradd ¿Í °°ÀÌ Ã£À» ¼öµµ ÀÖ½À´Ï´Ù.

ÀÌ ¾²·¹µå°¡ °¡Àå ±æ¾îÁö´Â °Í °°½À´Ï´Ù. ^^
º¹±¸¶ó´Â Á¦¸ñ ¾Æ·¡¿¡ ¹­¾îµÎ±â°¡ Àû´çÇÏÁö ¾Ê´Â ±ÛÀº Àû´çÈ÷ºÁ¼­ ºÐ¸®Çϵµ·Ï ÇÏ°Ú½À´Ï´Ù.
À§·Î
»ç¿ëÀÚ Á¤º¸ º¸±â ºñ¹Ð ¸Þ½ÃÁö º¸³»±â ±Û ¿Ã¸°ÀÌÀÇ À¥»çÀÌÆ® ¹æ¹®
kobi



°¡ÀÔ: 2003³â 9¿ù 4ÀÏ
¿Ã¸° ±Û: 28

¿Ã¸®±â¿Ã·ÁÁü: 2003.12.10 ¼ö, 11:36 pm    ÁÖÁ¦: ÀÌ°Ç ¾î¶² ¹®Á¦ÁÒ? Àοë°ú ÇÔ²² ´äº¯

ÀÚ²Ù ±æ°Ô Áú¹® µå·Á¼­ Á˼ÛÇÕ´Ï´Ù..
ÀÌ·± ¿¡·¯°¡ ³ª¿À³×¿ä..
[root@localhost mysql]# bin/safe_mysqld --user=mysql &
[7] 7491
[root@localhost mysql]# Starting mysqld daemon with databases from /usr/local/mysql/data
031210 23:37:11 mysqld ended

ÀÌ°Ç ¿Ö±×·¸ÁÒ??

ÀÚ¼¼ÇÑ ´äº¯ÇØ Áּż­ Ç×»ó °¨»çÇÕ´Ï´Ù..
_________________
¸ð¸£´Â°Ô Âü ¸¹³×¿©..¤Ð¤Ð
À§·Î
»ç¿ëÀÚ Á¤º¸ º¸±â ºñ¹Ð ¸Þ½ÃÁö º¸³»±â ±Û ¿Ã¸°ÀÌÀÇ À¥»çÀÌÆ® ¹æ¹® MSN ¸Þ½ÅÀú
truefeel
Ä«Æä °ü¸®ÀÚ


°¡ÀÔ: 2003³â 7¿ù 24ÀÏ
¿Ã¸° ±Û: 1277
À§Ä¡: ´ëÇѹα¹

¿Ã¸®±â¿Ã·ÁÁü: 2003.12.10 ¼ö, 11:42 pm    ÁÖÁ¦: Re: ÀÌ°Ç ¾î¶² ¹®Á¦ÁÒ? Àοë°ú ÇÔ²² ´äº¯

kobi ¾¸:
ÀÚ²Ù ±æ°Ô Áú¹® µå·Á¼­ Á˼ÛÇÕ´Ï´Ù..
ÀÌ·± ¿¡·¯°¡ ³ª¿À³×¿ä..
[root@localhost mysql]# bin/safe_mysqld --user=mysql &
[7] 7491
[root@localhost mysql]# Starting mysqld daemon with databases from /usr/local/mysql/data
031210 23:37:11 mysqld ended

ÀÌ°Ç ¿Ö±×·¸ÁÒ??

ÀÚ¼¼ÇÑ ´äº¯ÇØ Áּż­ Ç×»ó °¨»çÇÕ´Ï´Ù..


ps -ef Çؼ­ mysqld µ¥¸óÀÌ ¾ø´Ù¸é Á¤»óÀûÀ¸·Î ½ÇÇàµÈ °ÍÀÌ ¾Æ´Ï°ÚÁÒ.
/usr/local/mysql/data/???.err ÆÄÀÏÀÌ ÀÖÀ» µí Çѵ¥ ÀÌ ·Î±× ÆÄÀÏÀ» »ìÆ캸½Ã±â ¹Ù¶ø´Ï´Ù.
ÆÛ¹Ì¼Ç ¹®Á¦ÀÏ ¼öµµ ÀÖ´Ù´Â »ý°¢µµ µå´Â±º¿ä.
À§·Î
»ç¿ëÀÚ Á¤º¸ º¸±â ºñ¹Ð ¸Þ½ÃÁö º¸³»±â ±Û ¿Ã¸°ÀÌÀÇ À¥»çÀÌÆ® ¹æ¹®
kobi



°¡ÀÔ: 2003³â 9¿ù 4ÀÏ
¿Ã¸° ±Û: 28

¿Ã¸®±â¿Ã·ÁÁü: 2003.12.11 ¸ñ, 1:18 am    ÁÖÁ¦: root ȨÀÇ .bash_profile À̾ø´Âµ¥.... Àοë°ú ÇÔ²² ´äº¯

root ȨÀÇ .bash_profile À̾ø´Âµ¥.... ¸¸µé¾î¾ßÇϳª¿ä??

±×³É vi .bash_profile ÀÌ·¸°Ô ¸¸µå¸éµÇ³ª¿ä??
_________________
¸ð¸£´Â°Ô Âü ¸¹³×¿©..¤Ð¤Ð
À§·Î
»ç¿ëÀÚ Á¤º¸ º¸±â ºñ¹Ð ¸Þ½ÃÁö º¸³»±â ±Û ¿Ã¸°ÀÌÀÇ À¥»çÀÌÆ® ¹æ¹® MSN ¸Þ½ÅÀú
truefeel
Ä«Æä °ü¸®ÀÚ


°¡ÀÔ: 2003³â 7¿ù 24ÀÏ
¿Ã¸° ±Û: 1277
À§Ä¡: ´ëÇѹα¹

¿Ã¸®±â¿Ã·ÁÁü: 2003.12.11 ¸ñ, 1:21 am    ÁÖÁ¦: Re: /root/.bash_profile ÀÔ´Ï´Ù. Àοë°ú ÇÔ²² ´äº¯

kobi ¾¸:
root ȨÀÇ .bash_profile À̾ø´Âµ¥.... ¸¸µé¾î¾ßÇϳª¿ä??

±×³É vi .bash_profile ÀÌ·¸°Ô ¸¸µå¸éµÇ³ª¿ä??


root ID ȨÀ̶ó Çϸé /root À» ¸»ÇÕ´Ï´Ù. Áï /root/.bash_profileÀÔ´Ï´Ù.
ls -la ¿Í °°ÀÌ ²À -a ¿É¼ÇÀ» ÁÖ¾î¾ß . À¸·Î ½ÃÀÛÇÏ´Â ÆÄÀÏÀ» º¼ ¼ö ÀÖ½À´Ï´Ù.

ID/PWÀ» ¾Ë·ÁÁּ̱淡 PATH ºÎºÐÀ» Á¦°¡ ¼öÁ¤Çß½À´Ï´Ï È®ÀÎ Çغ¸¼¼¿ä.
À§·Î
»ç¿ëÀÚ Á¤º¸ º¸±â ºñ¹Ð ¸Þ½ÃÁö º¸³»±â ±Û ¿Ã¸°ÀÌÀÇ À¥»çÀÌÆ® ¹æ¹®
kobi



°¡ÀÔ: 2003³â 9¿ù 4ÀÏ
¿Ã¸° ±Û: 28

¿Ã¸®±â¿Ã·ÁÁü: 2003.12.11 ¸ñ, 1:50 am    ÁÖÁ¦: mysql ¿À·ùÀÔ´Ï´Ù. Àοë°ú ÇÔ²² ´äº¯

mysql> select * from board;
ERROR 1030: Got error -1 from table handler

ÀÌ·± ¿À·ù°¡ ³ª³×¿ä..
¾î¶»°Ô »ì¸±¼ö ÀÖÀ»±î¿ä??
¤Ð¤Ð
_________________
¸ð¸£´Â°Ô Âü ¸¹³×¿©..¤Ð¤Ð
À§·Î
»ç¿ëÀÚ Á¤º¸ º¸±â ºñ¹Ð ¸Þ½ÃÁö º¸³»±â ±Û ¿Ã¸°ÀÌÀÇ À¥»çÀÌÆ® ¹æ¹® MSN ¸Þ½ÅÀú
truefeel
Ä«Æä °ü¸®ÀÚ


°¡ÀÔ: 2003³â 7¿ù 24ÀÏ
¿Ã¸° ±Û: 1277
À§Ä¡: ´ëÇѹα¹

¿Ã¸®±â¿Ã·ÁÁü: 2003.12.11 ¸ñ, 2:03 am    ÁÖÁ¦: Re: mysql DB°¡ ±úÁ³½À´Ï´Ù. Àοë°ú ÇÔ²² ´äº¯

kobi ¾¸:
mysql> select * from board;
ERROR 1030: Got error -1 from table handler

ÀÌ·± ¿À·ù°¡ ³ª³×¿ä..
¾î¶»°Ô »ì¸±¼ö ÀÖÀ»±î¿ä??
¤Ð¤Ð


mysql DB Å×À̺íÀÌ ±úÁø °Í °°½À´Ï´Ù.

Å×À̺íÀÌ MyISAM ŸÀÔÀÌ¸é ´ÙÀ½°ú °°ÀÌ ÇÏ¿© º¹±¸ÇÒ ¼ö ÀÖ½À´Ï´Ù.
( MySQLȨ/data/DB¸í/Å×À̺í.MYD, .MYI¶ó¸é MyISAM)

ÄÚµå:

myisamchk -r -q DBÅ×À̺í°æ·Î ¶Ç´Â
myisamchk -o DB°æ·Î


DB¸í=abcd, table=test ÀÌ°í DB°¡ /usr/local/mysql/data/¿¡ ÀÖ´Ù¸é
¿¹) myisamchk -r -q /usr/local/mysql/data/abcd/test

ISAM ŸÀÔÀ̸é ( Å×À̺í.ISD, Å×À̺í.ISMÀ̸é ISAM)

ÄÚµå:

isamchk -r -q DB°æ·Î ¶Ç´Â
isamchk -o DB°æ·Î 


ÀÚ¼¼ÇÑ ±ÛÀº ´ÙÀ½À» Âü°í Çϼ¼¿ä.
http://coffeenix.net/board_view.php?bd_code=102
À§·Î
»ç¿ëÀÚ Á¤º¸ º¸±â ºñ¹Ð ¸Þ½ÃÁö º¸³»±â ±Û ¿Ã¸°ÀÌÀÇ À¥»çÀÌÆ® ¹æ¹®
ÀÌÀü ±Û Ç¥½Ã:   
±Û ¾²±â   ´äº¯ ´Þ±â    Ä¿ÇǴнº, ½Ã½ºÅÛ ¿£Áö´Ï¾îÀÇ ½°ÅÍ °Ô½ÃÆÇ À妽º -> ½Ã½ºÅÛ ¼³Ä¡ ¹× ¿î¿µ ½Ã°£´ë: GMT + 9 ½Ã°£(Çѱ¹)
ÆäÀÌÁö 1 Áß 1

 
°Ç³Ê¶Ù±â:  
»õ·Î¿î ÁÖÁ¦¸¦ ¿Ã¸± ¼ö ¾ø½À´Ï´Ù
´ä±ÛÀ» ¿Ã¸± ¼ö ¾ø½À´Ï´Ù
ÁÖÁ¦¸¦ ¼öÁ¤ÇÒ ¼ö ÀÖ½À´Ï´Ù
¿Ã¸° ±ÛÀ» »èÁ¦ÇÒ ¼ö ¾ø½À´Ï´Ù
ÅõÇ¥¸¦ ÇÒ ¼ö ¾ø½À´Ï´Ù


Powered by phpBB © 2001, 2005 phpBB Group