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
You mean show databases, show tables and describe $table_name for
every table in the database ?
Balazs
On Wed, Feb 02, 2005 at 10:31:17AM -0800, Dan Stromberg wrote:
I have a system with set of web pages that use PHP and a MySQL database.
Apparently the old webmaster has disappeared, and
Dan Stromberg [EMAIL PROTECTED] wrote on 02/02/2005 01:31:17 PM:
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:
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
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
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
The easiest route is to use mysqldump with the --no-data option. it
will dump the full schema info including feign keys, etc.
-- michael dykman
On Wed, 2005-02-02 at 13:31, Dan Stromberg wrote:
I have a system with set of web pages that use PHP and a MySQL database.
Apparently the old