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 need to migrate a website to another host. I have only FTP server access and MySQL name+pass (the MySQL server's IP I was provided is, and there's neither PhpMyAdmin nor SSHell to use). A web app run there can access the DB using credentials I know and localhost server. So I'd need a PHP script, that will correctly dump all the available databases of the MySQL server so that they can be imported on the new server. Can you recommend a good one?

share|improve this question

Hmmm my first mind was:

$command = 'mysqldump -h hostname -u user -p password db_name > dumped_db.db';

Anyway here is a class:

And ready tool (Bigdump is really cool!):

share|improve this answer

Mysqldump is what you are looking for, though its written in perl (all nix's have perl)

share|improve this answer
I'll try if I find no other solution, but that's a strictly sandboxed shared PHP hosting (the ISP provides only static, PHP and ASP tariffs), it may not have Perl enabled (but may have, worth a try). – Ivan Oct 4 '10 at 5:11

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.