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]