tips-programming max_allowed_packet mysql

MySQL Migration Toolkit을 이용하여 MS Access에 있는 데이터를 옮기던 중에 다음과 같은 오류가 발생하였습니다. 

<p>
</p>

<p>
  2. Data Bulk Transfer<br />&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;
</p>

<p>
  &nbsp; &nbsp; &nbsp; `test`.`TEST_CONTENTS`<br />&nbsp; &nbsp; &nbsp; &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br /> Packet for query is too large (1720261 > 1048576). <span style="font-weight: bold;">You can change<br /> this value on the server by setting the max_allowed_packet&#8217; variable.</span><br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br /> Packet for query is too large (1296932 > 1048576). You can change<br /> this value on the server by setting the max_allowed_packet&#8217; variable.<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0 row(s) transfered.
</p>

<p>
  이 문제를 해결하기 위해서는 해당 설정 값을 더 크게 변경해 주어야 합니다.
</p>

<p>
  변경 방법은 아래와 같습니다.
</p>

<p>
</p>

<div>
  <font color="#ff0000" size="2"><strong>show variables;</strong></font>
</div>

<div>
  <font color="#ff0000" size="2"><strong>SET GLOBAL max_allowed_packet = 1024 * 1024 * 32;</strong></font>
</div>

<div>
  <font color="#ff0000" size="2"><strong>SET SESSION max_allowed_packet = 1024 * 1024 * 32;</strong></font>
</div></p>


<p>
  </span>
</p>

<div class="autosourcing-stub">
  <p style="margin: 11px 0pt 7px; padding: 0pt; font-size: 12px; font-family: Dotum; font-style: normal; font-weight: normal;">
    <font><strong><strong style="padding: 0pt 7px 0pt 0pt;">[출처]</strong> <a href="http://blog.naver.com/hbesthee/20035879450" target="_blank">max_allowed_packet 발생시 대처법</a><span style="padding: 0pt 7px 0pt 5px;">|</span><strong style="padding: 0pt 7px 0pt 0pt;">작성자</strong> <a href="http://blog.naver.com/hbesthee" target="_blank">hbesthee</a></strong></font>
  </p>
</div></div>
,

관련 게시글