Re: What's the PHP equivallent of "mysql mydb < somefile.sql"

2006-10-10 Thread Chris W
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

RE: What's the PHP equivallent of "mysql mydb < somefile.sql"

2006-10-10 Thread Daevid Vincent
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 [ma

RE: What's the PHP equivallent of "mysql mydb < somefile.sql"

2006-10-09 Thread Ligaya A. Turmelle
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

Re: What's the PHP equivallent of "mysql mydb < somefile.sql"

2006-10-09 Thread Chris
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

What's the PHP equivallent of "mysql mydb < somefile.sql"

2006-10-09 Thread Daevid Vincent
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?