Daevid Vincent wrote:
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_query can only run one statement at a time so you'd have to either:
- create a big array with the queries you want to run and run over them
with a foreach loop.
- load up the sql file and explode on a character (eg newline or ; ) to
get the separate queries
I'm sure there are other options but these are the two I regularly use.
--
Postgresql & php tutorials
http://www.designmagick.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]