RE: What's the PHP equivallent of "mysql mydb < somefile.sql"

[Daevid Vincent]

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@stripped] 
> Sent: Monday, October 09, 2006 6:57 PM
> To: Daevid Vincent; mysql@stripped
> 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@stripped] 
> Sent: Tuesday, October 10, 2006 11:01 AM
> To: mysql@stripped
> 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=1
> 
> 
>