Title: halninethousand's Replies | WordPress.org --- # halninethousand [ ](https://wordpress.org/support/users/halninethousand/) * [Profile](https://wordpress.org/support/users/halninethousand/) * [Topics Started](https://wordpress.org/support/users/halninethousand/topics/) * [Replies Created](https://wordpress.org/support/users/halninethousand/replies/) * [Reviews Written](https://wordpress.org/support/users/halninethousand/reviews/) * [Topics Replied To](https://wordpress.org/support/users/halninethousand/replied-to/) * [Engagements](https://wordpress.org/support/users/halninethousand/engagements/) * [Favorites](https://wordpress.org/support/users/halninethousand/favorites/) Search replies: ## Forum Replies Created Viewing 9 replies - 1 through 9 (of 9 total) * Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) In reply to: [Upgrade: 2.5 -> 2.7, Avoiding Gotchas](https://wordpress.org/support/topic/upgrade-25-gt-27-avoiding-gotchas/) * Thread Starter [halninethousand](https://wordpress.org/support/users/halninethousand/) * (@halninethousand) * [17 years, 1 month ago](https://wordpress.org/support/topic/upgrade-25-gt-27-avoiding-gotchas/#post-1040351) * Okay, according to the tech I talked to (and who, luckily, had a slow night and needed to kill time), here’s what he said would have worked from the start: * 1) Backup the WordPress directory 2) Backup the WordPress database directory 3) Uninstall WordPress 2.5.1 from my account 4) Install WordPress 2.7 to my account 5) Copy the files in the old WordPress database directory into the new one, replacing ALL files in there (or wiping the directory first) 6) Go directly to [http://mydomain.com/wordpress/wp-login.php](http://mydomain.com/wordpress/wp-login.php) 7) Log in 8) WordPress sees the database is not up to date and says it will update it — database is updated 9) Copy the wp-content and wordpress directories INSIDE the wordpress backup directory on the web site to the new wordpress directory on the site so all the images and media are left intact 10) RESTART MySQL. On my account, that was “/etc/init.d/mysql restart” but could vary on different setups. * And, according to him, that’s what it took. * So database schema, my skills, and so on, really had nothing to do with it. Since DB files had to be updated, if I had read and understood schema, I would have seen they were different and not known what to do. * One point, and I don’t know if this is a WordPress issue, is that on my earlier attempts to upgrade, the first thing I did was go to the main WordPress page on my website and I got the new install one post entry saying something like,“ This is your WordPress blog.” I don’t know if the problem was going there before logging in or if it was that I did not restart MySQL first. * So, overall, the answer is not in comparing one schema with another. It’s in what is backed up and restored because WordPress does the conversion automatically. If someone could have told me it would automatically update those tables, that would have been the quick and easy answer here. * Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) In reply to: [Upgrade: 2.5 -> 2.7, Avoiding Gotchas](https://wordpress.org/support/topic/upgrade-25-gt-27-avoiding-gotchas/) * Thread Starter [halninethousand](https://wordpress.org/support/users/halninethousand/) * (@halninethousand) * [17 years, 1 month ago](https://wordpress.org/support/topic/upgrade-25-gt-27-avoiding-gotchas/#post-1040333) * I’m taking another tactic — I had the techs at the hosting company restore backups for the past 5 days (each to a different directory, wp-1, wp-2, etc. and mysql- 1, etc.). The tech there that’s on tonight said it’s a slow night and it’s just a matter of a few copy commands and that WordPress will do the db updating automatically. It’s 3 am, I need serious rest (after an accident earlier this month — can’t turn my head much, meds make it hard to think and sleep, etc), so I’m going to let him finish it up. * Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) In reply to: [Upgrade: 2.5 -> 2.7, Avoiding Gotchas](https://wordpress.org/support/topic/upgrade-25-gt-27-avoiding-gotchas/) * Thread Starter [halninethousand](https://wordpress.org/support/users/halninethousand/) * (@halninethousand) * [17 years, 1 month ago](https://wordpress.org/support/topic/upgrade-25-gt-27-avoiding-gotchas/#post-1040330) * Yep, even though I know my hosting company won’t like it, I put WP 2.5.1 back in place, including the database files and directory, check that it’s all as it should be — and my blog is gone. * So if anyone can help me rescue my blog — someone that doesn’t expect me to read schemas that not everyone has the training to understand, I’d deeply appreciate it. * Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) In reply to: [Upgrade: 2.5 -> 2.7, Avoiding Gotchas](https://wordpress.org/support/topic/upgrade-25-gt-27-avoiding-gotchas/) * Thread Starter [halninethousand](https://wordpress.org/support/users/halninethousand/) * (@halninethousand) * [17 years, 1 month ago](https://wordpress.org/support/topic/upgrade-25-gt-27-avoiding-gotchas/#post-1040327) * Actually, yes, I was considering setting up the new blog in a different place to check and see how it worked. The problem is I have to use the packages from my hosting provider for this. * I didn’t know, in order to deal with wordpress, I was going to have to understand MySQL tables, but I guess that’s what I get for going with a hosting company that uses open source packages. * I tried the upgrade by doing as suggested — using a different location. The problem is now version 2.5, the one that worked, is no longer available on the control panel for the hosting company. I can copy files back, but then I’m using a program my hosting company considers unsupported. * So I guess several years of blogging is now screwed over. * If there’s some way to bring in all the DB stuff from 2.5.1 into the 2.7 blog, I’d appreciate it if someone who knows what I can do could help me on this! * Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) In reply to: [Upgrade: 2.5 -> 2.7, Avoiding Gotchas](https://wordpress.org/support/topic/upgrade-25-gt-27-avoiding-gotchas/) * Thread Starter [halninethousand](https://wordpress.org/support/users/halninethousand/) * (@halninethousand) * [17 years, 1 month ago](https://wordpress.org/support/topic/upgrade-25-gt-27-avoiding-gotchas/#post-1040260) * Okay, is it that nobody here really knows this, or is there a better place for me to ask for help on this? * Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) In reply to: [Upgrading a 2.0 Database to 2.5](https://wordpress.org/support/topic/upgrading-a-20-database-to-25/) * Thread Starter [halninethousand](https://wordpress.org/support/users/halninethousand/) * (@halninethousand) * [17 years, 10 months ago](https://wordpress.org/support/topic/upgrading-a-20-database-to-25/#post-796630) * The web site I’m on uses a different control panel, not CPanel (isn’t that what phpMyAdmin is part of), so I don’t have that as a choice. * Thanks, though. Except for an issue with uploading pictures, it’s working now.( I posted that on a new thread.) * Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) In reply to: [Upgrading a 2.0 Database to 2.5](https://wordpress.org/support/topic/upgrading-a-20-database-to-25/) * Thread Starter [halninethousand](https://wordpress.org/support/users/halninethousand/) * (@halninethousand) * [17 years, 10 months ago](https://wordpress.org/support/topic/upgrading-a-20-database-to-25/#post-796592) * Fixed. * I didn’t want to restore and retry without getting any info on what went wrong, but I tried the command that caused the error on the backup db and it worked, so I figured (hoped) it was a glitch. I restored and retried and it worked fine. * Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) In reply to: [Upgrading a 2.0 Database to 2.5](https://wordpress.org/support/topic/upgrading-a-20-database-to-25/) * Thread Starter [halninethousand](https://wordpress.org/support/users/halninethousand/) * (@halninethousand) * [17 years, 10 months ago](https://wordpress.org/support/topic/upgrading-a-20-database-to-25/#post-796588) * Okay, found the url. Tried it and got this: * WordPress database error: [Got error 127 from storage engine] SELECT * FROM hb_categories ORDER BY cat_ID * So I checked. The posts are there. The comments are gone and categories are gone. I can still restore the DB so if there’s something else I can do, it’d be a big help. * Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) In reply to: [Upgrading a 2.0 Database to 2.5](https://wordpress.org/support/topic/upgrading-a-20-database-to-25/) * Thread Starter [halninethousand](https://wordpress.org/support/users/halninethousand/) * (@halninethousand) * [17 years, 10 months ago](https://wordpress.org/support/topic/upgrading-a-20-database-to-25/#post-796585) * Where is the upgrade.php file? I ran one upgrade and got, “Upgrade not needed.” * Thanks! Viewing 9 replies - 1 through 9 (of 9 total)