iWiz ShareBase

IT Specialist À±ÅÂÇöÀÇ iWiz ShareBase´Â IT»Ó ¾Æ´Ï¶ó °¢Á¾ Àâ´ÙÇÑ Áö½ÄµéÀ» ÇÔ²² ³ª´©´Â Áö½Ä°øÀ¯ Ä¿¹Â´ÏƼÀÔ´Ï´Ù.

iWiz,ShareBase,À±ÅÂÇö,Java,JSP,EJB,IT,Á¤º¸±â¼ú,À¥ÇÁ·Î±×·¡¹Ö,PHP,ASP,DBMS,MySQL,¼­¹ö,³×Æ®¿öÅ©,server,network,WAS,À¥¾ÖÇø®ÄÉÀ̼Ç,ºí·Î±×,blog,À¥¼­¹ö,DB,¿À¶óŬ,oracle,mysql,JRun,À¥·ÎÁ÷,ÅèĹ,tomcat,¾ÆÆÄÄ¡,ÀÚµ¿Â÷,EF½î³ªÅ¸,·Î¶Ç 6/45

°¶·¯¸® Pixelgrapher.com | ·Î¶Ç 6/45 ¹øÈ£»ý¼º ¹× Åë°è µ¥ÀÌÅÍ | Àüü±â»çº¸±â | Àüü±Û #1 | Àüü±Û #2 | Àüü±Û #3 | Àüü±Û #4 | Àüü±Û #5 | Àüü±Û #6 | Àüü±Û #7 | Àüü±Û #8 | Àüü±Û #9 | Àüü±Û #10 |
HOME iWiz
ShareBase
Remember 0523 & 0818
Áö½ÄÀº ³ª´­¼ö·Ï Ä¿Áý´Ï´Ù - iWiz's ShareBase
µ¥ÀÌÅͺ£À̽º µ¥ÀÌÅͺ£À̽º(DBMS)¿¡ °ü·ÃµÈ °¢Á¾ ÀÚ·áµéÀÔ´Ï´Ù.


  iWiz(2004-01-04 23:10:37, Hit : 6488, Vote : 35
 http://www.wz.pe.kr

MySQL °ü·Ã Àâ´ÙÇÑ ¸í·É¾î ¸ðÀ½


¡á »ç¿ëÀÚ »ý¼º ¹× ±ÇÇÑ ÁÖ±â

- ROOT Æнº¿öµå º¯°æ
SET PASSWORD FOR root@localhost = PASSWORD('rootpasswd');

- ¸ðµç DBÀÇ ¸ðµç Å×ÀÌºí¿¡ ´ëÇÑ ±ÇÇÑÀ» root »ç¿ëÀÚ¿¡°Ô ºÎ¿© (210.207.73.1* IP¿¡¼­¸¸ Á¢¼Ó °¡´É)
GRANT ALL PRIVILEGES ON *.* TO root@'210.207.73.1%'
IDENTIFIED BY 'rootpasswd' WITH GRANT OPTION;

- smipc DB³»ÀÇ Å×ÀÌºí¿¡ ´ëÇÑ ¸ðµç ±ÇÇÑÀ» webuser¿¡°Ô ÁÖ±â (localhost¿¡¼­¸¸ Á¢¼Ó °¡´É)
GRANT ALL PRIVILEGES ON websvc.* TO webuser@localhost
IDENTIFIED BY 'userpasswd' WITH GRANT OPTION;

- smipc DB³»ÀÇ Å×ÀÌºí¿¡ ´ëÇÑ ¸ðµç ±ÇÇÑÀ» admin¿¡°Ô ÁÖ±â (¸ðµç È£½ºÆ®¿¡¼­ Á¢¼Ó °¡´É)
GRANT ALL PRIVILEGES ON websvc.* TO webuser@"%"
IDENTIFIED BY 'userpasswd' WITH GRANT OPTION;

FLUSH PRIVILEGES; => ÀÌ ¸í·ÉÀ» ÇØÁÖ¾î¾ß¸¸ ±ÇÇÑ ³»¿ëÀÌ Àû¿ëµÊ.

¡á »óÅ º¸±â
ÇÁ·Î¼¼½ºº¸±â : mysqladmin -uroot -prootpasswd -i1 proc status
Åë°èº¸±â : SHOW STATUS;

¡á ¿ø°ÝÈ£½ºÆ® Á¢¼Ó
mysql -hSERVER_NAME -uwebuser -p websvc

¡á MySQL ¼³Ä¡ ÈÄ ÁÖÀÇ»çÇ×

- mysqlÀº root ±ÇÇÑÀ¸·Î µ¹¸®Áö ¾Êµµ·Ï ÁÖÀÇ.
- test °èÁ¤ »èÁ¦.
- mysql root »ç¿ëÀÚ¿¡°Ô Æнº¿öµå ºÎ¿©.
- ÀûÀýÇÑ ±ÇÇÑÀ» °®´Â »ç¿ëÀÚ »ý¼º.
- ÀÚµ¿½ÇÇà ¹× Á¾·áµÇµµ·Ï init script¿¡ ³Ö±â

¡á Å×ÀÌºí ¹é¾÷ (root·Î)
BACKUP TABLE tbl_name[,tbl_name...] TO '/path/to/backup/directory'

¡á Å×ÀÌºí ¸®½ºÅä¾î (root·Î)
RESTORE TABLE tbl_name[,tbl_name...] FROM '/path/to/backup/directory'

¡á Å×À̺í ÃÖÀûÈ­ (µ¥ÀÌÅÍ ´ë·® »èÁ¦ µî Å« º¯µ¿»çÇ× µîÀÌ ÀÖ¾úÀ»¶§)
OPTIMIZE TABLE tbl_name[,tbl_name]...

¡á µ¥ÀÌÅͺ£À̽º ´ýÇÁ
mysqldump [OPTIONS] database [tables] > backup-file.sql
mysqldump [OPTIONS] --databases [OPTIONS] DB1 [DB2 DB3...] > (dumpfile)
mysqldump [OPTIONS] --all-databases [OPTIONS] > (dumpfile)

¡á ´ýÇÁµ¥ÀÌÅÍ ¸®½ºÅä¾î
mysql database < backup-file.sql
mysql -e "source /patch-to-backup/backup-file.sql" database

¡á ´Ù¸¥ µÎ ¼­¹öÀÇ mysql°£ÀÇ µ¥ÀÌÅͺ£À̽º ´ýÇÁ
mysqldump --opt database | mysql --host=remote-host -C database



22   ¿À¶óŬ ¹«·á °ü¸® ÅøÀÌ À־ ¼Ò°³ ÇÕ´Ï´Ù. [1]  ±è±â¿µ 2007/04/28 8372 0
21   Default Temporary Tablespace ¼öÁ¤  ¹ÚÁã 2004/05/03 9043 44
20   ¸®µÎ·Î±× ÆÄÀÏÀÇ drop / add / relocation ¹× rename  ¹ÚÁã 2004/04/22 7143 33
19   ¿À¶óŬÀÇ Undo Segment [3]  ¹ÚÁã 2004/04/06 9199 38
18   import À¯Æ¿¸®Æ¼ [3]  ¹ÚÁã 2004/04/01 6612 35
17   ¼¼¼Ç°ü¸®  ¹ÚÁã 2004/03/31 8238 31
16   LogMiner  ¹ÚÁã 2004/03/31 7425 39
15   ¿À¶óŬ¿¡¼­ÀÇ ¹é¾÷...  ¹ÚÁã 2004/03/30 6410 40
14   ¿À¶óŬÀÇ Constraint(Á¦¾àÁ¶°Ç)  ¹ÚÁã 2004/03/26 37674 38
13   Export À¯Æ¿¸®Æ¼ [1]  ¹ÚÁã 2004/03/23 5769 35
12   ºñ±³ / ³í¸® ¿¬»êÀÚ ¹× ¿¬»ê ¿ì¼± ¼øÀ§  ¹ÚÁã 2004/03/22 9409 41
11   NULLÀ̶õ?? [2]  ¹ÚÁã 2004/03/22 8081 32
10   µ¥ÀÌŸ º£À̽ºÀÇ STARTUP°ú SHUTDOWN  ¹ÚÁã 2004/03/19 5543 34
9   ¿À¶óŬ Architecture  ¹ÚÁã 2004/03/19 5380 32
8   ¿Ü¿öµµ ¿Ü¿öµµ ±î¸Ô´Â ¿À¶óŬ ÇÔ¼ö (¹Ø¿¡²¨ ÆÛ°¡´Â ´ë½Å ¤¾) [1]  ÀÌÁØÈ£ 2004/07/15 12021 43

1 [2]
 

Copyright 1999-2025 Zeroboard / skin by zero
iWiz ShareBase, ¨ÏCopyleft by iWiz.  For more information contact .
º» À¥»çÀÌÆ®¿¡ °Ô½ÃµÈ À̸ÞÀÏ ÁÖ¼Ò°¡ ÀüÀÚ¿ìÆí ¼öÁý ÇÁ·Î±×·¥À̳ª ±× ¹ÛÀÇ ±â¼úÀû ÀåÄ¡¸¦ ÀÌ¿ëÇÏ¿© ¹«´ÜÀ¸·Î ¼öÁýµÇ´Â °ÍÀ» °ÅºÎÇϸç, À̸¦ À§¹Ý½Ã¿¡´Â Á¤º¸Åë½Å¸Á¹ý¿¡ ÀÇÇØ Çü»çó¹úµÊÀ» À¯³äÇϽñ⠹ٶø´Ï´Ù. [°Ô½ÃÀÏ 2004. 1. 31]