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

Notices

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

Rep: Reputation: 0
mysql doubt


Hi


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
tronayne
Senior Member
 
Registered: Oct 2003
Location: Northeastern Michigan, where Carhartt is a Designer Label
Distribution: Slackware 32- & 64-bit Stable
Posts: 3,118

Rep: Reputation: 818Reputation: 818Reputation: 818Reputation: 818Reputation: 818Reputation: 818Reputation: 818
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 http://dev.mysql.com/doc/refman/5.0/en 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.
 
  


Reply

Tags
mysql


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


All times are GMT -5. The time now is 01:39 PM.

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