Subhakar, ----- Original Message ----- From: ""Subhakar Burri"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Monday, July 07, 2003 11:52 PM Subject: AUTOEXTEND
> Sorry to post the same question again .. last time when I sent I = > received a couple of mails with some error messages .. so, not sure if = > my question was posted ... > Here we go again .. > > Hi,=20 > > I have a couple of questions, and really appreciate your help ... > > How can I find out if a data file is set to auto-extend without looking = > in my.cnf file? i.e... is there any variable that stores this = > information inside a database that I can query? please try SHOW VARIABLES LIKE '%innodb%'; > I need the table_name & table_type of all the tables in a instance (to = > run check table). Is there a way I can get that info from a single = > query? If not, what's the best way to get that info? Try SHOW TABLE STATUS FROM yourdatabasename; > Thankx in advance, > SB Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Transactions, foreign keys, and a hot backup tool for MySQL Order MySQL technical support from https://order.mysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
