Hey there-
One thing to watch out for is transferring mysql databases between versions. It can give you headaches.
I am in the process of transferring all of my blogs over to a new hosting account that has a diff mysql version.
to save you some headaches, what I did was to create the appropriate tables with no data in them on my new server, (if using joomla or wordpress you can just run a basic install and it will do it for you, then go through an empty all data (I didn't empty options so that my old blogs address didn't get stuck in the new install))
then dump the data from the old database, just the data as a text, open in text editor and remove all the extra jargon aside from the INSERT{blah blah blah} stuff. (PS I didn't dump the options portion just all the rest on a wordpress transfer) then copy and paste into the new database sql query page. and presto. you've transferred. If using a wrodpress install like I did this transfer should overwrite the user the install setup and your password and user name will be the same as the old one but setup for the new server and web address.
Hope that saves some frustration.
|