From: Daevid Vincent
Date: October 10 2006 1:00am
Subject: What's the PHP equivallent of "mysql mydb < somefile.sql"
List-Archive: http://lists.mysql.com/mysql/202466
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Currently I run an 'updater' script to run through a directory of .sql =
files
using something like this in PHP:
$COMMAND =3D "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
=D0=C65=CF=D0=20