ÀÌÀü ÁÖÁ¦ º¸±â :: ´ÙÀ½ ÁÖÁ¦ º¸±â |
±Û¾´ÀÌ |
¸Þ½ÃÁö |
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]#
ÀÌ·± ¿À·ù°¡ ³³´Ï´Ù..
¾î¶»°ÔÇؾßÇÏÁÒ?? _________________ ¸ð¸£´Â°Ô Âü ¸¹³×¿©..¤Ð¤Ð |
|
À§·Î |
|
|
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´Â ¾îµð¿¡ ÀÖÁÒ?? |
|
|
¸ð¸£´Â°Ô ÁÏ´Ï´Ù..
Á˼ÛÇÕ´Ï´Ù.. ÀÚ²Ù ¹°¾î¼¿ä..
ã¾Æ ´Ù³æ´Âµ¥ ¸øã°Ú¾î¿ä..¤Ð¤Ð _________________ ¸ð¸£´Â°Ô Âü ¸¹³×¿©..¤Ð¤Ð |
|
À§·Î |
|
|
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
ÀÌ°Ç ¿Ö±×·¸ÁÒ??
ÀÚ¼¼ÇÑ ´äº¯ÇØ Áּż Ç×»ó °¨»çÇÕ´Ï´Ù.. _________________ ¸ð¸£´Â°Ô Âü ¸¹³×¿©..¤Ð¤Ð |
|
À§·Î |
|
|
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 ÀÌ·¸°Ô ¸¸µå¸éµÇ³ª¿ä?? _________________ ¸ð¸£´Â°Ô Âü ¸¹³×¿©..¤Ð¤Ð |
|
À§·Î |
|
|
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
ÀÌ·± ¿À·ù°¡ ³ª³×¿ä..
¾î¶»°Ô »ì¸±¼ö ÀÖÀ»±î¿ä??
¤Ð¤Ð _________________ ¸ð¸£´Â°Ô Âü ¸¹³×¿©..¤Ð¤Ð |
|
À§·Î |
|
|
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 |
|
À§·Î |
|
|
|