How to download blob via powershell?

Question

MySQL

It is necessary to remotely load a blob file into the table, but powershell refuses to do this. Here is the request:

$sql.CommandText = "UPDATE field SET config = LOAD_FILE('c:/users.bin') WHERE name = 'DynField'"

If I thus try to load, then in the table value [NULL]. Can you please tell me how to upload a file even not through powershell, does the file have to be on the database server?

Answer 1

the command is executed on the server, so the file must be available on the server. you can put in a ball