Visit Jeremy's Blog.
Go Back > Forums > Linux Forums > Linux - Server
User Name
Linux - Server This forum is for the discussion of Linux Software used in a server related context.


  Search this Thread
Old 09-14-2010, 05:21 AM   #1
LQ Newbie
Registered: Jun 2010
Location: mumbai
Posts: 22

Rep: Reputation: 0
mysql doubt


I'm new to mysql. In datadir=/data/mydb directory I'm creating databases. I'm using InnoDB storage engine. In this directory three files namely ibdata1,ib_logfile0,ib_logfile1 created automatically. What is the use of these files and it contains any information? If I deleted these files what happens?

Any one answer for this doubt.
Old 09-14-2010, 08:29 AM   #2
Senior Member
Registered: Oct 2003
Location: Northeastern Michigan, where Carhartt is a Designer Label
Distribution: Slackware 32- & 64-bit Stable
Posts: 3,541

Rep: Reputation: 1060Reputation: 1060Reputation: 1060Reputation: 1060Reputation: 1060Reputation: 1060Reputation: 1060Reputation: 1060
ibdata1 is the data file for tables stored that MySQL uses (with the InnoDB engine); the ib_log.... files are..., well, logs of activity. So, yes, if you're using the InnoDB engine, the do contain (vital) information -- and, if you delete them, well, things won't be good (leave 'em alone).

If you're curious, you can go to and search (in the upper right corner of the web page) for "ibdata1" to get a group of MySQL Reference Manual links about ibdata1.

Hope this helps some.



Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Doubt in MySql vibinlakshman Programming 2 02-17-2009 01:08 PM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. SpellChainz Linux - Newbie 1 06-23-2007 04:35 PM
doubt about making a mysql server lonrot_m Linux - Networking 3 05-08-2006 04:43 PM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. Dannux Linux - Software 3 03-24-2006 09:44 AM > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 11:24 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration