View Full Version : WP3 DB Fields for Socrates
07-05-2010, 11:58 PM
I run a lot of blogs with geo location as part of the keywords strategy. However, this means the I create a blog for each state or for dozens of cities. The easiest thing would be to copy the relevant WP3 DB fields for Socrates from one install to the next. (And preferably the DB fields for the widgets as well.)
What are the relelvant tables and fields? (I'm somewhat familiar with the WP 2.9 DB but I haven't studied the WP 3 DB. I expect most of the relevant fields will be in the wp_options table.)
07-28-2010, 03:08 PM
Did you figure this out? Looks like no one responded, probably because the answer is a bit complex
07-29-2010, 08:16 AM
I guess you could set up your first blog with all the theme and plugin customizations then simply clone the complete blog to a new install.
All you would need to do then is to change the geo location for each install.
The only tool that I know that clones blogs quickly is Mike Filsaime's WP-Cloner (http://csgl.net/wp_cloner/)
I heard some good reports of how easy this tool makes it, and as with most of Mike's products it should work without any problems.
09-09-2010, 12:02 AM
The DB fields aren't complicated as far as I can tell but it did take a long time to figure them out.
Clearly the obvious solution is to copy everything and then just change the geo location. However, if I ever want to do anything with just hte header and not copy the whole DB then I really need the Socrates specific DB fields.
As far as I can tell all of the fields are in the _options table. The option_names are:
I may have missed one or two but this is the list I could find. Altering them is different matter. The way many of them are stored (and many other standard WP DB options are stored) takes a little time to decipher.
Powered by vBulletin® Version 4.1.10 Copyright © 2013 vBulletin Solutions, Inc. All rights reserved.