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.
> 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