Re: Setting up InnoDB on MySQL on testing

[Pooly <pooly7@gmail.com>]

2006/6/23, Mertens Bram <bram-mertens@linux.be>:
> I would like to use the InnoDB engine for a new database in MySQL.
>
> >From what I've found so far InnoDB support should be available in the
> debian packages and all I need to configure it.
>
> Unfortunately I haven't found instructions on how to do so yet.  The
> Mysql 5.0 documentation describes some parameters to set up in
> /etc/mysql/my.cnf.  But even after adding these tables I create with
> the InnoDB engine specified are still created as MyISAM.
>
> I'v found old messages saying you should uncomment some parameters in
> my.cnf (like skip-innodb) but none of these appear in the my.cnf file.
>
> What do I need to be able to create InnoDB tables?

The only option I have in my.cnf are :
innodb_data_file_path=ibdata/ibdata1:50M:autoextend
innodb_file_per_table

and then, you need to restart MySQL.

--
http://www.w-fenec.org/