I am working on a web app that is hosted on a web server in a demilitarized zone (DMZ). I need to run MySQL queries on the database that is on its own server which is on the same local network as the web server, but not accessible via the internet.
I can access the Web Server using putty, and the web server has MySQL installed. I can also SFTP sql files to the webserver.
I feel like I have all the Tools I'm just mising some knowhow! Any help on how I can execute these sql files would be greatly appreciated.
Thanks in advance,