I don't know if it will work - but have you tried using SOURCE in the mysql query?

-----Original Message-----
From: Daevid Vincent [mailto:daevid@daevid.com]
Sent: Tuesday, October 10, 2006 11:01 AM
To: mysql@lists.mysql.com
Subject: What's the PHP equivallent of "mysql mydb < somefile.sql"

Currently I run an 'updater' script to run through a directory of .sql files using something like this in PHP:

$COMMAND = "mysql ".$OPTION['db_prefix'].$db." < ".$mydir.$filename;
system($COMMAND, $ret);

What would be the equivallent way to to this in a PHP mysql_query(""); way?

I see "LOAD", but that only works for data it seems.
http://dev.mysql.com/doc/refman/5.0/en/load-data.html

These scripts I use have ALTER statements and CREATE and all other types of SQL in them and almost no data actually.

mySQL 5.0.15


ÐÆ5ÏÐ


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=lig@maolek.com

Could you be more specific? What is "SOURCE"? Where do I use that? I tried
to search, but I find a lot of hits related to source code.

> -----Original Message-----
> From: Ligaya A. Turmelle [mailto:lturmelle@guamcell.com]
> Sent: Monday, October 09, 2006 6:57 PM
> To: Daevid Vincent; mysql@lists.mysql.com
> Subject: RE: What's the PHP equivallent of "mysql mydb < somefile.sql"
>
> I don't know if it will work - but have you tried using
> SOURCE in the mysql query?
>
> -----Original Message-----
> From: Daevid Vincent [mailto:daevid@daevid.com]
> Sent: Tuesday, October 10, 2006 11:01 AM
> To: mysql@lists.mysql.com
> Subject: What's the PHP equivallent of "mysql mydb < somefile.sql"
>
> Currently I run an 'updater' script to run through a
> directory of .sql files using something like this in PHP:
>
> $COMMAND = "mysql ".$OPTION['db_prefix'].$db." <
> ".$mydir.$filename;
> system($COMMAND, $ret);
>
> What would be the equivallent way to to this in a PHP
> mysql_query(""); way?
>
> I see "LOAD", but that only works for data it seems.
> http://dev.mysql.com/doc/refman/5.0/en/load-data.html
>
> These scripts I use have ALTER statements and CREATE and all
> other types of SQL in them and almost no data actually.
>
> mySQL 5.0.15
>
>
> ÐÆ5ÏÐ
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=lig@maolek.com
>
>
>

Read the section on the manual on the Client and Utility programs,
specifically mysql. The syntax is essentially the same as you have in
your code .... something like this from the command line....

mysql -u dbUser -pMyPassword dbName <SomeFileWithLotsOfSQLCommands.sql

Note there is no space between the '-p' and the password.

Daevid Vincent wrote:
> Could you be more specific? What is "SOURCE"? Where do I use that? I tried
> to search, but I find a lot of hits related to source code.
>
>
>> -----Original Message-----
>> From: Ligaya A. Turmelle [mailto:lturmelle@guamcell.com]
>> Sent: Monday, October 09, 2006 6:57 PM
>> To: Daevid Vincent; mysql@lists.mysql.com
>> Subject: RE: What's the PHP equivallent of "mysql mydb < somefile.sql"
>>
>> I don't know if it will work - but have you tried using
>> SOURCE in the mysql query?
>>
>> -----Original Message-----
>> From: Daevid Vincent [mailto:daevid@daevid.com]
>> Sent: Tuesday, October 10, 2006 11:01 AM
>> To: mysql@lists.mysql.com
>> Subject: What's the PHP equivallent of "mysql mydb < somefile.sql"
>>
>> Currently I run an 'updater' script to run through a
>> directory of .sql files using something like this in PHP:
>>
>> $COMMAND = "mysql ".$OPTION['db_prefix'].$db." <
>> ".$mydir.$filename;
>> system($COMMAND, $ret);
>>
>> What would be the equivallent way to to this in a PHP
>> mysql_query(""); way?
>>
>> I see "LOAD", but that only works for data it seems.
>> http://dev.mysql.com/doc/refman/5.0/en/load-data.html
>>
>> These scripts I use have ALTER statements and CREATE and all
>> other types of SQL in them and almost no data actually.
>>
>> mySQL 5.0.15
>>
>>
>> ÐÆ5ÏÐ
>>
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe: http://lists.mysql.com/mysql?unsub=lig@maolek.com
>>
>>
>>
>>
>
>
>


--
Chris W
KE5GIX

"Protect your digital freedom and privacy, eliminate DRM,
learn more at http://www.defectivebydesign.org/what_is_drm"

Gift Giving Made Easy
Get the gifts you want &
give the gifts they want
One stop wish list for any gift,
from anywhere, for any occasion!
http://thewishzone.com