Jonathan Villa wrote: > >in /usr/local/mysql/data there is one dir named the same as the db >they are working on, then there is this other file called ibdata1 >which is 2.1G in size. I take a look at the first few lines and all >I get is garbled data, as if it were a binary file or something.
That's an innodb data file, and given that it is 2.1G it sounds like someone is using it to create InnoDB tables. As you create new tables this file can grow if it is set to autoextend. Even when using InnoDB exclusively you will see a directory corresponding to each database which holds the table definition. The data and indices are contained in the ibdata files. There's a lot of info on this in the InnoDB section of the MySQL manual: <http://dev.mysql.com/doc/mysql/en/InnoDB_overview.html> and at the InnoDB web site: <http://www.innodb.com/ibman.php> Good luck, Ware -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
