RE: [PHP-DB] calling sql script
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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] > 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 > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] calling sql script
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: [EMAIL PROTECTED] 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
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! --- Begin Message --- I need to use a php page to run an .sql script against a mysql db. How do I simply call the script from php? I can take parts of it and execute the statements but I would like to just call the entire script. Thanks, Eddie -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php --- End Message --- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] calling sql script
http://www.phpbuilder.com/manual/function.exec.php -Original Message- From: Edward Peloke [mailto:epeloke@;echoman.com] Sent: Thursday, November 07, 2002 12:02 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] calling sql script I need to use a php page to run an .sql script against a mysql db. How do I simply call the script from php? I can take parts of it and execute the statements but I would like to just call the entire script. Thanks, Eddie -- 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
RE: [PHP-DB] calling sql script
There is a shell command I remember reading on phpbuilder.com. do a quick search. .. I believe it is exec -Original Message- From: Edward Peloke [mailto:epeloke@;echoman.com] Sent: Thursday, November 07, 2002 12:02 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] calling sql script I need to use a php page to run an .sql script against a mysql db. How do I simply call the script from php? I can take parts of it and execute the statements but I would like to just call the entire script. Thanks, Eddie -- 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