mysql_real_query unable to do "source" command

[shane man]

Hi

I was wondering is this a known limitation for the mysql_real_query API that it cannot support the "source" command?

I have a sql file that I want to apply to a database, but for error tracking reasons I want to use the mysql API instead of passing the file into mysql.exe because I cannot obtain stderr from my process.

Is there an API that will allow me to apply a sql file to a database?

I do not want to have to parse through the file, because then I run into the problem of multiline statements, and mysqlbinlog does not delimit 1-line statements with a ';'.

Thanks,

Shane