title: How to setup inno db in mysql 5.5.8
body: <p>I'm trying to restore a database from an sql file through phpmyadmin import function. I got this error while trying to import the database:   </p>
  
  <pre><code>#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=InnoDB' at line 15 
  </code></pre>
  
  <p>Tried going around in my.ini, and done some editing:</p>
  
  <pre><code># Uncomment the following if you are using InnoDB tables
  innodb_data_home_dir = C:\wamp\bin\mysql\mysql5.5.8\data/
  innodb_data_file_path = ibdata1:10M:autoextend
  innodb_log_group_home_dir = C:\wamp\bin\mysql\mysql5.5.8\data/
  innodb_log_arch_dir = C:\wamp\bin\mysql\mysql5.5.8\data/
  # You can set .._buffer_pool_size up to 50 - 80 %
  # of RAM but beware of setting memory usage too high
  #innodb_buffer_pool_size = 16M
  #innodb_additional_mem_pool_size = 2M
  # Set .._log_file_size to 25 % of buffer pool size
  #innodb_log_file_size = 5M
  #innodb_log_buffer_size = 8M
  #innodb_flush_log_at_trx_commit = 1
  #innodb_lock_wait_timeout = 50
  </code></pre>
  
  <p>But I got this error:</p>
  
  <pre><code>#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) 
  </code></pre>
  
  <p>Tried running the show engines in mysql console, and found out that support for innodb is set to default. 
  I didn't install mysql separately, installed it via wampserver. The default for the home dir and group dir is c:\mysql\data, but that directory doesn't exist. So what I did was to put: </p>
  
  <pre><code>C:\wamp\bin\mysql\mysql5.5.8\data
  </code></pre>
  
  <p>I'm not exactly sure if I'm doing the right thing. How do I do this properly? Please help. Thanks!</p>