RE: [PHP-DB] calling sql script
| From: | Adam Voigt | Date: | Thu, 07 Nov 2002 16:53:05 +0000 |
| Subject: | RE: [PHP-DB] calling sql script | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-23098@lists.php.net to get a copy of this message | ||
Well, either use PHPMyAdmin, or if this is a recursive
thing like, you need to have this done one the fly, and you
have shell (SSH) access to your host, connect your host and
do "which mysql" in the console and this will probably give
you the path.
Adam Voigt
adam.voigt@cryptocomm.com
On Thu, 2002-11-07 at 12:13, Edward Peloke wrote:
> But I am not sure where my hosting companies mysql is so I do not know the
> path....
>
> -----Original Message-----
> From: Marco Tabini [mailto:marcot@inicode.com]
> Sent: Thursday, November 07, 2002 11:31 AM
> To: Edward Peloke
> Cc: php-db@lists.php.net
> Subject: Re: [PHP-DB] calling sql script
>
>
> You can use exec
>
> http://ca.php.net/manual/en/ref.exec.php
>
> You will probably need to call the mysql shell like so:
>
> /path_to_mysql/mysql -u user -p password [-h host] -D database -e \\.
> filename
>
>
> Marco
> --
> ------------
> php|architect - The magazine for PHP Professionals
> The first monthly worldwide magazine dedicated to PHP programmer
>
> Come visit us at http://www.phparch.com!
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>