2006/6/23, Mertens Bram <[EMAIL PROTECTED]>:
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/


--
To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]

Reply via email to