http://www.phpschool.com/gnuboard4/bbs/board.php?bo_table=qna_db Å×½ºÆ® ¹öÀü 0.2 (2004-04-26) ko http://www.phpschool.com/gnuboard4/bbs/board.php?bo_table=qna_db&wr_id=198076  NO INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
 id VARCHAR(10) NOT NULL,
 NAME VARCHAR(10) NOT NULL,
 email VARCHAR(20) NOT NULL,
 birthday CHAR(8) NOT NULL,
 avatar VARCHAR(20) NOT NULL
)

ÀÌ·±½ÄÀ¸·Î Å×ÀÌºí ¸¸µé¶§ auto_incrementÇÏÀÝ¾Æ¿ä ±Ùµ¥ ±× ÃʱⰪÀ» Å×ÀÌºí »ý¼º½Ã¿¡ ÁöÁ¤ÇØÁÙ¼ö ÀÖÀ»±î¿ä?

¾Æ´Ï¸é Å×ÀÌºí »ý¼ºÈÄ¿¡ µû·Î Äõ¸®¹®À» ½á¼­ ÁöÁ¤ÇؾßÇÒ°Å °°Àºµ¥ Á¦°¡ ÃʱⰪÀ» 10000000À¸·Î ÇÏ°í ½ÍÀºµ¥ ¾î¶»°Ô ÇؾßÇÒ±î¿ä?]]> ¼Ò¿¬* Thu, 20 Jun 2013 15:30:05 +0900 http://www.phpschool.com/gnuboard4/bbs/board.php?bo_table=qna_db&wr_id=198074     °úÁ¦ÇØ°á ¶Ç´Â ¼Ò½º¸¦ Â¥´Þ¶ó°í ºÎŹÇϰųª ´äº¯ÀÚ¿¡°Ô ¸·¸»ÇÒ °æ¿ì °èÁ¤ ºí·°Ã³¸® ÇÕ´Ï´Ù.

/usr/local/mysql ¿¡ mysql À» ¼³Ä¡ÇÏ°í datadir=/usr/local/mysql/data
¿´½À´Ï´Ù.

±×·±µ¥ ¹ÙÀ̳ʸ® ·Î±×°¡ µ¢Ä¡°¡ ³Ê¹« Ä¿Á®¼­ Çϵ带 Ãß°¡ÇϰԵƴµ¥
Ãß°¡µÈ Çϵ带 ¸¶¿îÆ®Çؼ­ ¾²±â·Î Ç߰ŵç¿ä.
±×·¡¼­ /usr/local/mysql/data1À̶ó´Â Æú´õ¸¦ »ý¼ºÇؼ­ °Å±â¿¡ ¸¶¿îÆ®¸¦ ÇÏ°í
±âÁ¸ÀÇ data¸¦ ÀÌ Æú´õ¿¡ º¹»çÇÏ°íÀÖ¾ú´Âµ¥....
/ÀÇ ¿ë·®µµ °°ÀÌ Áõ°¡Çϳ׿ä..;;;
°á±¹ °ø°£ÀÌ ¾ø¾î¼­ º¹»çÇϱⰡ ½ÇÆÐÇß½À´Ï´Ù.;;

ÀÌ°Ô ¿ÖÀÌ·±°ÅÁÒ?? ¸¶¿îÆ®¸¦ ÇßÀ¸´Ï±î data1À̶ó´Â Æú´õ´Â µ¶¸³ÀûÀÎ °ø°£ÀÌ µÇ´Â°Ô ¾Æ´ÑÁö¿ä.;;]]> LittleBomb Thu, 20 Jun 2013 15:20:59 +0900 http://www.phpschool.com/gnuboard4/bbs/board.php?bo_table=qna_db&wr_id=198062     °úÁ¦ÇØ°á ¶Ç´Â ¼Ò½º¸¦ Â¥´Þ¶ó°í ºÎŹÇϰųª ´äº¯ÀÚ¿¡°Ô ¸·¸»ÇÒ °æ¿ì °èÁ¤ ºí·°Ã³¸® ÇÕ´Ï´Ù.

ÀÏÀÏ ¸®Æ÷Æ® Ãâ·Â °ü·ÃÇؼ­ ¹®Àǵå·Á¿ä~

µ¥ÀÌŸ°¡
µ¥ÀÌŸ1 2013-06-18
µ¥ÀÌŸ2 2013-06-18
µ¥ÀÌŸ3 2013-06-20

À§¿Í °°ÀÌ 19ÀÏ µ¥ÀÌŸ°¡ Çϳªµµ ¾øÀ»°æ¿ì 0 À¸·Î ³ª¿À°Ô ÇÏ°í ½ÍÀºµ¥¿ä

SELECT COUNT(Ä÷³) FROM TABLE GROUP BY ³¯Â¥

2013-06-18 2
2013-06-19 0
2013-06-20 1

¾î¶»°Ô ÇÏ¸é µÇ³ª¿ä??]]> ¹ßÄÚµù¢â Thu, 20 Jun 2013 13:53:19 +0900 http://www.phpschool.com/gnuboard4/bbs/board.php?bo_table=qna_db&wr_id=198060 LittleBomb Thu, 20 Jun 2013 13:50:41 +0900 http://www.phpschool.com/gnuboard4/bbs/board.php?bo_table=qna_db&wr_id=198057 1-1. Lost connection to MySQL server during query(´ÝÀ» DB °´Ã¼°¡ Á¸ÀçÇÏÁö ¾Ê½À´Ï´Ù.)Lost connection to MySQL server during query[2013]

1-2. (DB Á¢¼Ó ¿À·ù ÀÔ´Ï´Ù.)Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)[2002]

Å×ÀÌºí ¹é¾÷À» ¶ã·Á°í /usr/loacl/mysql/bin/mysqldump -u root -p table > table.sql À» ÇÏ¸é ¾Æ·¡ ¿¡·¯°¡ ³ª¿É´Ï´Ù.
2. mysqldump: Got error: 2013: Lost connection to MySQL server during query when using LOCK TABLES
´ýÇÁ¶ã¶§ ¾Æ·¡¿¡ ¿¡·¯ ¸Þ½ÃÁöº¸¸é
.
.
.....LOCK TABLES `MVO` READ......
thd->thread_id=228
thd->killed=NOT_KILLED
ÀÌ°ÅÀ§¿¡ Å×ÀÌºí ¶ôÀ̶ó´Â ¸Þ½ÃÁö°¡³ª¿É´Ï´Ù..

OS ¹öÀü :
Linux localhost.localdomain 2.6.18-348.3.1.el5 #1 SMP Mon Mar 11 19:39:25 EDT 2013 x86_64 x86_64 x86_64 GNU/Linux
CentOS release 5.9 (Final)
Kernel \r on an \m

MYSQL ¹öÀü : mysql  Ver 14.14 Distrib 5.1.32, for unknown-linux-gnu (x86_64) using readline 5.1
Apache ¹öÀü : Server version: Apache/2.2.22 (Unix) Server built:  Mar 14 2013 15:54:40


µµ¿ÍÁÖ¼¼¿ä ¤Ð¤Ð....

-----------------÷ºÎÆÄÀÏ---------------------
1.top¸í·É¾î.bmp
2.df -h¸í·É¾î.bmp

¾Æ·¡ µÎ°³ ÆÄÀÏÀº ÷ºÎ°¡ ¾ÈµÇ¾î ÇÏ´Ü¿¡ ºÙ¿©³õ¾Ò½À´Ï´Ù.................
3.localhost.localdomain.err.txt
4.my.cnf.txt

÷ºÎÆÄÀÏ¿¡ service mysqld stop ÈÄ startÇÑ ½ÃÁ¡ºÎÅÍ 1-1,2 ¿¡·¯°¡ ³ª¿Â°Í°ú 2¹ø ¿¡·¯°¡ ³ª¿Â ºÎºÐÀ» localhost.localdomain.err.txt ·Î ÷ºÎÇÏ¿´½À´Ï´Ù.

¶ÇÇÑ my.cnf ÆÄÀÏÀ» my.cnf.txt À¸·Î ÷ºÎÇÏ¿´½À´Ï´Ù.

¸Þ¸ð¸® 8G ½º¿Ò¸Þ¸ð¸® 16G, CPU 4°³ =  top¸í·É¾î.bmp ÆÄÀÏ¿¡ ½ºÅ©¸°¼¦À» Âï¾ú½À´Ï´Ù.
¿ë·® Á¤º¸´Â df -h¸í·É¾î.bmp ÆÄÀÏ¿¡ ½ºÅ©¸°¼¦À» Âï¾ú½À´Ï´Ù.

----------------------------------------------------------------------------------------
localhost.localdomain.err.txt ½ÃÀÛ
----------------------------------------------------------------------------------------

InnoDB: File name ./data
InnoDB: File operation call: 'stat'.
InnoDB: Error: os_file_readdir_next_file() returned -1 in
InnoDB: directory .
InnoDB: Crash recovery may have failed for some .ibd files!
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Last MySQL binlog file position 0 2904, file name ./mysql-bin.000102
130620 11:34:39  InnoDB: Started; log sequence number 0 1380773037
130620 11:34:39 [Note] Recovering after a crash using mysql-bin
130620 11:34:39 [Note] Starting crash recovery...
130620 11:34:39 [Note] Crash recovery finished.
130620 11:34:39 [Note] Event Scheduler: Loaded 0 events
130620 11:34:39 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.32-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
130620 11:35:31 [Note] /usr/local/mysql/libexec/mysqld: Á¤»óÀûÀÎ shutdown

130620 11:35:31 [Note] Event Scheduler: Purging the queue. 0 events
130620 11:35:31  InnoDB: Starting shutdown...
130620 11:35:34  InnoDB: Shutdown completed; log sequence number 0 1380774823
130620 11:35:34 [Note] /usr/local/mysql/libexec/mysqld: Shutdown ÀÌ ¿Ï·áµÊ!

130620 11:35:34 mysqld_safe mysqld from pid file /usr/local/mysql/data/localhost.localdomain.pid ended
130620 11:35:46 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
130620 11:35:47 [Warning] The syntax '--log_slow_queries' is deprecated and will be removed in MySQL 7.0. Please use '--slow_query_log'/'--slow_query_log_file' instead.
130620 11:35:50  InnoDB: Started; log sequence number 0 1380774823
130620 11:35:50 [Warning] 'user' entry 'root@localhost.localdomain'; ignored in --skip-name-resolve mode.
130620 11:35:50 [Warning] 'user' entry '@localhost.localdomain' ignored in --skip-name-resolve mode.
130620 11:35:50 [Note] Event Scheduler: Loaded 0 events
130620 11:35:50 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.32-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
130620 11:36:41  InnoDB: Error: (1500) Couldn't read the MAX(seq) autoinc value from the index (PRIMARY).
130620 11:36:41  InnoDB: Assertion failure in thread 47661448767808 in file handler/ha_innodb.cc line 2595
InnoDB: Failing assertion: error == DB_SUCCESS
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/forcing-recovery.html
InnoDB: about forcing recovery.
130620 11:36:41 - mysqld got signal 6 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help diagnose
the problem, but since we have already crashed, something is definitely wrong
and this may fail.

key_buffer_size=536870912
read_buffer_size=4194304
max_used_connections=2
max_threads=512
threads_connected=2
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 4723788 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

thd: 0x11ff7f70
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0x2b590bb920e0 thread_stack 0x40000
/usr/local/mysql/libexec/mysqld(my_print_stacktrace+0x24) [0x75f504]
/usr/local/mysql/libexec/mysqld(handle_segfault+0x322) [0x58c6a2]
/lib64/libpthread.so.0 [0x3a52a0eca0]
/lib64/libc.so.6(gsignal+0x35) [0x3a522302c5]
/lib64/libc.so.6(abort+0x110) [0x3a52231d70]
/usr/local/mysql/lib/mysql/plugin/ha_innodb.so [0x2b57e6a6b0c7]
/usr/local/mysql/libexec/mysqld(handler::ha_open(st_table*, char const*, int, int)+0x3f) [0x67971f]
/usr/local/mysql/libexec/mysqld(open_table_from_share(THD*, st_table_share*, char const*, unsigned int, unsigned int, unsigned int, st_table*, bool)+0x4dc) [0x5e4b7c]
/usr/local/mysql/libexec/mysqld [0x5de2f0]
/usr/local/mysql/libexec/mysqld(open_table(THD*, TABLE_LIST*, st_mem_root*, bool*, unsigned int)+0x799) [0x5dfab9]
/usr/local/mysql/libexec/mysqld(open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int)+0x650) [0x5e0df0]
/usr/local/mysql/libexec/mysqld(open_and_lock_tables_derived(THD*, TABLE_LIST*, bool)+0x36) [0x5e1116]
/usr/local/mysql/libexec/mysqld [0x596e9a]
/usr/local/mysql/libexec/mysqld(mysql_execute_command(THD*)+0x182e) [0x59c21e]
/usr/local/mysql/libexec/mysqld(mysql_parse(THD*, char const*, unsigned int, char const**)+0x228) [0x5a2528]
/usr/local/mysql/libexec/mysqld(dispatch_command(enum_server_command, THD*, char*, unsigned int)+0x3e3) [0x5a2913]
/usr/local/mysql/libexec/mysqld(do_command(THD*)+0xe4) [0x5a3ac4]
/usr/local/mysql/libexec/mysqld(handle_one_connection+0x5d7) [0x5946e7]
/lib64/libpthread.so.0 [0x3a52a0683d]
/lib64/libc.so.6(clone+0x6d) [0x3a522d503d]
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0x11ffa820 = /*64.37.29.110/m_cp/cp_payment.php*/ SELECT count(*) FROM aVlive_stock where adid='mmstar' and kind='c'
thd->thread_id=46
thd->killed=NOT_KILLED
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
130620 11:36:42 mysqld_safe Number of processes running now: 0
130620 11:36:42 mysqld_safe mysqld restarted
130620 11:36:42 [Warning] The syntax '--log_slow_queries' is deprecated and will be removed in MySQL 7.0. Please use '--slow_query_log'/'--slow_query_log_file' instead.
InnoDB: Log scan progressed past the checkpoint lsn 0 1380778723
130620 11:36:44  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
130620 11:36:44  InnoDB: Operating system error number 2 in a file operation.
InnoDB: The error means the system cannot find the path specified.
InnoDB: If you are installing InnoDB, remember that you must create
InnoDB: directories yourself, InnoDB does not create them.

--------------------------------------------------------------------º»¹®ÀÇ 2¹ø¿¡ ÇØ´çµÇ´Â ¿¡·¯¸Þ½ÃÁö-----------------------------------------------------------

Version: '5.1.32-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
130620 11:44:29  InnoDB: Error: (1500) Couldn't read the MAX(seq) autoinc value from the index (PRIMARY).
130620 11:44:29  InnoDB: Assertion failure in thread 47661084760384 in file handler/ha_innodb.cc line 2595
InnoDB: Failing assertion: error == DB_SUCCESS
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/forcing-recovery.html
InnoDB: about forcing recovery.
130620 11:44:29 - mysqld got signal 6 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help diagnose
the problem, but since we have already crashed, something is definitely wrong
and this may fail.

key_buffer_size=536870912
read_buffer_size=4194304
max_used_connections=2
max_threads=512
threads_connected=1
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 4723788 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

thd: 0x2b58e8f85260
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0x2b58f606d0e0 thread_stack 0x40000
/usr/local/mysql/libexec/mysqld(my_print_stacktrace+0x24) [0x75f504]
/usr/local/mysql/libexec/mysqld(handle_segfault+0x322) [0x58c6a2]
/lib64/libpthread.so.0 [0x3a52a0eca0]
/lib64/libc.so.6(gsignal+0x35) [0x3a522302c5]
/lib64/libc.so.6(abort+0x110) [0x3a52231d70]
/usr/local/mysql/lib/mysql/plugin/ha_innodb.so [0x2b57c80fa0c7]
/usr/local/mysql/libexec/mysqld(handler::ha_open(st_table*, char const*, int, int)+0x3f) [0x67971f]
/usr/local/mysql/libexec/mysqld(open_table_from_share(THD*, st_table_share*, char const*, unsigned int, unsigned int, unsigned int, st_table*, bool)+0x4dc) [0x5e4b7c]
/usr/local/mysql/libexec/mysqld [0x5de2f0]
/usr/local/mysql/libexec/mysqld(open_table(THD*, TABLE_LIST*, st_mem_root*, bool*, unsigned int)+0x799) [0x5dfab9]
/usr/local/mysql/libexec/mysqld(open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int)+0x650) [0x5e0df0]
/usr/local/mysql/libexec/mysqld(open_and_lock_tables_derived(THD*, TABLE_LIST*, bool)+0x36) [0x5e1116]
/usr/local/mysql/libexec/mysqld(mysql_execute_command(THD*)+0x3de8) [0x59e7d8]
/usr/local/mysql/libexec/mysqld(mysql_parse(THD*, char const*, unsigned int, char const**)+0x228) [0x5a2528]
/usr/local/mysql/libexec/mysqld(dispatch_command(enum_server_command, THD*, char*, unsigned int)+0x3e3) [0x5a2913]
/usr/local/mysql/libexec/mysqld(do_command(THD*)+0xe4) [0x5a3ac4]
/usr/local/mysql/libexec/mysqld(handle_one_connection+0x5d7) [0x5946e7]
/lib64/libpthread.so.0 [0x3a52a0683d]
/lib64/libc.so.6(clone+0x6d) [0x3a522d503d]
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0x1c2566c0 = LOCK TABLES `MVO` READ /*!32311 LOCAL */,`MVO_COMMENT` READ /*!32311 LOCAL */,`aaaa_ADMIN` READ /*!32311 LOCAL */,`aaaa_CPA` READ /*!32311 LOCAL */,`aaaa_CPA_RESULT` READ /*!32311 LOCAL */,`aaaa_MEMBER` READ /*!32311 LOCAL */,`aaaa_PAYMENT` READ /*!32311 LOCAL */,`aaaa_PAYMENT_FAIL` READ /*!32311 LOCAL */,`aaaa_mem2mem` READ /*!32311 LOCAL */,`aaaa_payment_list` READ /*!32311 LOCAL */,`aaaa_referer` READ /*!32311 LOCAL */,`aaaa_site` READ /*!32311 LOCAL */,`aaaa_stock` READ /*!32311 LOCAL */,`aaaa_streaming` READ /*!32311 LOCAL */,`bbbb_ADMIN` READ /*!32311 LOCAL */,`bbbb_CPA` READ /*!32311 LOCAL */,`bbbb_CPA_RESULT` READ /*!32311 LOCAL */,`bbbb_MEMBER` READ /*!32311 LOCAL */,`bbbb_PAYMENT` READ /*!32311 LOCAL */,`bbbb_PAYMENT_FAIL` READ /*!32311 LOCAL */,`bbbb_QNA` READ /*!32311 LOCAL */,`bbbb_mem2mem` READ /*!32311 LOCAL */,`bbbb_notice` READ /*!32311 LOCAL */,`bbbb_payment_list` READ /*!32311 LOCAL */,`bbbb_referer` READ /*!32311 LOCAL */,
thd->thread_id=228
thd->killed=NOT_KILLEDThe manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
130620 11:44:30 mysqld_safe Number of processes running now: 0
130620 11:44:30 mysqld_safe mysqld restarted
130620 11:44:30 [Warning] The syntax '--log_slow_queries' is deprecated and will be removed in MySQL 7.0. Please use '--slow_query_log'/'--slow_query_log_file' instead.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
130620 11:44:32  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
130620 11:44:32  InnoDB: Operating system error number 2 in a file operation.
InnoDB: The error means the system cannot find the path specified.
InnoDB: If you are installing InnoDB, remember that you must create
InnoDB: directories yourself, InnoDB does not create them.

----------------------------------------------------------------------------------------
localhost.localdomain.err.txt ³¡
----------------------------------------------------------------------------------------





----------------------------------------------------------------------------------------
my.cnf.txt ½ÃÀÛ
----------------------------------------------------------------------------------------
#DESCR: 4GB RAM, InnoDB only, ACID, few connections, heavy queries

[client]
#password      = [your_password]
port            = 3306
socket          = /tmp/mysql.sock
#socket          = /usr/local/mysql/data/mysql.sock
character-set=utf8


[mysqld]

port            = 3306
#socket          = /usr/local/mysql/data/mysql.sock
ignore-builtin-innodb
plugin-load=innodb=ha_innodb.so

datadir = /usr/local/mysql/data
log_slow_queries = /usr/local/mysql/data/slow_query.log
init_connect = SET collation_connection = euckr-korean_ci
init_connect = SET NAMES euckr
default-character-set = euckr
language = /usr/local/mysql/share/mysql/korean
#init_connect=SET collation_connection = utf8_general_ci
#init_connect=SET NAMES utf8
#default-character-set=utf8
#character-set-server=utf8
#collation-server=utf8_general_ci


max_connections = 512
long_query_time = 5
connect_timeout = 1800
wait_timeout = 300
old_password = 1

log-bin=mysql-bin
skip-name-resolve
skip-locking
key_buffer = 512M
table_cache = 2048
max_allowed_packet = 128M
join_buffer_size = 4M
sort_buffer_size = 4M
read_buffer_size = 4M
read_rnd_buffer_size = 16M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
thread_concurrency = 4
query_cache_size = 256M
default-storage-engine = INNODB
default-table-type = INNODB

########## MyISAM ##########
key_buffer_size = 512M


############################## Part 2 ##############################


# *** INNODB Specific options ***
innodb_additional_mem_pool_size = 256M
innodb_buffer_pool_size = 4G
innodb_data_home_dir = /usr/local/mysql/data
innodb_data_file_path = ibdata1:2000M;ibdata2:2000M;ibdata3:2000M;ibdata4:2000M;ibdata5:2000M:autoextend
innodb_file_io_threads = 4
innodb_thread_concurrency = 8
innodb_log_buffer_size = 8M
innodb_log_file_size = 512M
innodb_log_files_in_group = 2
innodb_lock_wait_timeout = 60


############################## Part 3 ##############################


[mysqldump]
quick
max_allowed_packet = 128M

[mysql]
no-auto-rehash

[isamchk]
key_buffer = 512M
sort_buffer_size = 512M
read_buffer = 8M
write_buffer = 8M

[myisamchk]
key_buffer = 512M
sort_buffer_size = 512M
read_buffer = 8M
write_buffer = 8M

[mysqlhotcopy]
interactive-timeout

[mysqld_safe]
open-files-limit = 8192


----------------------------------------------------------------------------------------
my.cnf.txt ³¡
----------------------------------------------------------------------------------------]]> ¸®Æä·Î Thu, 20 Jun 2013 12:07:21 +0900 http://www.phpschool.com/gnuboard4/bbs/board.php?bo_table=qna_db&wr_id=198055 ¹öÆ° ´©¸£¸é ·£´ýÀ¸·Î Á¤ÇØÁø »ç¶÷Áß 1¸íÀ» »Ì´Â °É ¸¸µé¾ú½À´Ï´Ù. ( ÀÎÅÍ³Ý ¿¬°á¾øÀÌ ·ÎÄÃÁÖ¼Ò·Î)

¿©±â¼­ Àüü »ç¶÷Áß ÇѸíÀÌ »ÌÈ÷¸é ±× ÇÑ¸í ¿·¿¡ 1¹ø »ÌÇû´Ù¶ó´Â½ÄÀÇ Ä«¿îÆ®°¡ Áõ°¡Çϵµ·Ï
¸¸µé·Á°íÇϴµ¥ ¾î¶»°ÔÇϸé ÁÁÀ»Áö ±Ã±ÝÇÕ´Ï´Ù. -°ø¿ëÄÄÇ»ÅÍ¿¡¼­ Çϴ°Ŷó ÇÑ ÄÄÇ»ÅÍ¿¡¼­¸¸ ¾µ°Ì´Ï´Ù

db¸¦ ¿¬µ¿½ÃÄѾߵɰŰ°Àºµ¥ mysqlÀÌ ÀÎÅͳÝÀÌ ¾ÈµÇ´Â ȯ°æ¿¡¼­ °¡´ÉÇÑÁöµµ ±Ã±ÝÇÕ´Ï´Ù.

±»ÀÌ html·Î ¾È¸¸µé¾îµµ µË´Ï´Ù¸¸ ·ÎÄ÷Π°£´ÜÈ÷ ¾µ·Á°í ¸¸µç °³ÀοëÀ̱⶧¹®¿¡ ±×·¸½À´Ï´Ù..]]> dreaminz Thu, 20 Jun 2013 11:50:08 +0900 http://www.phpschool.com/gnuboard4/bbs/board.php?bo_table=qna_db&wr_id=198050
³ª¸§ ½É°¢ÇÑ µô·¹¸¶°¡ ¹ß»ýÇ߳׿ä.


°¢ ÁöÁ¡º° Á¦Ç°°ü¸® DBÀÔ´Ï´Ù.

ÁöÁ¡º°·Î Á¦Ç°À» µî·Ï(Á¦Ç°Å×À̺í)ÇÏ°í ¸ÅÃâ(¸ÅÃâÅ×À̺í)À» ±â·ÏÇÏ´Â TBµéÀε¥

Á¦Ç°¸íÀÌ ¾ø´Â. ´Ù½Ã¸»ÇØ ¹Ìµî·ÏÁ¦Ç°À» ÀÔ·ÂÇÏ°í ½Í½À´Ï´Ù.

Á¦Ç°Å×À̺í°ú ¸ÅÃâÅ×À̺íÀº FKÅ°·Î ¿¬°á½ÃÄ×½À´Ï´Ù.


Á¦Ç°Å×À̺í
no  =>  primary key,
branch => ÁöÁ¡¹øÈ£,
name => Á¦Ç°¸í,

¿µ¾÷Å×À̺í
no => primary key,
branch => ÁöÁ¡¹øÈ£,
Á¦Ç°.no => Á¦Ç°Å×À̺í.no (¿Ü·¡Å°,FK)
price => °¡°Ý

°£·«ÇÑ Å×ÀÌºí ¼³¸íÀÔ´Ï´Ù.

°¢ ÁöÁ¡¿¡¼­ °¢ÀÚ Á¦Ç°À» µî·ÏÇÏ°í ¿µ¾÷À» ±â·ÏÇÒ ¶§ ¹Ìµî·ÏÁ¦Ç°(Á¦Ç°Å×ÀÌºí¿¡ ¾ø´Â)À» µî·Ï½ÃÅ°°íÀÚ ÇÕ´Ï´Ù.

´Ù½Ã ¸»ÇØ ¿µ¾÷Å×À̺íÀÇ Á¦Ç°.no Çʵ忡 NULL°ªÀ̳ª 0°ªÀ¸·Î ÀԷ½ÃÅ°°íÀÚ ÇÕ´Ï´Ù.

NULL°ªÀ» ÀԷ½ÃÅ°´Â °ÍÀº ¹®Á¦°¡ ¾øÀ¸³ª Äõ¸® ½Ã ³Ê¹« ³­ÇØÇÑ ¼Ò½º°¡ ¸¸µé¾îÁö±¸¿ä,

0°ªÀº ÀÔ·ÂÇÒ ¹æ¹ýÀÌ ¾ø½À´Ï´Ù.(Á¦Ç°Å×ÀÌºí¿¡ 0°ªÀÌ ¾øÀ¸¹Ç·Î)

ÇöÀç ¼Ò½º°¡ »ó´çÈ÷ ÁøôµÈ »óȲ¿¡¼­ FKÅ°¸¦ ºÙÀÌ°í Àִµ¥

"SELECT * FROM ¿µ¾÷Å×À̺í WHERE Á¦Ç°.no='0'"(¿µ¾÷Å×ÀÌºí¿¡¼­ ¹Ìµî·ÏÁ¦Ç°À» ¸ðµÎ ã¾Æ¶ó)

 À¸·Î Äõ¸®¸¦ ³¯¸®´Â ÁÁÀº ¹æ¹ýÀÌ ¾øÀ»±î¿ä?

** Á¦Ç°Å×ÀÌºí¿¡ 1¹øÀ» ¹Ìµî·ÏÁ¦Ç°À¸·Î ÇÒ´çÇÏ´Â ¹æ¹ýÀº ºÒ°¡´ÉÇϱ¸¿ä~ ÀÌ°Ô ¾ÈµÇ¸é FKÅ°¸¦ Æ÷±âÇÏ´Â ¼ö ¹Û¿¡ ¾ø¾î¿ä ¤Ð¤Ð]]> À嵿°Ç¯ Thu, 20 Jun 2013 00:48:12 +0900 http://www.phpschool.com/gnuboard4/bbs/board.php?bo_table=qna_db&wr_id=198049     °úÁ¦ÇØ°á ¶Ç´Â ¼Ò½º¸¦ Â¥´Þ¶ó°í ºÎŹÇϰųª ´äº¯ÀÚ¿¡°Ô ¸·¸»ÇÒ °æ¿ì °èÁ¤ ºí·°Ã³¸® ÇÕ´Ï´Ù.

apmsetup À» Çؼ­ »õ·Î ±ò¾Ò´Âµ¥ ±ò¾Ò´ø local ¿¡¼­´Â myadminÀÌ µË´Ï´Ù.

±×·±µ¥ Áý¿¡¼­ ÀÛ¾÷À» ÇÏ·Á°í FTP ¶û ´Ù µé¾î°¡Áö´Âµ¥  ȨÇǵµ º¸ÀÌ°í Çϴµ¥

myadminÀº Á¢¼ÓÀÌ ¾ÈµÇ³×¿ä. ÀÌ°Å µû·Î ±ÇÇÑÀ» ¼³Á¤ÇØÁÖ¾î¾ß ÇÑ´Ù°íÇϴµ¥

¾îµð¼­ ¼³Á¤À» ÇØÁÖ³ª¿ä?

You don't have permission to access /myadmin/ on this server.]]> ²¤µ¿º¡ Thu, 20 Jun 2013 00:21:29 +0900 http://www.phpschool.com/gnuboard4/bbs/board.php?bo_table=qna_db&wr_id=198046 ÀÌ Ã³À½ mysql¸¦ ¼³Ä¡ÇÏ°í³ª¼­´Â ¾È³ª´Ù°¡ ¾î´À ¼ø°£ºÎÅÍ Á¢¼Ó·®ÀÌ ¸¹¾Æ Áú°æ¿ì À§ ¿¡·¯°¡ ³ª¿É´Ï´Ù.

ÀÌ ¿¡·¯°¡ ³ª¿À°í ¿ÏÀüÈ÷ connect°¡ ¾ÈµÇ´Â°Ç ¾Æ´Ï±¸¿ä..´Ù½Ã connectµÇ¾ú´Ù°¡ ¾ÈµÇ¾ú´Ù°¡ ÇÕ´Ï´Ù.

½Ã½ºÅÛ »ç¾çÀº centos 64ºñÆ®ÀÌ°í mysql 5.1.69¹öÀüÀÔ´Ï´Ù.
OS¸Þ¸ð¸®´Â 48±â°¡ÀÔ´Ï´Ù.
my.cnf¼³Á¤ ÆÄÀÏÀº
skip-name-resolve
skip-locking
max_allowed_packet = 2G
key_buffer_size = 4G
table_open_cache = 4096
sort_buffer_size = 512M
join_buffer_size = 512M
net_buffer_length = 256K
read_buffer_size = 512M
read_rnd_buffer_size = 512M
myisam_sort_buffer_size = 512M
myisam_max_sort_file_size = 512M
myisam_max_extra_sort_file_size = 512M
myisam_repair_threads = 1
thread_cache_size = 32
query_cache_size = 256M
thread_concurrency = 8
max_connections = 1000
wait_timeout = 5
log-slow-queries = mysql_slow.log
long_query_time = 3
ÀÔ´Ï´Ù.

mysqlÀº ÀÌÇø®ÄÉÀ̼ÇÀ¸·Î ¿î¿µµÇ°í ÀÕ½À´Ï´Ù
ÇöÀç À̼­¹ö´Â master±¸¿ä...slave¼­¹ö´Â ±×³É ¹é¾÷¿ëÀ¸·Î »ç¿ëÇÏ°í ÀÕ½À´Ï´Ù..
÷¿¡´Â ºÐ»êÀÌÀ¯·Î ¸¸µé¾ú´Âµ¥¿ä..slave¿¡·¯¶§¹®¿¡ ÀÚ²Ù ÁßÁöµÇ¾î¼­ ±×¶§ºÎÅÍ Á» È®½ÅÀÌ ¾È ³ª¼­ ±×³É ÀÏ´ÜÀº
¹é¾÷¿ëÀ¸·Î »ç¿ëÇÏ°í ÀÖ½À´Ï´Ù.

óÀ½ ¼³Ä¡ÇÏ°í ³ª¼­ ¸Þ¸ð¸® »ç¿ë·®Àº 48±â°¡Áß¿¡ 19±â°¡Á¤µµ¿´´Âµ¥¿ä( ÃÖ°íÄ¡°¡ 19±â°¡ Á¤µµ¿´½À´Ï´Ù)
ÇÑ ¸çÄ¥Áö³ª°í ³ª¼­(Á¤È®È÷´Â ¸ð¸£°Ú½À´Ï´Ù º° ¹®Á¦ ¾ø¾î¼­ ½Å°æ¾È ¾²°í À־¿ä) 48±â°¡Áß¿¡ 33±â°¡Á¤µµ
»ç¿ëÇÏ°í ÀÖ½À´Ï´Ù.
max_allowed_packet = 2G ÀÌ ºÎºÐÀÇ ÇÒ´ç·®ÀÌ ÀÛÀº°¡¿ä? ÀÌ°É ´õ ³ô¿©µµ µÉ·±Áö...???

±×¸®°í ¾Æ ¿øÀÎÀÌ Á¤È®È÷ ¹ºÁö ¸ð¸£°Ù½À´Ï´Ù. °©Àڱ⠸޸𸮻ç¿ë·®µµ ¿Ã¶ó°£ ÀÌÀ¯µµ ¸ð¸£°Ú±¸¿ä...

¹¹ ´õ ÇÊ¿äÇÑ Á¤º¸°¡ ÀÖÀ¸½Ã¸é ¸»¾¸ÇØ ÁÖ½Ã¸é ¾Ë·Áµå¸®°Ú½À´Ï´Ù.

±×·³ Áñ°Å¿î Àú³áµÇ¼¼¿ä~~]]> °ø¹«¿ø°øºÎ10³âÂ÷ Wed, 19 Jun 2013 19:03:01 +0900 http://www.phpschool.com/gnuboard4/bbs/board.php?bo_table=qna_db&wr_id=198045
sql Å×ÀÌºí¿¡ ÀÖ´Â id1°ª ¶Ç´Â id2 °ªÀÌ °°À» °æ¿ì, ÇØ´ç ÆäÀÌÁö¿¡¼­ ÇØ´ç count¸¦ ÆäÀÌÁö¿¡ ³ëÃâÇÏ·Á°í ÇÕ´Ï´Ù.

id1  id2  count  ...
100  aaa  120    ..

ÆäÀÌÁö¿¡ id1 °ª 100 ¶Ç´Â id2 °ªÀÌ ÇöÀç ÆäÀÌÁö ÁÖ¼Ò¿Í °°À»¶§ (¿¹-µµ¸ÞÀÎ.com/100 ¶Ç´Â µµ¸ÞÀÎ.com/aaa À϶§) 120 Ä«¿îÆ®¸¦ º¸¿©ÁÖ·Á°í ÇÕ´Ï´Ù.

idÀº Ç×»ó Á¸ÀçÇÏ°í, id2 °ªÀº Àְųª ¾ø´Â °æ¿ì°¡ ÀÖ½À´Ï´Ù.

Ãʺ¸ÀÔ´Ï´Ù. Ãʺ¸°¡ ÀÌÇØÇÒ ¼ö ÀÖ´Â ´äº¯°ú ¼³¸í ±â´Ù¸®°Ú½À´Ï´Ù. (__)]]> Ãʺ¸ÀÌ Wed, 19 Jun 2013 15:42:52 +0900 http://www.phpschool.com/gnuboard4/bbs/board.php?bo_table=qna_db&wr_id=198044 ȸ»ç »çÁ¤»ó... DB charsetÀ» utf8·Î ¹Ù²Ü ¼ö´Â ¾ø´Â »óÅÂÀÔ´Ï´Ù.

¾Æ·¡ ¼Ò½º¿¡¼­ echo $sqlÀ» Çϸé
À¥ ÆäÀÌÁö¿¡¼­´Â SELECT count(*) FROM ServiceArea WHERE area_1='¼­¿ï' order by seq desc
À̶ó°í Àß ³ª¿À´Âµ¥,
Total : ¿¡¼­´Â ¾Æ¹«·± °ªÀÌ ÂïÇô ³ª¿ÀÁö ¾Ê½À´Ï´Ù.
Å͹̳ηΠµé¾î°¡¼­ À§ sql¹®À» º¹»çÇؼ­ ³Ö¾îº¸¸é total°ªÀÌ ³ª¿À°í¿ä...

¾î¶»°Ô... ÇÏ¸é µÇ´ÂÁö ¾Ë·ÁÁֽøé... ³ªÁß¿¡ ²À~ µµ¿òÀÌ µÇ°Ú½À´Ï´Ù. °¨»çÇÕ´Ï´Ù.]]> ¿øÁ¶µ¹¸ÍÀÌ Wed, 19 Jun 2013 15:39:23 +0900 http://www.phpschool.com/gnuboard4/bbs/board.php?bo_table=qna_db&wr_id=198042     °úÁ¦ÇØ°á ¶Ç´Â ¼Ò½º¸¦ Â¥´Þ¶ó°í ºÎŹÇϰųª ´äº¯ÀÚ¿¡°Ô ¸·¸»ÇÒ °æ¿ì °èÁ¤ ºí·°Ã³¸® ÇÕ´Ï´Ù.

ÇöÀç mysql-5.5.28 À» »ç¿ëÁß¿¡ ÀÖ½À´Ï´Ù.
·Î±×DB¿ëÀ¸·Î »ç¿ëÇÏ´Â Àåºñ Àε¥...¹°¸®Àû ¸Þ¸ð¸®´Â 8G ÀÌ°í
innodb_buffer_pool_size = 4G ÇÒ´çÇß½À´Ï´Ù.

innodb¿£ÁøÀ̱¸¿ä.
innodb_data_file_path = ibdata1:3G;ibdata2:3G;ibdata3:3G;ibdata4:3G;ibdata5:3G;ibdata6:3G;ibdata7:3G;ibdata8:3G;ibdata9:3G;ibdata10:3G:autoextend
ÀÌ·¸°Ô Àâ¾Ò´Âµ¥..
µ¥ÀÌŸ°¡ ¸¹¾Æ¼­ ibdata10 ÀÌ ÇöÀç 33GÀÔ´Ï´Ù.
»õº®½Ã°£´ë¿¡ Master µðºñÀÇ µ¥ÀÌŸ¸¦ Àü¼Û¹Þ¾Æ ÀÌ Àåºñ¿¡ Data¸¦ ÀÔ·ÂÇÏ´Â ÇÕ´Ï´Ù.
select Äõ¸®µµ Åë°èÅøÀ» º¼¶§¸¸ ÀϾ°í ÇÑ ½Ã°£¿¡ ÇÑ µÎ¹ø Á÷¿øµéÀÌ È®ÀÎ ÇÏ´Â DBÀÔ´Ï´Ù.
¹®Á¦´Â ÀÌ ÀåºñÀÇ ¸Þ¸ð¸® »ç¿ë·üÀÌ 60%»ç¿ëÇÏ°í ÀÖ´Ù°í ³ª¿À³×¿ä.
óÀ½ ¼­ºñ½ºÇÒ¶§´Â 13%¿´´Âµ¥ Data°¡ ´Ã¾î³ª¸é¼­ ÇöÀç ¸Þ¸ð¸®¸¦ 60%±îÁö »ç¿ëÇÑ´Ù°í TopÀ̳ª ¸Þ¸ð¸® »ç¿ë·®À» º¸¸é ³ª¿É´Ï´Ù.
Data°¡ ¸¹¾ÆÁö¸é ¸Þ¸ð¸®¸¦ Áõ¼³ÇØ¾ß µÇ´Â °ÇÁö ¾Æ´Ô ´Ù¸¥ ÇØ°á ¹æ¹ýÀÌ ÀÖ´ÂÁö¿ä?]]> imshari Wed, 19 Jun 2013 11:16:36 +0900 http://www.phpschool.com/gnuboard4/bbs/board.php?bo_table=qna_db&wr_id=198040 VANDyke Wed, 19 Jun 2013 09:39:23 +0900 http://www.phpschool.com/gnuboard4/bbs/board.php?bo_table=qna_db&wr_id=198036     °úÁ¦ÇØ°á ¶Ç´Â ¼Ò½º¸¦ Â¥´Þ¶ó°í ºÎŹÇϰųª ´äº¯ÀÚ¿¡°Ô ¸·¸»ÇÒ °æ¿ì °èÁ¤ ºí·°Ã³¸® ÇÕ´Ï´Ù.


»çÀÌÆ® ÀÌÀüÀ¸·Î ÀÌ·¸°Ô sql Äõ¸®¸¦ ³¯·È½À´Ï´ç.


update xe_documents set content=replace(content,'A.com','B.com')


ÀÌ·¸°Ô Çϸé documents ºÎºÐ¿¡ Àִ°͸¸ ¹Ù²î´Â´ë,  Ä®·³ÀÌ xe_ a ~ z ±îÁö »ý°¢º¸´Ù ¸¹ÀÜ¾Æ¿ë ¤¾¤¾;

±×·¡¼­ ¾Æ¿¹ table Àüü¸¦ °Ë»öÇؼ­ Çѹ濡 ÀüȯÇÏ°í ½ÍÀº´ë, ¾î¶»°Ô Çϸé ÁÁÀ»±î¿ä T_T
-]]> ´©¶õÁö¼¼ Wed, 19 Jun 2013 05:49:41 +0900 http://www.phpschool.com/gnuboard4/bbs/board.php?bo_table=qna_db&wr_id=198032     °úÁ¦ÇØ°á ¶Ç´Â ¼Ò½º¸¦ Â¥´Þ¶ó°í ºÎŹÇϰųª ´äº¯ÀÚ¿¡°Ô ¸·¸»ÇÒ °æ¿ì °èÁ¤ ºí·°Ã³¸® ÇÕ´Ï´Ù.

À̹ÌÁö º¸½Ã¸é¼­ ^^
Á¦°¡ ¼Ò¼ÈÄ¿¸Ó½º ¼Ö·ç¼ÇÀ» (ÀÚü°³¹ßÇÑ ¼Ö·ç¼Ç) ¸ÅÀÔÀ» Çß½À´Ï´Ù
±×·±µ¥ ¹ÞÀº ÀÚ·á´Â ¾ÐÃàÀ̵Ǿî HDD ¿¡ ÀúÀåÈÄ Àú¿¡°Ô ¿Ô½À´Ï´Ù,,,
(¾Æ·¡±×¸²ÂüÁ¶..)
ÀÌ°Í°¡Áö°í ¼Ö·ç¼Ç °¡µ¿ÇÒ¼öÀÖÀ»Áö¿ä? ÀÚ·á°¡ ºÎÁ·ÇÑ°¡¿ä...¤Ñ¤Ñ;
°¡µ¿À» ÇÑ´Ù¸é ¾î¶»°Ô ÁغñÇØ¾ß ¼Ò¼ÈÄ¿¸Ó½º°¡ °¡µ¿ÀÌ µÉ±î¿ä?]]> ÄíÆùÁö Tue, 18 Jun 2013 19:28:02 +0900 http://www.phpschool.com/gnuboard4/bbs/board.php?bo_table=qna_db&wr_id=198031 ÇÑÂÊ Å×ÀÌºí¿¡ ƯÁ¤ °ªÀÌ °è¼Ó µé¾î°¡°í ÀÖ°í
´Ù¸¥ ÇÑÂÊÀº ÇöÀç ºñ¿öÀÖ´Â »óÅ ÀÔ´Ï´Ù
±×³É SELECT¸¦ Çؼ­ ±× °ªÀ» ºÒ·¯³Ö´Â°Å¶ó¸é ½±°Ô Çϰڴµ¥
status ¶ó´Â Ä®·³¿¡ START SKIP END ÀÌ·±½ÄÀ¸·Î °ªÀÌ µé¾î°©´Ï´Ù
status ¸¦ GROUP BY Çؼ­ START, SKIP, END °¡ ¸î°³ÀÎÁö¸¦ Ä«¿îÆ®Çؼ­
´Ù¸¥ Å×ÀÌºí¿¡ START_CNT, SKIP_CNT, END_CNT Ä®·³¿¡ ³ÖÀ»·Á°í Çϴµ¥
¾î¶² ½ÄÀ¸·Î ÇؾߵÉÁö °¨ÀÌ ÀâÈ÷Áú ¾Ê³×¿ä..]]> TheLastLeaf Tue, 18 Jun 2013 18:57:07 +0900 http://www.phpschool.com/gnuboard4/bbs/board.php?bo_table=qna_db&wr_id=198030     °úÁ¦ÇØ°á ¶Ç´Â ¼Ò½º¸¦ Â¥´Þ¶ó°í ºÎŹÇϰųª ´äº¯ÀÚ¿¡°Ô ¸·¸»ÇÒ °æ¿ì °èÁ¤ ºí·°Ã³¸® ÇÕ´Ï´Ù.


½ºÅä¾îµåÇÁ·Î½ÃÁ®·Î µ¥ÀÌÅÍ »èÁ¦¿¡ °üÇÑ ³»¿ëÀ» ¸¸µé¾îº¸·Á°í ÇÕ´Ï´Ù.
¿¹¸¦µé¾î ½Ã°£º°·Î ¿©·¯°³¾¿ ½×À̴µ¥ÀÌÅÍ Å×À̺íÀÌ Àִµ¥
ƯÁ¤³¯Â¥...¿¹¸¦µé¸é ÇöÀç·ÎºÎÅÍ 5ÀÏÀüÀÇ µ¥ÀÌÅÍ´Â »èÁ¦ÇÏ´Â ÇÁ·Î½ÃÁ®¸¦ ¸¸µé°í ½Í½À´Ï´Ù.

¸¸µå´Â¹æ¹ýÀ̳ª Àû¿ë½ÃÅ°´Â ¹æ¹ýÀº °øºÎÇؼ­ ÇØ°áÀÌ µÇ´Âµ¥
±×¾È¿¡ ¹®±¸¸¦ ¾î¶»°Ô ÇؾßÇÒÁö Àß ¸ð¸£°Ú½À´Ï´ç.¤Ð¤Ð

µµ¿ò ¿äûµå¸³´Ï´Ù.]]> LittleBomb Tue, 18 Jun 2013 18:06:30 +0900 http://www.phpschool.com/gnuboard4/bbs/board.php?bo_table=qna_db&wr_id=198027
ÇÁ·ÐÆ®ÆäÀÌÁö°¡ ÀÖ°í ³»ºÎÀûÀ¸·Î erp °¡ Àִµ¥

ƯÁ¤ ·¹Äڵ尡 ÀÚ²Ù ¼öÁ¤ÀÌ µÇ¾î°¡Áö°í ¿À·ù°¡ ³ª³×¿ä ¤Ð

Á¦°¡ Á¢±ÙÇÒ¼ö ÀÖ´Â ¼Ò½º´Â ÇÁ·ÐÆ® ÂÊÀÌ°í erp ´Â ±ÇÇÑÀ» ¾ÈÁִµ¥

ÇÁ·ÐÆ®ÂÊ ¼Ò½º¿¡¼­ ¼öÁ¤µÇ´Â Å×À̺í¸íÀ¸·Î update ÇÏ´Â ºÎºÐÀº ¾ø°í, ÇÁ·Î½ÃÀúµµ ¾ø½À´Ï´Ù.

¾Æ¹«¸®ºÁµµ erp ÂÊ¿¡¼­ update Äõ¸® ³¯¸®´Â°Å °°Àºµ¥ ÀÚ±âµéÀº ÀÚ²Ù ¾Æ´Ï¶ó°í ÇÏ´Ï±î ´ä´äÇϳ׿ä.

DBÂÊ¿¡¼­ ¾î¶² ÆäÀÌÁö¿¡¼­ Á¢±ÙÇß´ÂÁö ·Î±×¸¦ º¼¼ö ÀÖ´Â ±â´ÉÀÌ ÀÖÀ¸¸é ¾îµð°¡ ¹®Á¦ÀÎÁö µü ¾Ë°Å°°¾Æ¼­¿ä.


ÀÌ°ÍÀú°Í ã¾Æº¸°í Àִµ¥ DB ¼­¹öµµ Á¦¸¾´ë·Î ¸¸Áö±â¿£ Ÿ»çÀÌÆ®µéÀÌ ³Ê¹« ¸¹ÀÌ ¹­¿©À־

È®½ÇÇÑ ¹æ¹ýÀ¸·Î ÀÛ¾÷ÇÏ·Á°í Áú¹® ¿Ã¸³´Ï´Ù.

Ȥ½Ã ±×·± ¹æ¹ý ¾Æ½Ã´ÂºÐ ´äº¯ ºÎŹµå¸³´Ï´Ù.

º¹ÀâÇϸé ÇØ´ç ±â´É(?) ¿¡ °üÇÑ °Ë»ö¾î¶óµµ ÁÖ½Ã¸é °¨»çÇÏ°Ú½À´Ï´Ù.

Áñ°Å¿î ÇÏ·ç µÇ¼¼¿ä ~]]> bellstar Tue, 18 Jun 2013 14:57:41 +0900 http://www.phpschool.com/gnuboard4/bbs/board.php?bo_table=qna_db&wr_id=198023
mysql> show variables like 'c%';
+--------------------------+---------------------------------------------------------+
| Variable_name            | Value                                                  |
+--------------------------+---------------------------------------------------------+
| character_set_client    | utf8                                                    |
| character_set_connection | utf8                                                    |
| character_set_database  | utf8                                                    |
| character_set_filesystem | binary                                                  |
| character_set_results    | euckr                                                  |
| character_set_server    | utf8                                                    |
| character_set_system    | utf8                                                    |
| character_sets_dir      | C:\Program Files\MySQL\MySQL Server 5.5\share\charsets\ |
| collation_connection    | utf8_general_ci                                        |
| collation_database      | utf8_general_ci                                        |
| collation_server        | utf8_general_ci                                        |
| completion_type          | NO_CHAIN                                                |
| concurrent_insert        | AUTO                                                    |
| connect_timeout          | 10                                                      |
+--------------------------+---------------------------------------------------------+


my.ini¿¡¼­

[mysql]
default-character-set=utf8

¼³Á¤ÇØÁ༭ ÀÌ·¸°Ô ³ª¿À´Â°Í °°Àºµ¥

ÄܼÖâ¿¡¼­ 
SET character_set_results=euckr
¸í·É¾î¸¦ ³¯·ÁÁÖ¸é ÇѱÛÀÌ Á¦´ë·Î Àß ³ª¿À±ä ÇÕ´Ï´Ù¸¸..

mysqlÀ» ³ª°¬´Ù°¡ ´Ù½Ã µé¾î°¡¸é ¿ø·¡´ë·Î ±úÁ®¼­ ³ª¿À´õ¶ó±¸¿ä.

Á¦ »ý°¢¿£ my.ini¿¡¼­ ¼³Á¤ÇØÁà¾ß ÇÒ°Í°°Àºµ¥

init_connect="SET character_set_results=euckr"
character_set_results=euckr
¶ó°í ³Ö¾îµµ ¾ÈµÇ°í...

ã´Ù°¡ ¸øã¾Æ¼­ ¿©Â޾´Ï´Ù.
´ñ±Û ±â´Ù¸®°Ú½À´Ï´Ù.]]> À̵¿½Äµð½ºÅ© Tue, 18 Jun 2013 14:13:31 +0900 http://www.phpschool.com/gnuboard4/bbs/board.php?bo_table=qna_db&wr_id=198022 ±×·±µ¥ ÀÌÀüµÈ ¼­¹ö¿¡¼­ 'Ç¥½Ã¸¦ ÀÔ·ÂÇؼ­ ±ÛÀ» ¾²¸é..
\' ÀÌ·±½ÄÀ¸·Î ÀÚµ¿ ÀÔ·ÂÀÌ µÇ°í(ÀÌÀü ¼­¹ö¿¡¼­´Â ±×³É 'Ç¥½Ã·Î ÀúÀåµÇ¾ú´Âµ¥¿ä.)
±Û ³»¿ëÀ» DB¿¡¼­ °¡Á®¿Í¼­ º¸¿©Áö¸é ´ç¿¬È÷ \'ÀÌ·¸°Ô ³ª¿É´Ï´Ù.

¼­¹ö ¼³Á¤À» ¼öÁ¤ÇØ¾ß Çϳª¿ä? ±×·¯¸é ¾î´À ºÎºÐÀ» ¼öÁ¤ÇØ¾ß Çϳª¿ä??
¾Æ´Ï¸é, DB ¹öÀüÀ» ´Ù¸£°Ô ÇØ¾ß Çϳª¿ä?
(DB ¹öÀüÀº Á¦°¡ ¹Ì¸® ¾Ë·Áµå·Á¼­ °°Àº ¹öÀüÀä.)

´äº¯ Á» ºÎŹ µå¸³´Ï´Ù.]]> ¼­ÅÂÁö¾ä Tue, 18 Jun 2013 14:10:54 +0900