Re: MySQL Import Automation

[Phillip Ward]

1. Do yourself (and others) a favour and lose the "On Error Resume Next"

This directive "masks" any and all errors, allowing the code to plough on regardless, no matter what happens. Not what you want for Production code, I would suggest.


Thank you for sharing your password with us.

2a. Go and change this password immediately.

2b. Learn how to supply credentials to MySQL utility program securely.
https://dev.mysql.com/doc/refman/8.4/en/option-files.html


3. To access MySQL on another host, use the "--host <hostname>" option.

Regards, Phill W.