title: Handling of huge Blobs in MySQL?
body: <p>How can I insert huge BLOBs into a MySQL database (InnoDB)?</p>
  
  <p>Fields of type LONGBLOB support data sizes of up to 4 GB according to the MySQL manual. But how does data of such a huge size get into the database?</p>
  
  <p>I tried to use</p>
  
  <pre><code>INSERT INTO table (bindata) VALUES ( LOAD_FILE('c:/tmp/hugefile') );
  </code></pre>
  
  <p>which fails if the size of hugefile is bigger than about 500 MB. I have set <code>max_allowed_packet</code> to an appropriate size; the value of <code>innodb_buffer_pool_size</code> doesn't seem to have an influence.</p>
  
  <p><em>My server machine runs Windows Server 2003 and has 2 GB RAM. I'm using MySQL 5.0.74-enterprise-nt.</em></p>