Sorry, I should have explained that I want to do this via PHP.

 
---> Jonathan
 
 
 

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Fredrik de Vibe
Sent: Wednesday, February 26, 2003 5:31 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Re: Get MySQL table schema for a dump

[EMAIL PROTECTED] (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



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to