The wrap it in an exec() or one of the other exec type functions  ;)

$result = exec("mysqldump -uMyUser -pMyPass MyDB > db_dump_file.sql");

> -----Original Message-----
> From: Jonathan Villa [mailto:[EMAIL PROTECTED] 
> Sent: Wednesday, February 26, 2003 3:36 PM
> To: [EMAIL PROTECTED]
> Subject: RE: [PHP-DB] Re: Get MySQL table schema for a dump
> 
> 
> 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
> 


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

Reply via email to