Re: novice: how to run .sql script from php?

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@kegworks.com