If you’re one of the ones who are having trouble upgrading your WordPress blog to 2.9 which is hosted by 1and1, here’s how I did it:
- While in your WordPress Dashboard, click on Tools, then Backup. Back your stuff up!
- Then click on Export and export your database. Remember where you put it. I recommend downloading it to your computer.
- Sign into your 1and1 account.
- Then head to the Administrative side of things.
- From there click on MySQL Administration.
- Choose to make a New Database and choose MySQL 5.0.
- Give this database a name. Mine is Blog 2.0 for example.
- Type in a password.
- Click Set Up. You’ll be returned to the MySQL Database Set Up and Configuration screen.
- Once your MySQL 5.0 database is all set up, you’ll need to import your WordPress database files.
- Click on phpMy Admin
- You see the big blue box to the top left that says 1&1? Underneath that, click on the SQL white icon.
- Click Import files.
- Hit Choose and then select the backed up folder that you saved on your computer.
- Press Go now. Give it a couple minutes to upload everything.
- Once that’s done, it’ll pop up a confusing screen but feel free to shut the window/tab now. You’re done here.
- Now open up your ftp program (I recommend Filezilla) and go find wp-config.php. It may be in a folder if that’s where your WordPress is stored.
- Open it up in a text editor (Windows users have Notepad as their default text editor).
- At the top of the page, you’ll see instructions about where to put in your new database name, user name, host name, and password. Update these according to what the MySQL Database Set Up and Configuration tells you. Copying and pasting is probably the easiest method. The password is the one you made up earlier.
- Save your file.
- Then import this updated filed back where you got it from.
- Now go to your WordPress website’s URL and make sure everything is working. Okay? Next step then.
- Go back to your WordPress Dashboard. At the top of the page should be a link telling you to upgrade to 2.9. Do so.
- Now go back again to your website URL. Ta-dah!
Now go play!
Help from this website.
If you enjoyed this article, please consider sharing it!
What do I do if I can’t get into my Dashboard to backup stuff? I used WP Automatic Upgrade and saved 2 zip files during the process — are those the same as if I’d done your Step 1? Did you have any size issues like the expand2web guy who had to manually paste the stuff in?
I didn’t have any issues. But my other back-up method was to log into my 1and1 account and just download my entire blog to my computer just in case.
Thanks for posting this, it’s helpful. I used it to update a couple of blogs that are running at 1and1. The unfortunate thing about the SQL backups and restores is that somehow all of the accented characters either get turned into unreadable characters or regular characters when the backup file gets imported through phpMyAdmin. I do wish that didn’t happen, as I’ve had to go through pages and posts manually to correct them. Thank goodness these weren’t big blogs, or I’d have had to find another way to upgrade the DB.