<div>
SELECT * FROM information_schema.`TABLES<wbr />` where enging = 'InnoDB'
</div>


SELECT * FROM information_schema.`TABLES` where enging = 'InnoDB'

<div>
I would use something like the attached code. Assumes you are already connected to the DB<br />

<pre><code id="code-315085">&lt;?php  
  
  $query = 'SHOW TABLES';
  if ($results = mysql_query($query)) {
    $success = true;
    $tables = array();
    if (mysql_num_rows($results) &gt; 0) {
      while ($row = mysql_fetch_row($results)) {
        $tables[] = $row[0];
      }
    }
  }
  
  // the array $tables now holds a list of tables in the database
    
  
?&gt;
</code></pre>
</div>


I would use something like the attached code. Assumes you are already connected to the DB


<?php  
  
  $query = 'SHOW TABLES';
  if ($results = mysql_query($query)) {
    $success = true;
    $tables = array();
    if (mysql_num_rows($results) > 0) {
      while ($row = mysql_fetch_row($results)) {
        $tables[] = $row[0];
      }
    }
  }
  
  // the array $tables now holds a list of tables in the database
    
  
?>


<div>
Sorry, missed the InnoDB protion of the question. Better to go with racek.
</div>


Sorry, missed the InnoDB protion of the question. Better to go with racek.

<div>
<div class="content wysiwyg-content">
Anyone know a quick way to generate a list of Innodb tables in a database?<br />
I hosed my ibdata files and need to figure out which tables are Innodb so I can restore them from a backup file.<br />
<br />
-G
</div>
</div>


Anyone know a quick way to generate a list of Innodb tables in a database?
I hosed my ibdata files and need to figure out which tables are Innodb so I can restore them from a backup file.

-G

How to get list of Innodb tables in a MySQL database

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.