EzMySQL UDF question

[dixonpete]

I'm trying to use the _EzMySql_Exec function to send a SOURCE command to MySQL so I can load some data from a MySQLDUMP'd file. It doesn't seem to want to go and get an error on that line even though I have permission for the logged in user.

Here's the code:

; this should work but doesn't. Source commmand not supported by the MySQL UDF library?

if Not _EzMySql_Exec("SOURCE " & StringReplace( @TempDir, "\", "/", 0) & "/delphi.sql") Then

MsgBox(0, "Error loading delphi database", "Error: "& @error & @CR & "Error string: " & _EzMySql_ErrMsg())

Exit

EndIf

Issuing the equivalent command from the MySQL box works fine. Everything else seems to work ok.

[dixonpete]

I'm trying to use the _EzMySql_Exec function to send a SOURCE command to MySQL so I can load some data from a MySQLDUMP'd file. It doesn't seem to want to go and get an error on that line even though I have permission for the logged in user.

Here's the code:

; this should work but doesn't. Source commmand not supported by the MySQL UDF library?

if Not _EzMySql_Exec("SOURCE " & StringReplace( @TempDir, "\", "/", 0) & "/delphi.sql") Then

MsgBox(0, "Error loading delphi database", "Error: "& @error & @CR & "Error string: " & _EzMySql_ErrMsg())

Exit

EndIf

Issuing the equivalent command from the MySQL box works fine. Everything else seems to work ok.

Seems one has to read the file line by line and submit it via the EZMySQL_Exec function. All is well.

[ProgAndy]

_EzMySQL_Exec is able to execute multiple queries, so try it It should be possible to simply pass the whole file content when it fits into the string.

Edited September 9, 2011 by ProgAndy