Updated 2.5 to 3.0.4, but 1&1.com host…

*sigh* Kick 1&1. Tell them you need to be upgraded. They SHOULD have done this.

Also do this: https://faq.1and1.com/scripting_languages_supported/php/5.html

2.5 to 3.0 is a BIG leap by the way. Make EXCELLENT backups!

Yeah, I made backups.

And actually my blog is still “visible” at jerrypettit.com/blog — I just can’t access it any more as administrator.

I did backup (did the “to the server” option AND then downloaded to my computer–I was surprised at the small size of the downloaded file…hope I did that right.

I’m GOOGLING in meantime. Thanks for the quick input. I hope I get through this…

Well if WP is choking on the SQL version, then the fix is to … fix that.

The Database won’t be too big for most people. Mine’s like 7 megs.

And you’re telling me that with respect to the PHP5 I can just open my current .htaccess file and add the line

AddType x-mapp-php5 .php

at the end of that file and all will be well with any PHP issue?

GOOGLING “1&1.com MySQL version” got me to a run through on what I apparently need to do.

For PHP yes.

For SQL … there’s a way to upgrade that too? Wow. Okay, they’re slightly less annoying than I thought ??

Yes, I’m walking through this procedure and so far, so good:

https://ksimonian.com/Blog/2010/07/27/dreaded-1and1-com-mysql-4-0-to-5-0-upgrade-for-your-wordpress-blog-upgrade-from-version-2-86/comment-page-1/#comment-14616

May want to pass that site around.

Sigh…

Did all that and get this message:

“Error establishing a database connection”

Where do I start?

I upgraded to a MySQL database, exporting my old 4.0 database to 5.0.

I put the line “AddType x-mapp-php5 .php” into my .htaccess (there is supposed to be a space before the period there, right?

I put in my blog’s URL and I get that error message…

I lied–I forgot I had changed password and miswrote it in my wpconfig.php file.

I seem to be “in”.

Thanks a million for all your help.

Check the database hostname with 1&1. From what I recall, the host names are database specific on 1&1.

Ok, I’m able to log in and access my dashboard now.

And I was able to reselect my old theme and reactivate my plugins.

So the install is seeing some of my stuff.

One problem: Where are my old posts? The blog is not showing them–just a new “Hello World” post.

(At least, I’m starting to get optimistic…)

Are your old posts in the new database?

That was my assumption. If everything else moved correctly, don’t the posts move also?

How does one check whether the old posts are successfully in the new database? I DID import the old MySQL database and read it into the new one…

I went back to 1&1.com and logged in to see PHPMyAdmin and the old database does look different than the new one. (I don’t really know how to “read” what’s happening there.

Apparently the “conversion” of databases didn’t work? How do I fix this? Repeat the steps I apparently did erroneously before?! (Again, I do have these posts backed up).

In my new 5.0 PHPMyAdmin screen of the new database, it shows these files:

wp_commentmeta
wp_comments
wp_links
wp_options
wp_postmeta
wp_posts
wp_terms
wp_term_relationships
wp_term_taxonomy
wp_usermeta
wp_users

Is that good? ??