Re: Error Code: 1290. The MySQL server is running with the --secure-file-priv option so it cannot execute this statement

[Peter Brawley]

You need 'Local' if and only if you are uploading to a remote server configured to accept remote uploads. You're uploading locally, no need for the complications that the 'Local' keyword introduces.

It makes intuitive sense to set secure_file_priv to a folder you'll use for uploads, but then MySQL needs to confirm an exact dirname match and the vagaries of Windows' asinine path syntax often make this difficult, so I suggest you set secure_file_prov to '', restart the server, then try it again.

And the mysql progrem auto-translates Microsoft's backslashes to forward slashes, so use them in your path args rather to avoid backslash escape issues.