Re: InnoDB table data
--- 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]
Re: InnoDB table data
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 -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: InnoDB table data
InnoDB data is kept in the ib* files. Did you explicitly create a directory for your innoDB files? -Original Message- From: Sagara Wijetunga To: [EMAIL PROTECTED] Sent: 7/6/04 8:16 AM Subject: InnoDB table data Hi all We allocate a limited amount of disk space for user's home directory and the user is required to keep everything under his home directory including his databases. I moved the database created for the user under his home directory and made a link to it from /var/lib/mysql. We use InnoDB as well as MyISAM tables. 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? If I'm wrong, how do I keep InnoDB table data also under his database directory? Many thanks in advance. Kind regards Sagara __ Do you Yahoo!? Yahoo! Mail is new and improved - Check it out! 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]