Questions tagged [database]

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

Filter by
Sorted by
Tagged with
105 votes
6 answers
155k 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
user avatar
  • 2,798
61 votes
5 answers
74k views

MySQL Database User: Which Privileges are needed?

The short installation instruction for WordPress ("5 Minutes") state that: Create a database for WordPress on your web server, as well as a MySQL user who has all privileges for accessing and ...
user avatar
  • 12.8k
48 votes
5 answers
38k views

Why is my database import losing text widget data?

I've created a site in WordPress on our development machine. In the theme we're using there are numerous widget zones to display text in (sidebar and front page). I've used simple Text widgets in all ...
user avatar
  • 1,551
45 votes
1 answer
11k views

Should I use custom post types or a custom database tables for plugin development?

I'm fairly new to writing wordpress plugins, but I've jumped in the deep end already and I want to make sure I'm doing it "right" on my upcoming big project. I'm going to be heavily extending ...
user avatar
  • 2,505
41 votes
6 answers
117k views

After server migration only the homepage works

I have recently changed hosting of my WordPress site to VPS.net. I have moved all of my files and imported the database. Everything appeared to be fine until I clicked a link and noticed that all of ...
user avatar
37 votes
4 answers
15k views

Database synchronization between dev/staging and production

I have a problem with WordPress 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 ...
user avatar
  • 489
36 votes
4 answers
15k views

Keeping WP database synced across multiple developers using git

I'm working on improving my git workflow as it applies to my WordPress development projects. Often, when developing a content management system, I'll create a development server (like http://dev....
user avatar
34 votes
1 answer
12k views

When is the 'post_content_filtered' column in database cleared by WordPress?

Some WordPress plugins (although very few) use the post_content_filtered column in database to save some data related to a post. For example, Markdown on Save stores the markdown version of a post ...
user avatar
  • 4,461
32 votes
5 answers
27k views

Post meta vs separate database tables

When developing plugins that requires data storage, what's the pros and cons of using one method or another ? The explanation given in the codex is not detailed: Before jumping in with a whole new ...
user avatar
31 votes
4 answers
63k views

WPDB Insert or if exists Update

I'm not crazy familiar with WPDB or SQL in general but I have a custom table for my project and I'm trying to assign some metadata to it. What I'd "like" to happen is if a row exists, update it and if ...
user avatar
  • 19.6k
29 votes
1 answer
76k 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 category?...
user avatar
29 votes
3 answers
11k views

Multiple developers / editors working on a site in progress

Background I'm nearing the final stages of constructing my first fairly large WordPress site, and I'm now encountering some friction. For the most part, the site was developed on my local machine and ...
user avatar
25 votes
5 answers
34k views

Where are wordpress custom types stored?

Where are custom types stored? Because when a custom type is created, in wp_posts, the post type is set to the <new_custom_post_type>. But where are the details of the new custom post type ...
user avatar
  • 427
25 votes
3 answers
73k views

where is permalink info stored in database?

I see that I can edit permalink information in wp-admin page > settings > permalinks. However, where is that information actually stored in the database?
user avatar
22 votes
1 answer
61k views

Wordpress default menu in database

There are 3 menus in my wordpress(3.5) now. Main menu (default from wp) Footer menu (default from wp) Test menu Now I have kept test menu as default. Where does Wordpress store this thing? I want ...
user avatar
22 votes
3 answers
66k views

How do I show data from gravity forms in my template? [closed]

Preface I've installed gravity forms, created a form and users are submitting data to my site. What I want to do is show the data users are submitting to my site on one of my pages. I know there's the ...
user avatar
22 votes
2 answers
108k views

How to return number of found rows from SELECT query

I wrote a function which is supposed to return the number of rows found in a SELECT query but it always either seems to return 0 or an array. I have been messing around with this for about an hour now ...
user avatar
  • 1,254
21 votes
1 answer
2k views

How can I make updates to a site, on a development copy, but then move updates back without overriding live site's evolving database?

I've tried to be as descriptive in the title as possible, and I know this question has been asked in before in various forms but I could not find good answer to it and it's are to imagine that no one ...
user avatar
  • 311
20 votes
2 answers
29k views

Is it mandatory to use $wpdb->prefix in custom tables

Sorry if this question is trivial. I'm just beginning to develop plugins in WordPress. In all the tutorials I found this: while creating the custom tables, $wpdb->prefix is used. Example: $...
user avatar
  • 215
19 votes
3 answers
1k views

How can I trust switch_to_blog()?

When I call switch_to_blog() with a blog id, I don’t know whether that blog actually exists. The function returns always true. Test case: switch_to_blog(PHP_INT_MAX); $post = get_post(1); ...
user avatar
  • 105k
18 votes
4 answers
145k views

get_results using wpdb

I'm trying to retrieve information on my database. I wanted to display all pages using this statement, but I'm getting a blank ARRAY global $wpdb; $result = $wpdb->get_results ( " ...
user avatar
17 votes
7 answers
30k views

Checking if Database Table exists

I read the wordpress codex and professional wordpress. It seems both use something like if($wpdb->get_var("SHOW TABLES LIKE '$table_name'") != $table_name) { to determine if the table exists. Is ...
user avatar
  • 2,233
17 votes
6 answers
72k views

Will it break my site if I delete all transient records in wp_options table?

My site currently has an outrageous 500k+ transient records in the wp_options table. This causes the table to be crashed frequently and so be my site. I thought transient records will all expired ...
user avatar
  • 410
16 votes
3 answers
8k views

Why WordPress choose data serialization over json_encode?

In my little age with WordPress, I've seen WordPress itself and its friendly plugins are using PHP serialize() in storing data into db in many cases. But in a recent search I found a serious community ...
user avatar
16 votes
5 answers
34k views

Can posts have parents?

Are posts supposed to have parents? If so, what would that mean for a post to have a parent? Also, if there are some constraints to posts having parents, then where is that enforced? Not in the DB as ...
user avatar
15 votes
3 answers
34k views

Delete all posts of a custom post type—efficiently

I'm looking for a safe and fast way to delete all of one custom post type's posts. Using get_posts() and wp_delete_post() for each returned post does not work; it's not fast enough due to the sheer ...
user avatar
15 votes
1 answer
21k views

Update Option Stored in Multi-Dimensional Array

I have data in the wp_options table currently stored as a multi-dimensional array (profile_element_order): a:12:{s:17:"img_base64_enable";s:1:"1";s:25:"moulding_combination_page";s:0:"";s:24:"...
user avatar
  • 1,883
15 votes
6 answers
43k views

Delete tables from database when deleting plugin

I created a plugin and want to add a function to delete my tables from the database when a user deletes my plugin. I created a function that deletes tables from the DB when a user deactivates my ...
user avatar
  • 153
15 votes
1 answer
7k views

Performance with autoload and the options table

I am playing around with the autoload column of the options table. I didn't find much information about how the autoloaded values are used. I tried a print_r($GLOBALS) and saw that the autoloaded ...
user avatar
  • 5,475
15 votes
7 answers
319 views

What's the simplest way to backup my WordPress database?

I have WordPress installed on my server for my blog. I back up all the files from the server on a schedule. But this is just the files--not the database. Ideally, I'd like to automatically save a ...
user avatar
14 votes
4 answers
3k views

Ignoring initial articles (like 'a', 'an' or 'the') when sorting queries?

I'm currently trying to output a list of music titles and would like to have the sorting ignore (but still display) the initial article of the title. For example if I had a list of bands it will be ...
user avatar
  • 325
14 votes
2 answers
13k views

WordPress (MyISAM) database is slow, should I switch to InnoDB?

I have a WordPress site with well over 10k posts, and things are starting to get very slow whenever I am adding and editing posts. Pages load nice and fast for users, along with the admin lists of ...
user avatar
14 votes
3 answers
15k views

$wpdb won't insert NULL into table column

When i try something like this $status = NULL; $wpdb->update( 'table', array( 'status' => $status, ), array( 'id' =>...
user avatar
14 votes
3 answers
871 views

Performance of my permalink structure?

I have read the discussion on the performance of different permalinks on the wp hackers mailinglist, THIS forum and around Google. I could however not really deduce if the permalink structure I have ...
user avatar
  • 2,564
14 votes
3 answers
2k views

Relaunch 4.2 utf8mb4 database upgrade

I updated WP to 4.2 while it was on an old server, that doesn't match the utf8mb4 upgrade requirements. I moved to another server that fit these requirements, but WP won't launch this database ...
user avatar
  • 243
14 votes
1 answer
2k views

Fastest way (least amount of steps) to locally import a remote database using WP-CLI

I'd like to automate the task of importing a remote database using the WP-CLI. The current process is to ssh to the server, and run an export to file using WP-CLI, copy the file to a local directory ...
user avatar
  • 9,439
13 votes
3 answers
10k views

Safest way to bulk delete post revisions

One of my clients is on a rather large blog in terms of number of posts and traffic. I'm trying to get her database down to a manageable size, and one thing that's bulking up is literally tens of ...
user avatar
  • 362
13 votes
1 answer
12k views

Please explain how Wordpress works with MySQL character set and collation at a low level

As the question title suggests, I'm looking to understand how Wordpress works with MySQL character sets and collation options. As I will show below, things don't make much sense to me... I installed ...
user avatar
  • 233
12 votes
4 answers
24k views

DB connection error after copying a WordPress Multisite instance to a second location

Here's my setup. I have a Multisite instance running at http://example.com, and I want to do development and staging. Moving an existing Multisite instance of WP onto localhost is a nightmare, so I'm ...
user avatar
12 votes
2 answers
9k views

Solution for database version control and deployment?

Currently i use a dump script and commit the database to the git repo. --skip-extended-insert --skip-comments --skip-dump-date means that a diff can give me a fair idea of what has changed, but it ...
user avatar
12 votes
2 answers
5k views

The MySQL alternatives: Do Percona Server and MariaDB work well with WordPress, and do they make WordPress go better?

Lately I've been reading about MariaDB and Percona Server, two strong alternatives to MySQL that have gained popularity since Oracle bought Sun. As far as I know, both of them could be used with ...
user avatar
  • 495
11 votes
5 answers
34k views

How many users can WordPress handle?

I want to design a member login site in WP but I have a doubt that is WordPress can handle more than 40000 users on same database? I am not sure about this so I am stooping my work here. So please ...
user avatar
  • 111
11 votes
1 answer
13k views

wpdb update add current timestamp not working

So using the $wpdb->update to add some data to a custom table, trying to add the current timestamp but it's not saving the right stuff(0000-00-00 00:00:00 this is saved). overview code $wpdb->...
user avatar
11 votes
5 answers
4k views

Is it bad practice to create own table for a plugin?

If I want to save settings for my plugin then it is pretty easy and straight forward. Now I would like to save to the database a bit more. A file name, and 3 other values that only apply to that ...
user avatar
  • 279
11 votes
2 answers
20k views

Get error messages when $wpdb->insert() returns false?

$wpdb->insert() returns false which I've learned means that the insert failed. Now, I would like to know why it fails with the insert. According to this ticket https://core.trac.wordpress.org/...
user avatar
11 votes
7 answers
24k views

Site stuck in "Database Update Required" loop

I just updated to 3.1.3 and now when I go to the admin I get the "Database Update Required" /wp-admin/upgrade.php screen. I click 'Upgrade Now' and it says it's done, but then trying to access ...
user avatar
11 votes
2 answers
4k views

How to Add an Index to Plugin Database table

I've created some additional tables for a plugin I'm developing and need to add indexes to these tables. What's the WordPress way to do this? Using dbDelta() doesn't seem to be working, and I'm ...
user avatar
  • 213
11 votes
3 answers
82k views

How to fetch Data in WordPress using MySQLi or $wpdb

I have custom table like this: useraw 1. id (Primary*) 2. user_ip 3. post_id 4. time I am inserting data in the table using $wpdb->insert($table_name , array('user_ip' => $user_ip, 'post_id'...
user avatar
11 votes
2 answers
9k 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 /writing-...
user avatar
  • 8,589
11 votes
2 answers
14k views

Detecting errors generated by $wpdb->get_results()

How do I detect errors when using $wpdb->get_results()? For example: $result = $wpdb->get_results("SELECT * FROM this is not a valid query"); The preceding code doesn't generate any exceptions ...
user avatar
  • 1,381

1
2 3 4 5
50