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

learn more… | top users | synonyms

2
votes
2answers
3k views

Save custom post type in different table

I need to store custom post type post data into a custom table, not in wp_posts and wp_postmeta. Is it possible? anyone help please. Actually, I have created two custom post type named "truck" and ...
2
votes
1answer
3k views

How to update BuddyPress xprofile fields programmatically? [closed]

I update user info using wp_update_user function. I also need to update the table wp_bp_xprofile_data. Is there any function, where I can update data on wp_bp_xprofile_data table?
2
votes
2answers
13k views

Using Dynamic Data Pulled from a MySQL Table in a WordPress Page

I'd like to pull data from a mySQL database and put it in some tables in a WP page. I'm using WP 3.1.1. Imagine that I've got a table of sales figures that I want to pull from a mySQL database and ...
2
votes
2answers
2k views

Should I global $wpdb outside of any of my plugin's functions scope?

I know that the general advice to global variables is to not use them at all. Still, when doing something with the Wordpress database, it is required to do global $wpdb; to access the methods ...
2
votes
2answers
3k views

Theme Activation, Create Database Tables

I have been tasked with creating a theme that will be a base to list the site owners ebay store products. I have fleshed most of the project out in plain old php to get everything working as regards ...
2
votes
4answers
5k views

Converting WordPress into Android or iPhone app

I've had a request from my client to convert their WordPress website into an App for Android and iPhone. I've looked around at a number of options and it seems doable especially for just the blog ...
2
votes
2answers
428 views

Efficiency on displaying random authors based on large database

I'm trying to display a list of 5 authors randomly. Here are some solutions I had found: http://stackoverflow.com/questions/5502609/get-authors-randomly ...
2
votes
2answers
12k views

Simple form that saves to database

I am using a 3rd party service that does a scrub of my database for new entries within a specific table. However I am been unable to find a simple form plugin that submits data to the wordpress ...
2
votes
1answer
68 views

prefix table and plugins

I changed my prefix of my tables from the wp_ to something else for security reasons and good practice etc. I was curious most of new plugins installed take on the new prefix but I have one that ...
2
votes
1answer
277 views

What are these entries in the database? Looks similar to JSON

So I have been wondering for a while now what these entries are and what they do, also what the format of them are. They look similar to JSON but are definitely not JSON. ...
2
votes
2answers
82 views

WordPress Backup

I'm learning how to backup right now and I'd like some validation. From what I understood, to fully backup my Wordpress I need two things. One backup for my database and another for theme files. The ...
2
votes
3answers
4k views

Login in Wordpress using external database data

I have a WP site and also have a external DB (means not WP DB) with users. The insertion process at that table uses the same algorithm as WP uses. What I'm need to do here is login in WP but using ...
2
votes
1answer
6k views

Connect forms in WP to external database

I want to use Wordpress for an existing site (coded in PHP). It has some forms (for member subscription, user can update their data etc.) which are connected directly to an existing database. I don't ...
2
votes
2answers
537 views

What's the most efficient database method to add and query usermeta?

What's the most efficient way - concerning the database - to add and query extra usermeta fields to a profile? I need to add four additional fields of numeric and text data to a user profile and then ...
2
votes
1answer
4k views

How to close wpdb connection?

Is there any method to close connection similar to mysql_close() for wpdb in wordpress? Is it not necessary to close connection for global wpdb?
2
votes
2answers
2k views

Updating Wordpress - the best approach (updating wp core, plugins and db)

What is the best approach (steps) to update Wordpress when I have to update all of the following: wp core plugins database I came across this post http://codex.wordpress.org/Updating_WordPress ...
2
votes
1answer
199 views

Taking WordPress table prefixes into account

Given the code below how would I account for the table prefix that can change from installation to installation? Is there a better way to write it than an SQL query? Is there a variable I've missed ...
2
votes
1answer
34 views

What are conventions about the schema of the $table_prefix

I wonder if there are any conventions or best practices about the table prefix of any WordPress set up. The official documentation on wordpress.org does not make any statements to that topic. ...
2
votes
1answer
499 views

Best way to move live site local

I'm trying to move a big site that's currently live onto my local machine so I can edit locally. I'm using Wamp Server. I've tried using the Duplicator plugin but I'm getting several warnings and ...
2
votes
1answer
54 views

Text snippets shared across posts

I'd like to add a "fast facts" section to a wordpress site - an area in the sidebar where snippets of text are rotated. Where is the best place to store things like this? Widgets don't really allow ...
2
votes
1answer
140 views

Why does WordPress rely on an fully qualified site_url with a 15-step plan for moving a site?

From the Moving WordPress codex page (emphasis mine): When your domain name or URLs change there are additional concerns. The files and database can be moved, however references to the old ...
2
votes
2answers
827 views

Using Disqus, how to stop storing comments in wp database?

I'm using disqus comments system, but it keeps storing the comments in the wordpress database as well. Is there way to disable option to store comments in wordpress database because I don't see any ...
2
votes
2answers
4k views

Edit Custom Database Tables in Wordpress

I have a site that uses custom database tables to manage info that is inserted by a process completely independent from Wordpress. The data from the table is used in the Wordpress site but it is not ...
2
votes
3answers
2k views

Import 10,000 Users into Wordpress WITH a specific ID for each user

I have a website which has about 10,000 users. I am converting this site over to Wordpress. The new site is ready to roll, but I have to bring over all the users. There are a number of plugins ...
2
votes
2answers
123 views

The revisions table in my database is at 70% capacity and growing. What should I do?

I installed the Wordpress System Health Plugin and it says that the revisions table in my database is at 70% capacity with 994 rows. I don't fully understand what this means. I anticipate that my ...
2
votes
2answers
216 views

How to diagnose and keep in check encoding issues?

What we have for a project is: multiple sites (production, test, local development); migrated by multiple methods (PHPMyAdmin, Navicat, BackupBuddy); And the issue we are having is that while ...
2
votes
1answer
210 views

WP database error for comments_popup_link()

I'm using the comments_popup_link() function to show the number of comments for each post in a loop. <?php if (have_posts()) : while (have_posts()) : the_post(); ?> <?php if ( ...
2
votes
1answer
799 views

Advice needed for importing custom field data and database structure

Looking for advice for the best method to accomplish the following. I have a custom page template with several custom fields/taxonomy. The data needed for these custom fields actually resides in ...
2
votes
1answer
548 views

Corrupt Wordpress Database

The weirdest Wordpress problem ever I think. A clients site with a large database of posts has got a mind of it's own. One minute everything seems fine, the next posts, categories and tags are ...
2
votes
1answer
319 views

What's the database relationship between a post and its attachments

I'm creating a custom import script to migrate CSV data into wordpress. Each post has a series of attachments that must come with it. Following chapter 14 (importing via a custom mysql script) in the ...
2
votes
2answers
1k views

Where is the old post permalink slug stored?

I published an article with permalink slug: http://domain.com/writing Then after publishing, I changed the permalink slug to writing-lorem. Now, whenever I visit /writing, it redirects to ...
2
votes
1answer
1k views

Can I use MariaDB instead of MySQL in wordpress?

Is it possible to use MariaDB instead of MySQL in Wordpress installation? If possible: how do I do that? Is there any drawback or complexities?
2
votes
1answer
312 views

Exporting Data from WordPress into a flat table

I need to be able to export the data within WordPress so that each object is contained in a single row, like a flat table. Imagine each post type as it's own database table, containing columns that ...
2
votes
1answer
2k views

Database sync between local and production

I was watching Mark Jaquith's presentation at WCSF 2013 recently and in the Q&A Mark mentioned something about rsync - after a quick Google I can see this is done via SSH - my question is this: is ...
2
votes
1answer
129 views

Filter WordPress posts by between parameter

How to filter WordPress posts by a taxonomy and between parameter? Consider a mobile website with "memory size" taxonomy, I need to show posts that have more than 256 mb memory and less than 768 mb. ...
2
votes
1answer
2k views

How to increase the character limit for post name of 200?

I have post name in Thai which uses UTF-8 character. Many of them encode into super long in ASCII e.g. วิธีการหลีกเลี่ยงข้อผิดพลาดทั้ง-8-ในชีวิตการแต่งงาน I've changed the type of "post_name" using ...
2
votes
2answers
857 views

The plugin generated x characters of unexpected output, $wpdb not defined

I've written a simple Wordpress plugin to create a new database table. The new table ought to be created when the plugin is activated. When I try to activate the plugin, I get the following error: ...
2
votes
2answers
264 views

Relationship between performance and database size

What's the relationship between performance and database size in WordPress? Does a bigger DB mean that my site will be slower? My DB size is currently 360mb. I also noticed that I have some tables ...
2
votes
2answers
195 views

Wordpress DB: options-table –> 32 gzipcompression?

I just wondered what this row in the Wordpress Database refers to? 32 gzipcompression 0 I stumbled upon it in the WP options table. What if I set the value to 1. I do already have ...
2
votes
2answers
2k views

WordPress Database Charset/Collate

Is there an easy way of getting the charset and collation of the DB tables in WordPress without resorting to SQL queries?
2
votes
1answer
1k views

How to use custom post type APIs, but use a different db table

We currently have a plugin that creates a new WP table, but it recreates the wheel when it comes to managing/updating data. It would be a good candidate for custom post types, but we don't want to ...
2
votes
2answers
442 views

Database slowdown after update to 3.4.1

I own a wordpress installation, and Updated to 3.4.1. After the upgrade, I got a very strange slowdown to my wordpress. After all, I used the define('SAVEQUERIES', true); in my wp-config.php with ...
2
votes
1answer
358 views

Is there a naming convention for database tables created by a plugin?

I have setup my plugin's table to use $wpdb->prefix but aside from that are there any conventions that you should name them; Maybe $wpdb->prefix.'plugin_'.$tablename or something. I can't find ...
2
votes
1answer
2k views

Split WP install between 2 databases?

Is it possible for Wordpress to work from two databases? The reason I ask is that we're approaching our 100mb limit for database size on our host (1and1) but have up to 100 databases, so what I was ...
2
votes
1answer
663 views

if statement on database query

Part of a voting script I'm working on: I'm checking a custom table in my WP database to see if a user already voted for a post by checking the IP address and the post id. If the user's IP already ...
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 ...
2
votes
1answer
23 views

When and why should I use $wpdb different return types?

This one returns an object $mylink = $wpdb->get_row("SELECT * FROM $wpdb->links WHERE link_id = 10"); An associative array $mylink = $wpdb->get_row("SELECT * FROM $wpdb->links WHERE ...
2
votes
1answer
37 views

WordPress and automated MySQL backups to a different host

I'm having the following setup. A development computer in my local network and a production server with a real internet domain. Developing the PHP/CSS files on my dev computer for my theme is handled ...
2
votes
2answers
152 views

Shared table across network

Im currently creating a plugin that will read an xml file and import the data into 4 tables on a wordpress multisite. the tables are rather large, with ALOT of columns, so the post table is not ...
2
votes
1answer
912 views

Retrieve featured image (thumbnail) url from multiple posts with one query

I have a list of post ids and need to get all the standard data plus the thumbnail of the posts. As there will be several hundred posts i need an efficient way to retrieve the data, just looping over ...