How to move WP blog from one server to another?

https://codex.www.ads-software.com/Moving_WordPress#Moving_to_a_New_Server

Whats the hosting environment for each server?

Sorry, I should have stated the environment. Windows Server 2008 / IIS

You can download Navicat “Trial Version” and install it on the old server.

Open navicat, click on Connection, then MySQL.

Connection name: localhost
Hostname: localhost
Port 3306
User: mysql user
Pass: mysql pass

Save it and you will see “localhost” in the left sidebar. Double click it and you will ALL the databases you have on your server. Double click your blog database and choose “Backup” and generate a backup. Then take the backup file to your new server.

Install navicat on the new server, setup connection with MySQL, create new database “Any name”, go to backups and click on Restore. Browse and select the backup file you got from your old server.

Now you have moved the database and you need to move your files which is basicly copy/paste from one server to another.

If your new database has a different name from the old one, you need update your database settings in wp-config.

I have Navicat installed on the older server. It is asking me for a MySQL password (Enter password for mysql user@localhost) which apparently I don’t remember. None of the passwords that I am trying let me make the connection in Navicat.

Is there a particular MySQL file I can look into see what my password is?

ah… nevermind… I found it! ??

this is probably a sill question… I assume in need to install MySQL on the new server prior to Restoring the backup, correct?

Yes, MySQL 5.0 or higher ??

Thanks ??

Ok, hopefully I am close now. here is where I am at:
1. I’ve copied the blog folder to the same location as the old server on the new server.
1. Assuming that I did indeed needed to install PHP on the new server is there any configuration I need to do or will the restore of the DB take care of the PHP end? If there is configuration that I need to do is it possible to copy files from the old server PHP configuration to the new server? The old server is running PHP 5.2.8. I installed 5.3.8 on the new server as I don’t know if there
2. I’ve backed up the DB using Navicat per the instructions above
3. I’ve installed MySQL 5.1 for Windows
4. I also assumed I needed to install PHP on the new server, which I just completed.
5. I’ve copied the DB backup to a folder on the new server and also have installed Navicat on the new server. However, I’ve not yet run a restore on the DB

Now for a couple more (hopefully not silly) questions:
is an issue with what I am trying to do and the latest version.

2. Is there any configuration of MySQL I need to do or will the DB restore take care of that as well?

3. I haven’t changed the DNS settings (IP address)for the blog to point to the new server yet. Hoping there is a way to test that all works with the restore on the new server prior to actually pointing the domain name to the new IP address.

Thanks so much for all the help so far.

Yes, you will need to install PHP on your server and I believe the default PHP configuration should be fine for WordPress.

As for MySQL configuration, its also fine for WordPress, unless your talking about MySQL optimization & performance, such as how much RAM your server has and how much RAM you want to allocate to MySQL.

You might want check your new server Firewall as well, and open the needed ports…etc

I think we covered most of the transfer so everything should be running fine.

ok… looks like I am stuck now.

RESTORE is greyed out on Navicat.

Above you state the following:
Install navicat on the new server, setup connection with MySQL, create new database “Any name”, go to backups and click on Restore. Browse and select the backup file you got from your old server.

I am guessing from where you say “setup connection with MySQL, create new database Any Name”. I need to do this within MySQL. Correct?

Open navicat, click on Connection, then MySQL.

Connection name: localhost
Hostname: localhost
Port 3306
User: mysql user
Pass: mysql pass

Then double click on localhost and all databases on the server will show up. Right click localhost and choose “New Database”

Double click the new database after you create it, and go to Backups and choose Restore.

All this is in navicat.

ok… that was easy…thanks so much again.

When I run restore it appears to do the deed. However, I get this at the end:

2006 – mySQL server has gone away
Rolling back
Finished – Stopped before completion

And then it gives me the option of Start or Cancel. However, it does appear everything is there.

Is there an issue with the latest version of MySQL as opposed to what I installed on the old server?

I dont think so but im gona make a wild guess and say that the database is too large and MySQL doesn’t have enough RAM allocated to it.

Whats your WordPress database size?

Not sure how to tell. Where should I look for that?

The totally size of the blog folder is 158MB.

Is it possible that I am going from a 32bit to 64bit server?