title: How to pull out schema of db from MySQL/phpMyAdmin?
body: <p>is there some way of pulling out the schema of your mysql databases? </p>
  
  <p>I have lots of db and tables inside these databases, and I use phpmyadmin with WAMP in my local machine. </p>
  
  <p>I need to pull out the schema, or atleast the database name, table name, columns and their attributes (e.g. <code>INT(2)</code>) and export it as csv/ excel/ whatever format which finally can be edited in excel.</p>
  
  <p>i use:</p>
  
  <p><strong>server:</strong></p>
  
  <pre>
      Apache/2.2.21 (Win64) PHP/5.3.8
      MySQL client version: mysqlnd 5.0.8-dev - 20102224 - $Revision: 310735 $
      PHP extension: mysqli Documentation
  </pre>
  
  <p><strong>mysql:</strong></p>
  
  <pre>
      Server: localhost (localhost via TCP/IP)
      Server version: 5.5.16-log
      Protocol version: 10
      User: root@localhost
      MySQL charset: UTF-8 Unicode (utf8)
  </pre>
  
  <p>thanks!</p>