tdehan

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

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?

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?

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.

ah… nevermind… I found it! 🙂

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