Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have to clean up as mess for a client.

The DNS record of the domain has been moved to a different server (IP address). But I need to retrieve MySQL data from the old server. I still have the ip address of the old server.

Problem is that there was never a administration software like phpmyadmin.

I have the username, password, database name and host(localhost) for the database on the old server.

How do I do this?

share|improve this question
    
What was the method by which you had accessed earlier ? what command/tool did you use ? –  proy Jan 26 '10 at 13:09
    
I didn't. I inherited a mess. –  Cudos Jan 26 '10 at 13:46
add comment

2 Answers

up vote 4 down vote accepted

If you have the mysql client on your machine, you should be able to just

bash#  mysqldump -h[ipAddress] -u[username] -p  [dbname]  > outfile.sql
share|improve this answer
add comment

phpMyAdmin can access servers other than localhost.

share|improve this answer
add comment

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.