What's the PHP equivallent of "mysql mydb < somefile.sql"
| From: | Daevid Vincent | Date: | Tue, 10 Oct 2006 01:01:16 +0000 |
| Subject: | What's the PHP equivallent of "mysql mydb < somefile.sql" | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-42519@lists.php.net to get a copy of this message | ||
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ÏÐ