MySQL Dump from Remote Host?

Anon

I\'m moving servers, and I have a major problem. I want to back up the database that I\'m currently using, but have no direct access to it since it\'s remotely hosted.

I can administrate it and such through a web-based frontend, but I can\'t figure out how to make a dump file for it.

Right now I\'ve used <A HREF=\"http://phpbuilder.com/snippet/detail.php?type=snippet&id=135\">PHPdbView</A> to grab all of the data from my database, but I\'ve got 500+ stories, and no time to enter each one manually on my new server.

Are there any scripts like PHPdbView that will grab all of the data, and put in dump file format? I\'d do it myself, but I\'m still a pretty rank newbie. Any help would be greatly appreciated. Thanks in advance.

yelvington

Install phpMyAdmin

view the top page for your database

Look for the line that says "View dump (schema) of database"

click the radio buttons labeled "structure and data" and "send"

Push the submit button labeled "GO"

Result: Complete database dump as a single .SQL file, downloaded to your browser.

Anon

Unfortunately I'm not able to do that. My host has a sepcific program that they force me to use - Mysql Database Manager (http://billow.cjb.net). It's the only access I have to my MySQL database. I've been playing with it, and I can't find anything in it similar to the option in phpMyAdmin. Any other ideas?

yelvington

If you are allowed to connect with MySQL using PHP on your host, you can install phpMyAdmin in your own Web space and it will work just fine. Takes about five minutes.

Alternatively, see if you do something like this:

<?
header('Content-type: application/octet-stream');
exec('mysqldump -umyusername -pmypassword mydbname'😉
?>

This should cause your browser to prompt you for a download, and (if mysqldump is accessible by the Web server) feed you a complete data dump.

yelvington

Oops. Fix that semicolon location:

exec('mysqldump -umyusername -pmypassword mydbname');

yelvington

One more time. <sigh>

I forgot that exec() runs the command but does not echo the results, so do this instead:

<?
header('Content-type: application/octet-stream');
echo mysqldump -umyusername -pmypassword mydbname;
?>

Note the use of the backtick operator. Those are not single quotes.

Anon

Thanks for all of your help. Right after I posted, I realized what you meant. I'm going to do that when I get home, and see how she goes. Once again, thanks. <bows>