WordPress stores user generated content, along with other configurable information, in a a database (typically MySQL).

learn more… | top users | synonyms

2
votes
2answers
321 views

Is a direct or import approach safer for migration into WordPress?

We're in the process of migrating a site from an existing CMS system into WordPress. The existing CMS system has no direct integration tools with WordPress. I'm looking into the option of creating ...
1
vote
1answer
179 views

Routine to convert custom post meta from old to new value

I have two custom post meta objects that have been applied to all pages and posts in my sites. The names are MyCustomHeader and MyCustomTitle and I have one of these assigned to each post and page in ...
1
vote
1answer
103 views

WP Northwind for Theme Development?

Is there any tool online that can quickly populate a WordPress3 database with faux information to assist in theme development? Perhaps creating 8 categories, inserting a dozen or so posts into each, ...
24
votes
4answers
10k views

Database synchronization between dev/staging and production

I have a problem with WP database synchronization between development and production and I am wondering how other people solving it. I am aware about this question but it doesn't really cover the ...
4
votes
6answers
466 views

How can I migrate from another platform to WordPress (using the same domain) and launch when ready?

Currently, I have a blog that runs atop Tumblr, which is relatively young (3 months old or so, maybe 25 posts altogehter) that I want to migrate to a self-hosted Wordpress installation. I've installed ...
44
votes
6answers
46k views

Using wpdb to connect to a separate database

I want to connect wpdb to another database. How do I create the instance and pass it the database name/username/password? Thanks
2
votes
1answer
317 views

What Is The Difference Between suppress_errors() And hide_errors() in $wpdb?

What is the difference between the suppress_errors() function and the hide_errors() functionin wpdb class? What is the use of each function?
4
votes
3answers
303 views

Is it possible to switch the data layer within WordPress?

WordPress is undoubtely very customizable using plugins, but every customization possibility surely has limits defined by the underlying architecture. For those familiar with WP architecture and ...
6
votes
6answers
573 views

Backup the Database and Restore from the Backup?

I am using WordPress 3 and would like to backup the database to my computer (a Mac). My webhost is using PHP safe mode, so that sometimes limits what plugins I can use. What is a good way to do a ...
7
votes
4answers
2k views

How can I delete orphan keys in WordPress database tables?

In particular in table wp_options. After almost 2 years of blog production it seems increased a lot, and I don't know how many crap is in there. Do you know a plugin that works with WordPress 3.0 or ...