Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
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

phpMyAdmin can access servers other than localhost.

share|improve this answer

Your Answer


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.