Hi,
Is it possible to move my mysql database to another server?
SBalan Group
http://www.sbalanprojects.com/
Navigation
User login
Advertisers
aPaddedCell © Copyright 2006-2007 InterMedia. Site and all articles (unless otherwise specified) licensed under a Creative Commons License.
Greg K posted this at 12:05—30th August 2006.
He has: 1,601 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
[This space intentionally left blank]
Cool Geek Supplies: www.ThinkGeek.com
Busy posted this at 22:22—30th August 2006.
He has: 6,148 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.
<?bhb if(broken){ echo("It wasn't me
"); } ?>
Learn HTML the ez way - EzHTML.net
Some people are like slinkies, they dont really serve any purpose but they still bring a smile to your face when you push them down the stairs ...
Arch posted this at 03:47—13th September 2006.
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.
foottuns posted this at 19:58—11th October 2006.
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/
Submit Articles
Cheap Hosting Plans, Domain Names, Dedicated Servers
timjpriebe posted this at 12:28—17th October 2006.
He has: 2,666 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.
Tim
http://www.tandswebdesign.com
foottuns posted this at 23:50—6th November 2006.
They have: 78 posts
Joined: May 2006
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.
Submit Articles
Cheap Hosting Plans, Domain Names, Dedicated Servers