Move Mysql Database To Another Server

They have: 111 posts

Joined: Jun 2006

Hi,
Is it possible to move my mysql database to another server?
SBalan Group
http://www.sbalanprojects.com/

Greg K's picture

He has: 2,145 posts

Joined: Nov 2003

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

Busy's picture

He has: 6,151 posts

Joined: May 2001

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.

They have: 31 posts

Joined: Sep 2006

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.

They have: 78 posts

Joined: May 2006

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

http://www.navicat.com/

timjpriebe's picture

He has: 2,667 posts

Joined: Dec 2004

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.

They have: 78 posts

Joined: May 2006

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

Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.