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?
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
if you use
--host MachineA as parameters of mysqldump should work
This is for taking a dump of a specific table
mysqldump -h 'hostname' -vv -u'user' -p'password' database_name table_name | gzip > table_name.sql.gz
I put it like this and it works perfectly
mysqldump -P 7999 -h '192.168.1.25' -vv -u'user' -p'password' base_dados | gzip > base_dados.sql.gz