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

learn more… | top users | synonyms

1
vote
1answer
348 views

Multiple multisite instances connecting to the same database

I like the idea of making developers connect their copies to the same database and just set WP_HOME and WP_SITEURL to configure the domain name as they like it. In this model, we don't need to keep ...
0
votes
1answer
36 views

different theme in one website

Assume this is my site name : www.example.com. I saw different websites have different themes in a site. For example I want to have different themes for www.example.com and ...
5
votes
2answers
316 views

WordPress database scalability from the code perspective

I have read through multiple questions here on StackExchange that concern WordPress scaling and the common opinion is that WordPress is indeed highly scalable provided you have the infrastructure to ...
1
vote
1answer
402 views

Most recent post from another database

I am trying to add the most recent post from another Wordpress database (on the same server in all actuality), but am getting the following error: Fatal error: Call to undefined method ...
1
vote
1answer
196 views

Should a child theme share the same theme options row as the parent, or should it have it's own options row?

I'm developing a theme which uses the NHP Theme Options Framework to add some theme options. Naturally, the theme options framework creates a single row in the database to store the theme's options ...
0
votes
3answers
748 views

How to empty wordpress custom post Database table

I have around 2000 custom posts. And 7 regular wp pages. I want to delete all those custom post without effecting the pages. I thought the easiest way would be to empty the custom post table but I ...
0
votes
1answer
115 views

Fast worpress backup/clone

i have a problem with 2 websites. I have for example site1.com site2.com How can i make a perfect clone of site1.com for site2.com? i mean i want a method that i can do this in minutes, not ...
1
vote
2answers
410 views

when I fetch data from remote mysql database in wordpress built in wordpress function is not working?

In one of my page I have to fetch data from remote mysql database. We have connection to remote mysql database by creating new instance of $wpdb class. $mydb = new wpdb(DB_USER2, DB_PASSWORD2, ...
0
votes
2answers
232 views

Does post_meta data need to be unserialzed?

Is it possible to unserialize data in the mysql query at the run time? i don't want to use unserialize() function of php. I need to fetch the value "mathematics" from the below serialized value ...
0
votes
1answer
2k views

How To Find Out Wordpress Category Table in MYSQL?

I know WordPress stores all post data in 'wp_posts' table. But here WordPress not define any category id or reference related with it. Please let me know, how 'wp_posts' table find out exact ...
1
vote
2answers
404 views

How to create and work with custom data / tables (i.e., for arbitrary data)?

Getting started on Wordpress just today. I noticed that Wordpress created tables in a mySql database (with name *.wrdp1) when I first set it up. These tables cover comments, posts, users, and some ...
1
vote
2answers
2k views

How to use multiple database in wordpress?

I want to fetch some post from another wordpress site which is hosted in the same server. How can I fetch those post? Is multiple database connection is possible in wordpress?
1
vote
1answer
51 views

cross-site custom menu

i have a multisite whice i want to separate because its unneccery as two of my sites are on the same DATABASE and all i need is actually the dynamic custom menus which i have built in the main site(to ...
0
votes
1answer
104 views

why there are so many posts whoes post_type is revision? will these records waste too much database space?

from the following data we may know there are only 30 records which are meaningful, and there are 92 records of revision post_type which can not be shown on the blog. so will these records waste too ...
0
votes
1answer
37 views

why the posts queried from sql is more than those showed on the page?

i am using WordPress multisite, the issue i face is that the posts queried from sql is more than those showed on the page, the details is as follows: mysql> select count(*) from wp_137_posts where ...
3
votes
1answer
343 views

Showing content from another wordpress installation database in the page template loop?

I am just wondering if it is possible to show just the page content of another wordpress database on wordpress pages with the same pageID within the content loop in my page template. To be more ...
0
votes
1answer
232 views

Merge two databases: OLD SITE -> NEW SITE

I am working to a restyle of a website. I made DB dump from remote server and made local installation, then started to work on my local machine. While i've been working other post have been added to ...
5
votes
1answer
394 views

WP Multisite: load content from site X on site Y

I'm running a WP multisite-network on my professional website (http://mydomain.com). I'd like to play around with jQuery Mobile and deliver a different website and web experience to mobile users, so I ...
0
votes
2answers
2k views

Database migration issues - Error #1046 No database selected

i need to get my clients website online and have been able to figure everything out except of course the most crucial part which is the database upload. i can't figure out what i'm doing wrong since ...
3
votes
2answers
2k views

How to change option recently_edited?

WP recently_edited option can be very useful - it tracks last 5 files that you've made changes to. Only problem is - well, that's all, 5 files. What if I've been made numerous changes to Wordpress ...
0
votes
1answer
156 views

Creating and Using Tables in the Wordpress Database

I plan on having over 2,000 pages per subject on my WordPress website and since each subject will require custom page types I would like to create tables for each subject in the WordPress Database. ...
1
vote
0answers
82 views

Copy post to separate database with “add_action(…)”

I'm basically trying to have a copy of a post be sent to another database's table when it's published. I've gotten it to add a new row in the new table, with my own static arguments, but I'm not sure ...
1
vote
2answers
2k views

How do I copy a wordpress database?

I'm trying to migrate my wordpress site from an old host to a new host. The Wordpress Codex says "you can move by just copying your files and database." Copying the files is easy enough, but how do I ...
2
votes
1answer
59 views

How to log database changes during an upgrade?

I have Wordpress installed in a classical LAMP configuration. Is there any way to, in a protected environment (like staging), automatically log all database changes (i.e. drop indexes or alter tables) ...
0
votes
2answers
242 views

wordpress database restore - broken link

I've tried to play with db backup and restore but I am dealing with difficulties. This what I've done: I backed up database using cPanel option and got 8MB large SQL file. Afterwards I installed new ...
-1
votes
2answers
606 views

PHP Call to External Database

I am using the Sleek child theme from Studio Press and want to do a PHP call to this external database for it to display just like this link: http://www.escort332.org/tuskegeecadets.php . The Theme ...
1
vote
1answer
70 views

how to migrate wpmu from one host to the other?

this issus is different fromm How to migrate wordpress users from one blog to another since i am using WPMU, i have backup the database, and then import it to the other host, also i have changed the ...
-1
votes
1answer
38 views

Shortcode returning specific content of a post

I'm currently building a plugin to display specific part of post after accepting verification code. Can a shortcode return a part of a post? I mean: Bla bla bla [shortcode postID="100"] Special bla ...
2
votes
2answers
143 views

Is it possible to import a wordpress backup from a single site in to a multi-site configuration?

I have a local development server with WordPress installed (my desktop Linux Mint 12 box). I'd like to use multi-site WordPress to manage my different client projects through one install, but I have a ...
3
votes
2answers
721 views

WordPress use innodb by default?

I just created a new WordPress site in my server. Normally, WordPress uses MyISAM as the database type. But this time, it created all InnoDB tables! Is this normal? Has WordPress switched to InnoDB in ...
0
votes
1answer
366 views

Wordpress permalink from the database?

I am trying to access selected post information from my WordPress database to display on a second website which is not a WordPress site nor is it php, it is in fact an asp.net website that i want to ...
0
votes
1answer
269 views

Database Tables in Wordpress Theme

I am creating some sliders type functionality for my wordpress theme and I thought that creating two seperate db tables like 'sliders' and 'slider_images' is a good idea. My problem is that i don't ...
2
votes
1answer
786 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 ...
1
vote
2answers
720 views

how to transfer wordpress sql/database from local to live

So for backing up any/all my wordpress sites i use a tool called "BACKUP BUDDY" and its a great tool and all but lately its been really buggy and today finally it went kaboom! Usually my workflow is ...
5
votes
1answer
218 views

Should I use Transients with W3 Total Cache APC Caching? [closed]

Should I use Transients in my queries like this? <?php if ( ! $my_paged = absint( get_query_var( 'paged' ) ) ) $my_paged = 1; if ( ! $my_query = get_transient( "567recent_$my_paged" ) ) { ...
1
vote
1answer
525 views

Clean database from unused tables

I used to have many plugins installed on one of my sites, and after deleting most of them, I still have a database full of extra tables, I am sure most of them are unused. How do I clean them off?
1
vote
2answers
480 views

Form that sends data to an admin panel and can export it

Is there a way to have a form submit data to a admin control panel where the data is stored and can be rectified there? Could it also be able to export the data as excel for example?
0
votes
3answers
454 views

Migrated to Namecheap, now Trouble with Database & wp-config [closed]

I have been using a free web host while I set up my WP site. Now that it's all done I went and bought hosting from Namecheap. I uploaded the site and WordPress and everything seems to look fine, but ...
7
votes
2answers
502 views

How can I make a WordPress database portable and url independent?

Issue I am about to embark on some WordPress development in a multi person team environment. (3 or more people working on the same codebase at a time, each developing locally) With other CMSes we ...
1
vote
1answer
255 views

One post carries 30 postmeta values, is this too much?

I have some data saved as post meta, occasionally some plugins may save an extra piece. Now I installed bbpress, it saves at least 10 pieces of post meta. Adding them together, there are nearly 35 ...
1
vote
1answer
874 views

WPML tables not deleted when removing multisite subsite, need help clearing up my sql-file! [closed]

I´m building a WP Multisite for a client that wants a multilingual site. Before choosing WP Multisite, I bought and tried out WPML. However that plugin didn't fit for the job so I deleted it and got a ...
3
votes
2answers
1k views

Custom Post Type with Input fields to seperate table on database.

At the moment I'm using a custom post type called 'locations' I would like to be able to put input fields into the custom post type that would store the information such as ( address, type, phone ...
1
vote
2answers
514 views

Selecting all posts from the children of a particular parent taxonomy

I've created a custom post type (minerals) with a custom taxonomy (location) which supports hierarchies. What I am trying to do is create a return according to the parent location of the mineral post ...
0
votes
1answer
205 views

database not responding on localhost

I'm trying to work on an existing WordPress site on my Mac using MAMP. I've setup a new database using phpMyAdmin and imported the tables from the backup of the online version. I pasted this into ...
0
votes
2answers
301 views

Add custom php database code above <head>

I have a non plugin script that has it's own database and I want to use it with Wordpress. How can I add custom php code that connects to this separate database in my wordpress pages? It needs to go ...
1
vote
2answers
101 views

How to organise this data within WordPress

I have a dilemma in how the data in this scenario should be organised, as well as queried. The main elements in the scenario are the following: Competition Team Player Each player plays for one ...
0
votes
1answer
128 views

Trying to edit a WP site locally using MAMP

I'm new to WordPress. A friend asked me to redesign his WP blog and I've installed it on my Mac using MAMP. I went through the database setup and imported the site's existing DB and added the tables. ...
0
votes
1answer
270 views

How to create metabox that can be queried in the database?

So I've been working on created a catalog based off of wordpress's metabox functionality with a custom post type, but now as it comes time to start searching the database to return specific data sets, ...
3
votes
1answer
953 views

Default Wordpress settings API data sanitization

It looks to me that when saving data to the database via the settings API Wordpress sanitizes data by default. By that I mean that if I look at the raw settings options in the database they have (at ...
4
votes
1answer
340 views

find a random blogid across my multisite network that has at least one post published

I need to find a random blog across my multisite network that has at least one post published of a certain post_type, and return its blogid as a variable so I can use it in a switch_to_blog() call. I ...