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 [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
