dBforums
Show all 2 posts from this thread on one page

dBforums (http://www.dbforums.com/index.php)
- mailing.database.mysql-win32 (http://www.dbforums.com/forumdisplay.php?forumid=156)
-- ib_logfile when InnoDB NOT enabled (http://www.dbforums.com/showthread.php?threadid=945940)


Posted by Jim Ekleberry on 10-14-03 15:03:

ib_logfile when InnoDB NOT enabled

I just upgraded from MySQL v3.23.56 to v4.0.12 and noticed that I now have
ib_logfile* files appearing in my data directory. The files do have size,
are growing, but mostly contain spaces. :s

According to the manual these files are only supposed to appear when InnoDB
table support has been enabled which I have not done.

Anyone have an idea on how to prevent these files from being created?

Any help will be greatly appreciated.

Jim


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=...sie.nctu.edu.tw


Posted by Paul Dubois on 10-14-03 21:01:

Re: ib_logfile when InnoDB NOT enabled

At 9:52 -0500 10/14/03, Jim Ekleberry wrote:
  >I just upgraded from MySQL v3.23.56 to v4.0.12 and noticed that I now have
  >ib_logfile* files appearing in my data directory. The files do have size,
  >are growing, but mostly contain spaces. :s
  >According to the manual these files are only supposed to appear when InnoDB
  >table support has been enabled which I have not done.

Ah, but you *have*. :-)

You upgraded to 4.x. InnoDB support is included by default in MySQL 4.x.

  >Anyone have an idea on how to prevent these files from being created?

Start the server with the --skip-innodb option. For example, you can put
the option in the [mysqld] group of an option file like C:\my.cnf:

[mysqld]
skip-innodb

Once you restart the server with InnoDB disabled, you can delete
the ib* files.

  >Any help will be greatly appreciated.
  >Jim


--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com

Are you MySQL certified? http://www.mysql.com/certification/


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=...sie.nctu.edu.tw


All times are GMT. The time now is 13:49.
Show all 2 posts from this thread on one page

Powered by: vBulletin Version 2.2.9
Copyright © Jelsoft Enterprises Limited 2000 - 2002.
Copyright ©2001-2003 dBforums.com
a division of iNET Interactive
Visit HotScripts.com for all your script needs.
Visit WebHostingTalk.com for Web Hosting Discussions.