tony yau wrote:
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"))
Either do it with a query....
mysql_query ( "LOAD DATA INFILE 'file.sql'" );
Or use a system command in php...
$command = "mysql db_name < file.sql";
exec ( $command );
--
John C. Nichel
ÜberGeek
KegWorks.com
716.856.9675
john@xxxxxxxxxxxx
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
