foottuns — Mon, 06 Nov 2006 23:50:49 +0000

same here, i am using on mac too. but my back ups are daily
since my website is update it daily i have to do the back up all the time.

timjpriebe — Tue, 17 Oct 2006 12:28:04 +0000

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.

foottuns — Wed, 11 Oct 2006 19:58:33 +0000

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

http://www.navicat.com/

Arch — Wed, 13 Sep 2006 03:47:34 +0000

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.

Busy — Wed, 30 Aug 2006 22:22:12 +0000

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.

Greg K — Wed, 30 Aug 2006 12:05:32 +0000

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