--- Egor Egorov <[EMAIL PROTECTED]> wrote: > Sagara Wijetunga <[EMAIL PROTECTED]> wrote: > > > I can see his MyISAM *.frm, *.MYD and *.MYI are > kept > > under his database directory. > > > > But I can see only table.frm are in his database > > directory for InnoDB tables. It looks like InnoDB > > table data belongs to his database are not kept > under > > his database directory. Am I right? > > Right. InnoDB uses big single (or multiple) > tablespace for all data. > But you can also use different tablespaces for > different tables. > See > http://dev.mysql.com/doc/mysql/en/Multiple_tablespaces.html > Yep, this is the feature I was looking for. Thank you very much.
Sagara __________________________________ Do you Yahoo!? Yahoo! Mail - 50x more storage than other providers! http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]