How to download an image to the file system on the local computer from a BLOB field of a remote MySQL server?

Question

MySQL

I can connect to a remote MySQL server using Workbench with a username and password.
The database has a Photo table, and it has an img BLOB field. How to download a picture from this field to the file system of the local computer?
If the MySQL server is installed on the local computer, then you can save the image to a file using the query:

SELECT img FROM Photo where id=5 INTO DUMPFILE '<filename>';

But what if the MySQL server is remote?

Answer 1

I'm not sure, but it seems that the client cannot do this through the MySQL GUI.
Take a dump and download pictures on your local computer.