LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Server (https://www.linuxquestions.org/questions/linux-server-73/)
-   -   mysql doubt (https://www.linuxquestions.org/questions/linux-server-73/mysql-doubt-832045/)

maheshp86 09-14-2010 04:21 AM

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.

tronayne 09-14-2010 07:29 AM

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.


All times are GMT -5. The time now is 09:31 PM.