I tried the following phpMyAdmin query to merge my category 112747 into my category 112748: UPDATE `wp_term_relationships` SET `term_taxonomy_id` = 112747 WHERE `term_taxonomy_id` = 112748; It did not work. What errors does the query contain? wordpress 3.8.2 phpMyAdmin 4.18 MySQL 5.5.34-cll-lve A wordpress website of mine has nearly 300,000 posts, with most categories containing, at … Read more
I need to change several hundred posts with custom post types to regular post type but only from one category within that custom post type. So I have a custom post type ‘films’ and within that post type I have a couple dozen categories. What I would like to do is change all posts from … Read more
I’m trying to change all the users Display Names to be their first and last name. I have looked into a number of plugins and wrote my own PHP to try and accomplish this however the site has over 50,000 registered users (I can imagine most are spam from my clients previous site) but because … Read more
I’m fairly new to WordPress and I’m a little confuse on how to take the database from my local server and replace it with the one on the server on a WordPress multisite. I’ve replace database before from local to server, but it was a multisite. The step I usually take is: backup the database … Read more
How do I change the MySQL root password and username in ubuntu server? Do I need to stop the mysql service before setting any changes? I have a phpmyadmin setup as well, will phpmyadmin get updated automatically? 35 Answers 35 Set / change / reset the MySQL root password on Ubuntu Linux. Enter the following … Read more
So I have added myself as an admin via following the instructions on this site: http://www.wpbeginner.com/wp-tutorials/how-to-add-an-admin-user-to-the-wordpress-database-via-mysql/ I have done this before and it has worked. When I go into the dashboard and add the creds as I inputted them via phpMyAdmin according to the steps in the URL above, I get an error message saying … Read more
I have a remote (website) version of a wordpress site and it’s got more recent information than my local (computer) version. I would like to move the data over to my local using phpMyAdmin, what is the best way to go about this? Should I just export the entire database, import it and re-link my … Read more
I performed a MySQL dump of my WordPress production database to be imported into my local development environment. I plan on frequently performing this database dump and import. Is it possible for me to AVOID running a search & replace script or a MySQL query that updates all of the permalinks, site URLs, etc? Could … Read more
I have a wordpress ecommerce website which I have begun to update after not touching it for over a year. The first thing I did was implement reCaptcha into all inquiry and contact forms to reduce the amount of spam that is sent to my business’ inbox. I have also got it working for login … Read more
I followed this tutorial on setting up a local web development setup without mamp. Now my problem is when I go to upload a image in WordPress I get the following error: “Screen Shot 2013-01-05 at 10.51.42 PM.png” has failed to upload due to an error: Unable to create directory wp-content/uploads/2013/01. Is its parent directory … Read more