MySQL is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. MySQL is officially pronounced /maɪˌɛskjuːˈɛl/ ("My S-Q-L"), but is often pronounced /maɪˈsiːkwəl/ ("My Sequel"). It is named for original developer Michael Widenius's ...
0
votes
0answers
15 views
Is there a WordPress plugin GUI tool for creating an Atom feed for one of wp_{tables}?
Ideally I'd like to have something that either has Basic Auth capability or random URL keys creation. But any recommendations regardless of exact feature set?
0
votes
1answer
16 views
Query to delete all featured images and remove post meta?
I'd like to run an SQL query to find all featured images from posts and delete the file itself and any references to it.
Can anyone tell me how to accomplish this? Many thanks!
0
votes
5answers
42 views
Migration: Copying database content to a different server
I'm migrating our WordPress site from one server to another. I need some hint on how to deploy a database dump (which I have) from the original server to the new one. There is no phpmyadmin (at least ...
0
votes
1answer
36 views
Custom query with filters returns wrong number of found_posts [closed]
I have a custom query with a couple of filters, defined in functions.php:
function myJoin($join) {
global $wp_query, $wpdb;
$join = "
LEFT JOIN $wpdb->postmeta AS i ON (
...
0
votes
0answers
32 views
MySQL, Wordpress on alternate subdomains, hostname confusion
I have a MySQL server running on a virtual machine at vm.example.com. I have a Wordpress install (or pre-install) waiting at example.com/wp/blog.
Using the command-line mysql tools, I did the ...
0
votes
1answer
22 views
Sql edits overwritten when editing a page/post via the wp editor
When I move a site from staging to production, I run a little sql to replace urls within page content:
update wp_posts set post_content = replace(post_content, '#stagingaddress#', ...
0
votes
1answer
9 views
Need a MySQL query to delete duplicate comments [migrated]
My wordpress site was recently hacked so I had to reinstall everything. Wordpress resinstalled, database backups imported, everything fine and dandy. Then I installed the Disqus plugin and synced ...
0
votes
2answers
49 views
Mysql query LIKE not working
I'm using this code.
$blog_list = $wpdb->get_results( "SELECT " . $extra . "blog_id, last_updated FROM " . $wpdb->blogs. " WHERE public = '1' AND archived = '0' AND mature = '0' AND spam = '0' ...
0
votes
2answers
134 views
Cannot Upload Custom Header Image into Wordpress Dashboard
I'm having trouble uploading a custom image into Wordpress' dashboard. It says that it needs to be a custom 1000x288 image. When I upload it, I get the error of:
Warning: ...
0
votes
0answers
30 views
Warning: get_object_vars() when using wp_update_user
All of a sudden I'm getting this error when trying to add a WP user with the following code:
$new_user = wp_update_user( array(
'user_pass' => $user_pass,
'user_login' => $user_login,
...
0
votes
1answer
60 views
Importing Wordpress Posts With Custom Meta Data As CSV Files Through PHPMyAdmin
I have been importing data records as posts with custom meta data directly into Wordpress via the CSV Importer plugin. It works okay, however, there are some issues with it.
Issues:
1) It takes ...
0
votes
1answer
38 views
Cloning blog to localhost via WAMP
How do restore a Wordpress blog (actually, cloning would be the right word) from my server to localhost with WAMP?
I backed up my blog with BackUpWordPress and got a .zip file ...
0
votes
1answer
22 views
Within the database, where is the flag which says that a user has Super Admin rights?
I have an user in a Wordpress Multisite installation and have access to the Mysql database, I would like to give myself super-admin rights to access the wp-admin/network page. Where can I do it on ...
3
votes
1answer
71 views
Set page template for all pages?
I know the page template is set in the wpdb as meta_key = _wp_page_template and meta_value = template.php.
How can I write a SQL script to set each post where post_type = 'page' to a specific ...
0
votes
1answer
42 views
being redirected to install.php (“WordPress is already installed”) when including file with SQL functions in class
I'm working on a project with WP, a bit like a plugin, but not quite one.
I'm encountering an issue, when trying to include a file that contains some custom SQL functions in a class, in a completely ...
