up vote 2 down vote favorite
share [g+] share [fb]

I have MySql db on Machine A , I have Mysql credentials. And accessing this MySQL from machine B which I have crdential's. But I couldn't take mysqldump from Machine B. Please help me. Both ae Linux machines.

link|improve this question
can you update your question..? Please write the lines what you are doing and what's the error is there on your end then only we can answer in exact manner.are you accessing the machine using ssh. – Abdul Manaf Feb 22 at 10:18
feedback

2 Answers

up vote 3 down vote accepted

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

  1. Use ping with ip address to check that DNS isn't broken. eg. ping Machine A
  2. Use mysql client to connect from B to A. eg mysql -u user -pPASS --host=Host_Name --port=3306 (substitute whatever port you are connecting to the master on)
link|improve this answer
If you still face the issue please update properly with your question. – Abdul Manaf Feb 22 at 10:47
Thanks, the below script works for me,mysqldump -h 69.90.80.36 -p -u resolution -P 3307 communitycourts > backup.sql. As I haven't mentioned port number earlier, So it was not working for me. – Selvakumar P Feb 22 at 11:53
feedback
up vote 0 down vote

if you use --host MachineA as parameters of mysqldump should work

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

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