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?

  • 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

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

phpMyAdmin can access servers other than localhost.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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