2

I can ssh to a a server (on a private network, via VPN connection), that has Apache installed on. Internal ip for this server is 192.168.10.98. Web framework on this server can connect to MySQL server on 192.168.10.97. Also I can connect to MySQL server, on a client app via SSH Tunnel, considering that I only have access to Apache server (192.168.10.98). I can dump db when I connect to MySQL on the client app.

Connect to MySQL server

Now, how can I ssh to Apache server, and use mysqldump on MySQL server to dump the db and save in on Apache server?

$apache_server> mysqldump -h 192.168.10.97 -uopencart -p opencart_db > ~/opencart_db.sql | gzip -c > db.zip
    -bash: mysqldump: command not found

If MySQL Client App can do this, I have to be able too? But How?

2

You can install mysql-client through your package manager on the Apache server. This will install mysqldump and allow you to dump directly on the Apache server using the command you listed.

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.