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?)
It's not a security risk, but by starting the server with --skip-innodb, you disable the InnoDB storage engine. As a result, the server won't allocate any InnoDB-related buffers and will use less memory while it runs.
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:[EMAIL PROTECTED] Sent: Saturday, July 05, 2003 9:03 AM To: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]