Good methodology for upgrading a large/complex sites?

I don’t know of a great before and after comparitor that would get you the results you need. In fact I would be worried that any tool like that won’t catch any failures in functionality. Honestly I would suggest incrementally building up a testing suite that goes through some of your standard processes and verifies … Read more

What files to keep after upgrading WordPress?

Delete everything but wp-content and wp-config.php, copy the fresh installation into the directory. On upgrading WordPress will use the database to see what should be done, not the files. Not all files are deleted automatically, because some of them might still be used by outdated plugins or external scripts (the old feed files are good … Read more

Error upgrading from 2.9.2 to 3.0.1

I also used SVN before to update my wordpress installation. Up the working copied will get messed up very quickly with all the manual updates or files created by plugins. I would always recommend to use the update functionality of wordpress if you only want to step from one tagged version to another one. Although, … Read more

Which database table does “Featured images” save under?

The featured image itself– the actual .jpg, or .png, most likely– is saved to wp-content/uploads with primary image data saved to $wpdb->posts as an attachment post type. Additional relevant data for the image is saved in $wpdb->postmeta. What makes an image “featured” or not is an entry in $wpdb->postmeta under the key _thumbnail_id and a … Read more