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]