I'd do something like 'mysqldump -d foo'; the -d option only dumps the
table defs.

> -----Original Message-----
> From: Dan Stromberg [mailto:[EMAIL PROTECTED] 
> Sent: Wednesday, February 02, 2005 12:31 PM
> To: mysql@lists.mysql.com
> Cc: [EMAIL PROTECTED]
> Subject: Pulling a database schema out of a unknown MySQL database?
> 
> 
> I have a system with set of web pages that use PHP and a 
> MySQL database.
> 
> Apparently the old webmaster has disappeared, and a new webmaster has
> been hired.  She needs to know the schema of the database.
> 
> So my question is: Is there a way of querying MySQL not for values of
> fields, but rather for the schema of the database?
> 
> Thanks!
> 
> 
> 
> -- 
> 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]

Reply via email to