[mysql] show databases - ÀÛ¼ºÀÚ : san2(at)linuxchannel.net *ÁÖ) LSN¿¡ ¿Ã·È´ø TIPÀ» ´Ù½Ã °¡Á®¿Ô½À´Ï´Ù. ---------------------------- ¾ÆÁ÷ ¸ð¸£½Ã´Â ºÐÀ» À§Çؼ­ Àû¾î ³õ½À´Ï´Ù. mysql> SHOW DATABASES; ÀÌ¿Í °°ÀÌ Äõ¸®¸¦ Àü¼ÛÇÏ¸é ¸ðµç µ¥ÀÌÅͺ£À̽º ¸ñ·ÏÀÌ Ãâ·ÂµË´Ï´Ù. (±× ±ÇÇÑÀ» °¡ÁöÁö ¾ÊÀº À¯Àú¶óÇÒÁö¶óµµ..) º¸¾È»ó, ÇØ´ç ±ÇÇѸ¸ ÀÖ´Â DB¸¦ Ãâ·ÂÇØÁÖ´Â °ÍÀÌ ÁÁ½À´Ï´Ù. Áï mysqlÀ» ½ÇÇàÇÒ¶§, # safe_mysqld --safe-show-database & ¶Ç´Â ------ /root/.my.cnf (or /etc/my.cnf or DATA_DIR/my.cnf) ------- [mysqld] ... safe-show-database ... ---------------------------------------- ÀÌ¿Í °°ÀÌ ½ÇÇàÇÏ¸é ±ÇÇѸ¸ °¡Áö´Â DB¸¸ Ãâ·ÂÇÕ´Ï´Ù. (ÈÄÀÚ ±ÇÀå) ±×¿Ü '--skip-show-database' ¿É¼ÇÀ» »ç¿ëÇϸé 'SHOW DATABASES' ±¸¹® »ç¿ëÀ» ¾Æ¿¹ ±ÝÁö½Ãŵ´Ï´Ù. =============================== ±×¿Ü Àâ´ÙÇÑ »çÇ× mysql> SELECT NOW(); mysql> SELECT NOW (); ÈÄÀÚÀÇ °æ¿ì(ÇÔ¼ö µÚ¿¡ °ø¹é ¹«½Ã)¸¦ Çã¿ëÇÏ·Á¸é? --------- /etc/my.cnf ------------- [mysql] ignore-spaces ... -------------------------------------- ¶Ç´Â --------- $HOME/.my.cnf ------------- [mysql] ignore-spaces ... -------------------------------------- ========================= (2002.08.12 Ãß°¡»çÇ×) ========================= [client] ¼½¼Ç¿¡ ³ÖÀ¸¸é mysqldump³ª '--ignore-space' ¿É¼ÇÀ» »ç¿ëÇÏÁö ¾ÊÀº ÇÁ·Î±×·¥¿¡ ¹®Á¦°¡ ÀÖ±º¿ä.. [mysql] ¼½¼Ç¿¡¸¸ ¼³Á¤ÇÏ´Â °ÍÀÌ ÁÁ°Ú±º¿ä.