Hi,
This may be a stupid question but can I still just ask it?
Why do you want to disable the use of InnoDB tables? If you don't
use it, couldn't the files still be there? It's not like it's a security
risk (or is it?) or that it takes up lots of space? (maybe this is true as
well?)
I'm just starting out and my innoDB files are small.
Cheers,
Mun Heng, Ow
H/M Engineering
Western Digital M'sia
DID : 03-7870 5168
-----Original Message-----
From: Mike Blezien [mailto:mickalo@stripped]
Sent: Saturday, July 05, 2003 9:03 AM
To: mysql@stripped
Subject: Re: Disable InnoDB
Thanks, that did the trick :)
>> Jeremy Zawodny wrote:
> On Fri, Jul 04, 2003 at 07:26:54PM -0500, Mike Blezien wrote:
>
>>Hello,
>>
>>Happy 4th to all :)
>>
>>Anyway, I am attempt to temporarily disable InnoDB tables. We just
>>setup on a new RH/Linux 7.3 server that had the MySQL version 4.0.13
>>from RPM's, pre-installed... but we currently don't need the InnoDB
>>tables but may in the near future... I've commented out all the
>>relavent setting in the my.cnf file in the data
>>dir(/var/lib/mysql/my.cnf).. then restarted the MySQL server, but
>>it's still creates all the data file related to the InnoDB tables.
>>
>>is it not possible to disable the use of InnoDB tables using the
>>my.cnf file or not with RPM's ??
>
>
> Put "skip-innodb" in your my.cnf file.
--
Mike<mickalo>Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Web Hosting
http://www.justlightening.net
Tel: 1(985)902-8484
MSN: mickalo@stripped
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
