How to configure inno db in mysql 5.5.8

Question

I am trying to restore a database from sql file through phpmyadmin import function. I got this error while trying to import a database:

#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 

I tried going to my.ini and did some editing:

# 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

But I got this error:

#2002 - The server is not responding (or the local MySQL server socket is not correctly configured) 

I tried running show engines in the mysql console and found that innodb support was set to the default value. I did not install mysql separately, installed it through wampserver. The default for dir and group dir is c: \ mysql \ data, but this directory does not exist. So what I did to put:

C:\wamp\bin\mysql\mysql5.5.8\data

I'm not quite sure that I am doing the right thing. How to do it right? Please help. Thank!

Answer 1

. , MySQL.

5.5, MySQL TYPE=INNODB ENGINE=INNODB DDL. , SQL-, -, .

, PHPMyAdmin. , . PHPMyAdmin , , .

, , my.cnf, :

skip-innodb

Innodb , .

, , InnoDB , MySQL, , InnoDB:

SHOW VARIABLES LIKE 'have_innodb';

NO, mysqld, InnoDB, .

, MySQL, , , MySQL. , MySQL, MySQL, , MySQL. , MySQL .

, !