How to move WP blog from one server to another?

No, its not an issue of 32/64 bit.

How much RAM does your server have?

MySQL configuration file is my.ini which is located in:
C:\ProgramData\MySQL\MySQL Server 5.1

Keep in mind ProgramData is a hidden folder.

The server has 8GB of RAM.

Are you suggesting that I need to edit the MySQL config file? If so, what edit do you suggest?

Also, is there not an application that allows one to modify or configure MySQL that is separate from MySQL?

I tried editing the my.ini file saving a copy of the existing one first however MySQL could not even start with the new .ini file. Copied back the previous one and it started right up.

I tried restoring the DB again this morning and while I get a bit further I still get the following:

[Msg] Decompressing…
[Msg] Table Created: wp_commentmeta
[Msg] Table Created: wp_comments
[Msg] Table Created: wp_counterize
[Msg] Table Created: wp_counterize_keywords
[Msg] Table Created: wp_counterize_pages
[Msg] Table Created: wp_counterize_referers
[Msg] Table Created: wp_counterize_useragents
[Msg] Table Created: wp_links
[Msg] Table Created: wp_options
[Msg] Table Created: wp_postmeta
[Msg] Table Created: wp_posts
[Msg] Table Created: wp_stw_log
[Msg] Table Created: wp_terms
[Msg] Table Created: wp_term_relationships
[Msg] Table Created: wp_term_taxonomy
[Msg] Table Created: wp_usermeta
[Msg] Table Created: wp_users
[Msg] Importing Data…
[Msg] Table Restored: wp_commentmeta
[Msg] Table Restored: wp_comments
[Msg] Table Restored: wp_counterize
[Msg] Table Restored: wp_counterize_keywords
[Msg] Table Restored: wp_counterize_pages
[Msg] Table Restored: wp_counterize_referers
[Msg] Table Restored: wp_counterize_useragents
[Msg] Table Restored: wp_links
[Msg] Table Restored: wp_options
[Msg] Table Restored: wp_postmeta
[Msg] 2006 – MySQL server has gone away
[Msg] Table Restored: wp_posts
[Msg] Rolling back…
[Msg] Finished – Stopped before completion
————————————————–

Fine, lets give your MySQL server more RAM cause it will need it.

innodb_buffer_pool_size=2GB

innodb_log_file_size=512M

Save the file and now go to:

Start > Administrative Tools > Services > Find the MySQL services, right click and turn it off/stop. Keep the “Services” window open.

Now go to C:\ProgramData\MySQL\MySQL Server 5.1\data and delete the following 2 files: ib_logfile0 & ib_logfile0

Now go back to the “Services” window and START the MySQL services.

Once MySQL is running, go back to Navicat and start a new Restore for your WordPress database!

I was really thinking it was going to work this time however, I still get the same messages:

[Msg] Decompressing…
[Msg] Table Created: wp_commentmeta
[Msg] Table Created: wp_comments
[Msg] Table Created: wp_counterize
[Msg] Table Created: wp_counterize_keywords
[Msg] Table Created: wp_counterize_pages
[Msg] Table Created: wp_counterize_referers
[Msg] Table Created: wp_counterize_useragents
[Msg] Table Created: wp_links
[Msg] Table Created: wp_options
[Msg] Table Created: wp_postmeta
[Msg] Table Created: wp_posts
[Msg] Table Created: wp_stw_log
[Msg] Table Created: wp_terms
[Msg] Table Created: wp_term_relationships
[Msg] Table Created: wp_term_taxonomy
[Msg] Table Created: wp_usermeta
[Msg] Table Created: wp_users
[Msg] Importing Data…
[Msg] Table Restored: wp_commentmeta
[Msg] Table Restored: wp_comments
[Msg] Table Restored: wp_counterize
[Msg] Table Restored: wp_counterize_keywords
[Msg] Table Restored: wp_counterize_pages
[Msg] Table Restored: wp_counterize_referers
[Msg] Table Restored: wp_counterize_useragents
[Msg] Table Restored: wp_links
[Msg] Table Restored: wp_options
[Msg] Table Restored: wp_postmeta
[Msg] 2006 – MySQL server has gone away
[Msg] Table Restored: wp_posts
[Msg] Rolling back…
[Msg] Finished – Stopped before completion

Change innodb_buffer_pool_size=2GB to innodb_buffer_pool_size=2G and restart MySQL.

Goto navicat Tools > Server Monitor > MySQL. Choose localhost, then Variables. Scroll down the Variables and find ‘max_allowed_packet’ and ‘wait_timeout’. Double the amount for both, save and Restore again.

HALLELUJAH!! That did it.

Now before I edit the DNS settings to point to the new IP address is there a way to test that the blog works?

Like perhaps https://localhost/wordpress/index.php?

Whats the website path on your server?

Example: C:\inetpub\wwwroot\websites\test “test is the website name”

IIS is fully installed, correct?

Yes, IIS is fully installed. All my other websites work just fine on that server.

The blog is configured in IIS on the new server as it was on the old server.

The path is not in INETPUB\WWWROOT.
It’s in C:\Blog\Wordpress\index.php as it was on the old server

I went ahead and just changed the DNS settings to point to the new server IP address however, I get a Page Cannot Be Displayed Error.

The URL to the blog is https://blog.jollyrogersmotorcycleclub.com

Actually, I am further ahead than I was a few moments ago. Now instead of getting a Page Cannot Be Display Error, I am getting:

Error establishing a database connection

Check your database info in wp-config.

https://blog.jollyrogersmotorcycleclub.com/wp-admin/

yeah… already checked that. the wp-config file is identical to what is on the old server

?Are you sure you have the correct username and password? YES
?Are you sure that you have typed the correct hostname? YES
?Are you sure that the database server is running? YES, if the way to confirm is by checking if MySQL is running

Edit your php.ini file:

change:

mysql.default_socket =

to:

mysql.default_socket = /tmp/mysql.sock

Now I get Page Cannot Be Displayed Again

The 500 error is related to PHP. Did you setup and config php correctly??

It should be set to FastCGI I think.