title: Where to add innodb_large_prefix
body: <p>I am running into a bit of an issue.</p>
  
  <p>You see I have made a WordPress website locally using WAMP and everything seemed to be working fine, until I tried to get the MySQL database imported onto the new live site where it gave an error:</p>
  
  <p><strong>"#1709 - Index column size is to large, The maximum column size is 767 bytes"</strong></p>
  
  <p>See image of the complete error here:<br>
  <a href="https://i.stack.imgur.com/bPgCp.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/bPgCp.jpg" alt="See image of the complete error here"></a></p>
  
  <p>Now I have found some answers to what may be causing this here:</p>
  
  <p><a href="https://stackoverflow.com/questions/30761867/mysql-error-the-maximum-column-size-is-767-bytes/50945855#50945855">MySQL error: The maximum column size is 767 bytes</a></p>
  
  <p>And here:</p>
  
  <p><a href="https://stackoverflow.com/questions/35847015/mysql-change-innodb-large-prefix">mysql change innodb_large_prefix</a></p>
  
  <p>And although I understand what needs to be imlemented code wise, I am none the wiser as to where the code actually needs to be placed.</p>
  
  <p>As aside from importing and exporting and editing the database credentials I never had to do anything else with MySQL, it is all a bit foreign to me.
  And though I am more than happy to look more deeply into it at a later point in time, at this point I rather just want my live site to be working.</p>