Take the 2-minute tour ×
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's 100% free, no registration required.

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.

share|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 '12 at 10:18

2 Answers 2

up vote 5 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)
share|improve this answer
    
If you still face the issue please update properly with your question. –  Abdul Manaf Feb 22 '12 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 '12 at 11:53

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

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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