InnoDB creation problems 5.0.18

Gee Bee · #1 (**permalink**) Jun 8th, 2006, 18:22

Hi guys,

Im running mysql version 5.0.18 on my local server and everytime i try to create a table with the InnoDB storage engine the server seems to change it automatically to MyISAM instead!

Does anyone know why it would be doing this and how to stop it from doing it!

Thanks

flann · #2 (**permalink**) Jun 18th, 2006, 22:52

what is the create table query that you are running? It should look like.

PHP: Select all


create table table_name (tableID int not null auto_increment,
field varchar(50),
PRIMARY KEY(tableID)
) TYPE = INNODB;

masonbarge · #3 (**permalink**) Jun 20th, 2006, 12:33

No, but I know how to fix it.

ALTER TABLE (name of your table) ENGINE = InnoDB

masonbarge · #4 (**permalink**) Jun 20th, 2006, 12:35

BTW I think you need to use ENGINE instead of TYPE for mysql 5

Gee Bee · #5 (**permalink**) Jun 21st, 2006, 09:01

The problem wasnt with the sql, but the server itself. I had the binary installed that lacks the InnoDB code. Thanks for input anyway.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Web Page Creation and Design	TerenceLloyd	Job Opportunities	15	Aug 26th, 2007 23:09
My new creation	Dual Earth	Webforumz Cafe	1	Jul 15th, 2007 17:33
forum creation	collinsc	Website Planning	10	Apr 1st, 2007 22:18
Sub-domain creation	Zumico	PHP Forum	3	Dec 23rd, 2006 13:39
need help with on a form creation	skyfire400	Web Page Design	2	Oct 14th, 2006 06:46

		Webforumz.com > Main Forums > Program Your Website > Databases
InnoDB creation problems 5.0.18