title: max number of columns in a mysql table error
body: <p>I have reached the limit set on the row size of a table, so I'm not able to add any more columns to the table.</p>
  
  <p>I'm getting the following error:</p>
  
  <blockquote>
    <p>.#1118 - Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to
    TEXT or BLOBs</p>
  </blockquote>
  
  <p>I have researched this issue on the <a href="http://dev.mysql.com/doc/refman/5.0/en/column-count-limit.html" rel="nofollow">MySQL website</a>, but am still unsure about how to fix this problem.</p>
  
  <p>Does anyone know how I can fix this issue, and what setting or script that I would need to run to modify the setting so it allows me to add more columns to the table?</p>