Welcome to WebmasterWorld Guest from 188.8.131.52
Forum Moderators: phranque
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.
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.