I have a MySQL db on Machine A and I want to access the mysqldump from machine B.
Both machines are running on Linux and I also have the credentials of both, but I can't access the mysqldump. What can I try?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
In General if you have the credentials for accessing MySql from Machine B.
You should have MySQL user name , host name and Password.Then You can write the Command for taking backup
On Machine B Write
mysqldump -h Your_host_name -u user_name -p password --all-databases > backup.sql
If You Face issues there may be some network issue try some things as