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:[EMAIL PROTECTED] > 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:[EMAIL PROTECTED] > 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/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
