Subhakar, Nils already answered the first question.
About the second question, there unfortunately is no way to extract only the table name and the type from SHOW TABLE STATUS. MySQL does not store table information into any table, but in .frm files in the database directories under the datadir. This is a known weakness, and should be fixed some time in the future. 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/ ----- Original Message ----- From: "Subhakar Burri" <[EMAIL PROTECTED]> To: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, July 08, 2003 1:22 AM Subject: RE: AUTOEXTEND Hi, I tried SHOW VARIABLES LIKE '%innodb%'; but I couldn't find any variables that show information about auto extend property. Please clarify... For my second question, I need only the table_name and table_type information, and avoid the rest, for an instance. I tried the tables_priv table in mysql database, but of no use. Any idea where MYSQL stores the status information inside the database? Thankx in advance, SB -----Original Message----- From: Heikki Tuuri [mailto:[EMAIL PROTECTED] Sent: Monday, July 07, 2003 2:24 PM To: [EMAIL PROTECTED] Subject: Re: AUTOEXTEND 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
