RE: [PHP-DB] Re: Get MySQL table schema for a dump
| From: | Jonathan Villa | Date: | Wed, 26 Feb 2003 23:35:55 +0000 |
| Subject: | RE: [PHP-DB] Re: Get MySQL table schema for a dump | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-25936@lists.php.net to get a copy of this message | ||
Sorry, I should have explained that I want to do this via PHP.
---> Jonathan
-----Original Message-----
From: fredridv@tva.ifi.uio.no [mailto:fredridv@tva.ifi.uio.no] On Behalf
Of Fredrik de Vibe
Sent: Wednesday, February 26, 2003 5:31 PM
To: php-db@lists.php.net
Subject: [PHP-DB] Re: Get MySQL table schema for a dump
jvilla@isdesigndev.com (Jonathan Villa) writes:
> Is there was to get a database's table schema?
I don't think it's called schemas in mysql, but I'm not sure :-)
> So far, I have a simple function which will output
> INSERT INTO table (x,x,x,) VALUES(x,x,x);
> [ ... ]
> but what I'm missing is
> CREATE table blah, blah, blah
mysqldump is the tool you need.
e.g.
$ mysqldump -u user [-p] Database > db_dump_file.sql
man mysqldump for more info.
--
--Fredrik
If God is dead, who will save the Queen?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php