homepage Welcome to WebmasterWorld Guest from 54.237.213.31
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / Hardware and OS Related Technologies / Website Technology Issues
Forum Library, Charter, Moderators: phranque

Website Technology Issues Forum

    
Moving DB site from one server to another
What's the latest thinking? Any new tools or tips?
weeks

WebmasterWorld Senior Member 5+ Year Member



 
Msg#: 3602880 posted 1:39 pm on Mar 17, 2008 (gmt 0)

I did a search on WW on this and a lot of what I found was dated, so might I ask:

In 2008, what issues today do we need to be concerned about moving a MySQL (or a MS SQL database) from one leased server to another? We're getting what seems to be some half-baked advice.

 

rocknbil

WebmasterWorld Senior Member rocknbil us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 3602880 posted 2:36 pm on Mar 17, 2008 (gmt 0)

I've found two.

The first is the mysql version. Generally, this doesn't create many hiccups but you can sometimes get incorrect results moving up to a later version if you coding uses deprecated methods. Sorry, my examples are half -baked and can't recall a specific one. :-)

The second is encoding. For example, if you use the mysql encode() or decode() functions and your original tables are set for latin1, and the default for your new database is utf-8, your queries may not return correct values. The solution is to update the tables to latin1 collation.

Other than that, using the mysql command "source" will repopulate a DB from a mysqldump file in no time flat.

weeks

WebmasterWorld Senior Member 5+ Year Member



 
Msg#: 3602880 posted 5:25 pm on Mar 17, 2008 (gmt 0)

We have been told to watch out for problems with some of our "columns" or tables vis a vis PHP, that we might have to copy and paste. But I can't figure out why that would be. Anyone have a clue what this is about?

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Hardware and OS Related Technologies / Website Technology Issues
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved