That is because "source" is a mysql client command, not as sql command.
It gets executed by the client 'mysql'.
The 'mysql' client reads it line by line, and passes the lines to the
server.
The server never sees the scriptfile.sql.
You will have to write a PHP modules that reads the file, and pa
When in MySQL in a terminal, if I enter the command "source scriptfile.sql",
MySQL correctly executes the source file.
However, if using PHP, I execute the following commands in a PHP file:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
T