Posted by John Nichel on 05/27/05 16:48

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

• Next in forum: Re: [PHP] include file and problems with headers
• Prev in forum: Re: Stopping users to see uploaded files
• Thread view: Re: [PHP] novice: how to run .sql script from php?

[Reply to this message]