Questions tagged [database]
WordPress stores user generated content, along with other configurable information, in a database (typically MySQL).
180
questions
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
- 2,798
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 ...
- 489
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 ...
- 12.8k
5
votes
1
answer
940
views
$wpdb->prepare() warning in WordPress 3.5
I am receiving this warning when I try to run a database query:
Warning: Missing argument 2 for wpdb::prepare()
The offending query is:
$result = $wpdb->get_var(
$wpdb->prepare(
...
- 619
7
votes
1
answer
1k
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.
a:1:{s:12:"jetlocations";a:...
- 173
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 ...
- 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 ...
- 2,505
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
...
- 423
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 ...
- 325
9
votes
6
answers
11k
views
Add Wordpress MU Network Admin via Database
I am working on getting a copy of a WordPress MU network up and running on my local machine for development purposes (using WordPress 3.2.1 at the moment). I need access to the network administration ...
- 151
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 ...
- 261
6
votes
3
answers
7k
views
Database connection close
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?
5
votes
1
answer
13k
views
wp_posts - guid update
Hello and please excuse if this has been answered before but we really need to make sure.
We have developed a website under a domain of ours and then moved it to the live site of the client. We have ...
- 51
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 ...
- 333
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?...
- 393
10
votes
5
answers
31k
views
Wordpress Database lost auto increment
After rolling back a Wordpress database to a backup version it seems that all the tables lost their auto_increment on the primary key columns. I read on another post this could be to do with InnoDB ...
- 101
0
votes
2
answers
5k
views
Multiple WP install with same users database
I am creating a e-commerce website. I am using woocommerce with some cool extensions I bought. I need to make 2 websites, but store the users database (purchases, subscription purchases, etc) as well ...
- 79
5
votes
1
answer
422
views
When is it appropriate to create a new table in the WordPress database?
For a client we'll need 29,000 terms (all the highschool's in the US) and each term needs 6 meta items (address, phone...). My initial thought was to store the term meta information as suggested in ...
- 2,581
3
votes
2
answers
2k
views
Shared Members between two different wordpress installations with different databases
I have two wordpress installations with same host with different folders. Each installation uses its own database. I mean, database are separated. I am not using one database for two wordpress ...
- 31
4
votes
2
answers
697
views
Organizing WP Pages based on old website database
I'm moving existing data involving paintings from an old host that didn't use WordPress to a new host that does.
With the old site, data was stored in a database so that each painting had its own ...
- 65
1
vote
1
answer
3k
views
Accessing two databases
I have two databases on my server, and wanted to know is there a way to access both databases from wordpress? My thought is adding the second set of credentials to the wp-config.php.
- 115
25
votes
3
answers
72k
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?
- 1,000
8
votes
1
answer
3k
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 ...
- 81
0
votes
2
answers
450
views
Multiple Domains and Subdomains Using Multisite Installation
I have the following domains/subdomains. They are all related to each other, yet they must be on different domains/subdomains
example.com
www.example.com (redirects to example.com)
sub1.example.com
...
- 2,014
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....
- 912
10
votes
2
answers
1k
views
Is there a plugin that will override the "Error establishing a database connection" message? [closed]
My provider's database server recently had some downtime and my site was displaying the classic "Error establishing a database connection" message for about an hour.
I knew what the problem was but ...
- 103
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 ...
- 410
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 ...
- 4,461
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 ...
- 2,564
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 ...
- 517
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 ...
- 9,439
6
votes
2
answers
9k
views
Displaying content from one WP site on separate WP site
I have two totally separate WP websites setup. Different domains, different databases. I manage both of them and they are both hosted on a dedicated server. I am trying to include some basic ...
- 1,677
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 ...
- 12.3k
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 ...
- 111
6
votes
1
answer
92k
views
Insert data in database using form
I am writing a simple plugin that create a table with name "newsletter" in database and provide a shortcode to put a registration form in pages.
the form contain "name" and "email".
i have problem ...
- 73
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 ...
- 5,475
3
votes
2
answers
17k
views
Connect to remote database using Localhost install
I will be designing and developing a website for a client but want to allow the client to add content while I am working on the design and development of the site so that it is pretty mich done by the ...
- 417
3
votes
1
answer
2k
views
Can I store my custom comment_type into wp_comments table?
I'm developing a system where a post can have multiple replies/feedbacks. As of now I's storing each of the comments as a serialized postmeta. But just today I figured out that I can use the existing ...
- 12.3k
2
votes
2
answers
598
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:
https://stackoverflow.com/questions/5502609/get-authors-randomly
https://wordpress.stackexchange.com/a/91326/...
- 1,405
1
vote
3
answers
4k
views
What is the fastest way to generate a unique id number when registering a user
I have a client who wants to register users and give them a unique ID number when they complete registration. (Kind of a member number sort of thing)
Can I just setup the WP member table to start id ...
- 282
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-...
- 8,589
9
votes
1
answer
714
views
comment_post_ID 0 (cannot remove from dashboard)
Ran across something a bit odd that I haven't seen before. A client has a pretty active blog and uses Akismet (paid) to protect against spam. At least once a day, they're reporting a spam comment that ...
- 1,883
5
votes
1
answer
437
views
Writing a plugin that notify my friends of new post that mentions(@) them
For example, I write a new post with content "Today I'm happy, because I finally met the girl that @David told me about bla blah..." Once the post is published, there should be an email notification ...
- 197
3
votes
2
answers
4k
views
Transient RSS feeds in wp_options not removed automatically?
I just noticed 55.000 entries(!) in my wp_options table. I had not been there for a while.
So I ran:
delete from `wp_options` where `option_name` like '_transient_timeout_rss%'
delete from `...
- 2,564
-1
votes
1
answer
88
views
Retrieving and Displaying Data From a Table
At the moment, I have created a code that retrieves data from the database and displays it. However, for some reason, I cannot see the files I want to retrieve on my page. My goal is that the data ...
- 111
2
votes
4
answers
1k
views
Long option names fail silently?
This was really driving me crazy. I was debugging some code with code-generated transient names and they were failing like crazy for no apparent reason.
After much much pain and experimentation I ...
- 97.7k
0
votes
1
answer
2k
views
Bulk Update of Custom Post Type Post Status through SQL
The following code updates the post status of standard wordpress posts to 'Archived'.
UPDATE wp_posts SET post_status = 'Archived' WHERE post_status != 'static';
How can I make this only affect ...
- 248
0
votes
1
answer
4k
views
save new data to wp_options non-post form
I have a form on my front-page. It sends the entered address to Google API and returns the JSON to wp_options. That works fine. I am using update_option to do that, so it rewrites the meta_key each ...
- 13
0
votes
2
answers
3k
views
Connecting to external oracle database
So I'm trying to connect to an external db in order to access/update information located on a different non-wordpress database (oracle).
I tried constructing a new wpdb object (as suggested by many ...
- 69
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 ...
- 19.6k