novice: how to run .sql script from php?
| From: | tony yau | Date: | Fri, 27 May 2005 09:20:42 +0000 |
| Subject: | novice: how to run .sql script from php? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-215849@lists.php.net to get a copy of this message | ||
Hi All,
I got this .sql script that setup the whole db schema, I can run
mysql.exe to run on my pc but when it goes to a hosting company's server I
don't have that command!
So I tried to include("setup.sql") into a string and send that as one
long sql query. BUT I need to get rid of all the comment lines first in the
script!!
can someone give me a better idea of doing this.
(there must be an equivalent php function like
mysql_run_script("setup.sql"))
thanks
--
Tony Yau