Does anyone know of a software that will backup and transfer MYSQL Databases easily to different hosts?

Does anyone know about Word Press forum backup and transfer software as well?

Thank you for any help

The default MySQL Administrator application will let you do backups and restores of entire databases. I use that as a medium of transfer often, and it works well.

If you give your system remote access privileges to your Wordpress MySQL server (usually via cpanel) you should be able to back up/restore it just like any other database.

Thank you for your reply. As I am new to MYSQL, I don't have a clue what you just said.

Would you tell me how I find MYSQL Administrator Application.

How do I give my system remote access privileges to Wordpress MYSQL Server.

Just a little background.
I am trying to transfer entire site and databases from Dreamhost to FatCow. I am using the Direct FTP, to transfer the files and folders but not the MYSQL.

Thank you

export sql

You can grab a dump of the database by going to your control panel
Goto phpMyadmin
Choose the export tab at the top
in that screen you will see a select list of the databases
choose your database,, and at the bottom of the page choose "save as file"
and hit go
save the file to your computer.

Import SQL

In the new host, do the same
Goto phpMyadmin
choose the Import tab at the top
Browse to the file you just saved on your computer
and hit the "go" button at the bottom.

I have no clue how Dreamhost or Fatcow work, so I can't give you any advice on getting to your hosted databases there unless they use a standard interface like cpanel to access your files. If you have cpanel access, you can get to the export and import functions with a utility they provide called PHPMyAdmin.

If you can't get to such tools supplied by your host provider you'll need to figure out how to grant outside access to the databases (again, that depends on your host and you'll need to ask them how to do it), and install your own tools, such as the one I first mentioned--actually, I just checked and they've revamped their tool set so what you'd want is the Workbench tools:

http://www.mysql.com/downloads/workbench/

Seriously, this really comes under the purview of technical support from the two host providers you're migrating between because they might have particular issues there's no way someone outside would know about. Have you contacted them for support yet?

What Dave said--except that assumes you have that tool available. If you do, you're golden.

I appreciate the replies from everyone. I have not contacted them as of yet but I will try. I do believe though I do have cpanel as well.

My fear as always when dealing with two different companies, is the typical: "blame the other company" type of deal.

Again thank you.

No prob...let us know how it goes.

*assuming they both have phpMyadmin..
One difference can or maybe the database location which is set in the configuration file for each application.
*some are( localhost ),, and some are different such as( my-account-name.my-host-name-mysql.com )
Usually they will have that info in your control panel or you can find it in the phpMyadmin screen.

But if it's an Apache server,, it should be somewhat compatible from one host to another.