Read the section on the manual on the Client and Utility programs,
specifically mysql. The syntax is essentially the same as you have in
your code .... something like this from the command line....
mysql -u dbUser -pMyPassword dbName <SomeFileWithLotsOfSQLCommands.sql
Note there is no space between the '-p' and the password.
Daevid Vincent wrote:
Could you be more specific? What is "SOURCE"? Where do I use that? I tried
to search, but I find a lot of hits related to source code.
-----Original Message-----
From: Ligaya A. Turmelle [mailto:[EMAIL PROTECTED]
Sent: Monday, October 09, 2006 6:57 PM
To: 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 [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 < somefile.sql"
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ÏÐ
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
Chris W
KE5GIX
"Protect your digital freedom and privacy, eliminate DRM,
learn more at http://www.defectivebydesign.org/what_is_drm";
Gift Giving Made Easy
Get the gifts you want &
give the gifts they want
One stop wish list for any gift,
from anywhere, for any occasion!
http://thewishzone.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
