Take the 2-minute tour ×
WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. It's 100% free, no registration required.

I'm trying to migrate an old wordpress site to a new host - the old installation hasn't been updated for a while and is still on 2.6.5 while the new install is 3.2.1 (current). Unfortunately the old front end is currently not working, so I can't use anything there.

I'm wondering if there's a tool or way to update the existing 2.6.5 database to be compatible with 3.2.1 so that I can just load all of the existing data into the new system via a SQL query.

share|improve this question

migrated from webapps.stackexchange.com Aug 18 '11 at 19:27

This question came from our site for power users of web applications.

    
Sounds like migration to WordPress Answers may be in order –  Eight Days of Malaise Aug 18 '11 at 19:19
    
All versions of Wordpress are listed here. Download whichever you need. –  navjotjsingh Aug 21 '11 at 7:00
add comment

4 Answers

Upgrade by simply overwriting the new version of WordPress files, you will get the prompt of upgrading the database when logged in. Do backup the files & database before trying to do anything so that you can always revert back to the old state in case something goes wrong.

Most probably the upgrade will work directly without doing incremental upgrades. And if you would want to, then you can get any version of WordPress like this http://wordpress.org/wordpress-2.9.zip Change the version in the URL according to the version you want.

share|improve this answer
add comment

If Ashframe's solution doesn't work, try upgrading step by step, for example, first to 2.8, to 3.0, 3.1 and to 3.2. Although I don't know where to get the old version of WordPress.

share|improve this answer
    
I added that info to my answer,thanks –  Ashfame Aug 19 '11 at 8:39
add comment

So I ended up finding a bit of a workaround that works as a solution for this:

  1. Dump the existing database and download the .sql file
  2. Create an entirely new Wordpress installation on your host - go through all the steps including creating a database (Let's call it Database A)
  3. Create a new, empty database (Let's call it Database B) in addition to the one created for your new WP install - this is critical, because of the differences in versions, you cannot simply upload the existing .sql data into the new version database
  4. Import your existing data into Database B
  5. By default, your WP-Config will be pointed at Database A, modify it to be pointing at Database B
  6. Goto your site's admin (example.com/wp-admin) and login - you will be presented with the ability to upgrade your database to the current version structure

Voila!

share|improve this answer
add comment

I wish I'd found this earlier this week. But i just found my own workaround and blogged about it http://www.southerncrossroads.info/philsblog/log-reeeeeeeaaaaally-old-wordpress-installation/. In a nutshell, I started a new Wordpress and manually exported and then imported the necessary table rows, one by one. Check out the link for details.

share|improve this answer
1  
Answers should be more than plain links. They should actually be an answer instead of a route where someone will maybe find an answer. Please help preventing link rot, edit your answer and provide the needed information that helps the OP as well as later visitors to solve their problem. –  kaiser Jun 18 at 18:02
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.