How to setup inno db in mysql 5.5.8

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:

#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 

Tried going around in my.ini, and done 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's socket is not correctly configured) 

Tried running the show engines in mysql console, and found out that support for innodb is set to default. Отдельно mysql не устанавливал, устанавливал через wampserver. По умолчанию для домашнего каталога и каталога группы используется c: \ mysql \ data, но этот каталог не существует. Я поставил:

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

Я не совсем уверен, правильно ли я поступаю. Как мне это сделать правильно? Пожалуйста помоги. Спасибо!

5
задан Wern Ancheta 2 May 2011 в 11:21
поделиться