Move Mysql Database To Another Server

Yes it is. Things that will affect how easy it is to do this, in order of things (imo) that make it harder.

1. Move to another server running the same OS and same version of mySQL with same permissions as you already have. Easiest.

2. Move to another server running same OS but different version of mySQL (ie. going from 5 to 4 requires a small edit to an export from phpMyAdmin)

3. Move to mysql on another OS, not really sure how much difference this makes, so I placed this 3rd LOL

3. Move to a completely different type of DB, like oracle or MS SQL Server. Usually for basic databases/tables this shouldn't be too hard, just need to make sure field types are right.

There are a few ways you can export your data, if it isn't too big, you could use phpMyAdmin to export. If you have shell access and permissions, you can do it in the shell (i forget offhand how to do this). But overall it shouldn't be too hard.

-Greg

If you have a large database (or sometimes even just a small one) your new web host will often gladly transfer it over for you.

Yes, it can be done. I recommend using mysqldump. If you have telnet or ssh access to both your webhosts and it's Linux/Unix based, the scp command works wonders.

Is simple, just use navicat, is a very good software. For more details go here.

http://www.navicat.com/

I have to second Navicat's ease of use. Of course, it has nothing to do with setting up the new server if you're the admin of that server. But if you're just the admin of your DB and want to move from one DB server to another, Navicat is a great tool.

I use the Mac version myself, and also have it back up my database to my local machine weekly.