A few months ago, I deleted a bulletin board that I had been using for various reasons. However, since the deleted posts were still being crawled, I thought they were not completely deleted, so I used the WP phpMyAdmin plugin to find the deleted post data and deleted them.
The reason I started using the plugin was because I tried to use the PuTTy program as a way to access phpMyAdmin , but I couldn’t access it due to permission issues. I referred to foreign communities and modified the permissions, but it still didn’t work.
So I looked to see if it was possible with a plugin and found the WP phpmyadmin plugin, which allowed me to access the data without much difficulty. Now, I will summarize the process of deleting old posts.
Table of Contents
WP phpMyAdmin
If you look at the plugin description, you can see that it keeps you secure and allows you to use the WordPress Dashboard without any additional hassle. There are a few other plugins, but most of them clean up the database, so you can’t just delete what you want.
There is one requirement for using this plugin, PHP version 7.1.3 is required. I was able to use it because I recently upgraded PHP while migrating the server.
How to use the plugin
After going to Add Plugins in the WordPress admin and searching for WP phpMyAdmin, you can find it as shown above, then install and activate it.
When you activate the plugin, you can see it in the administrator menu. If you go in, you will see a screen like the one above. If you click Enter phpMyAdmin, you can enter your database.
If it doesn’t work, try entering the URL shown in the blank description of phpMyAdmin on Hosting below.
phpMyAdmin Search and Delete
For those who are not familiar with it like me, it has a complex structure that can be confusing when you first enter it. And since it is where the WordPress database is managed, if you modify or delete it incorrectly, it may not work properly.
So, before modifying this, it is a good idea to make a backup . It is a good idea to make a backup in advance by using the function provided by the hosting or by using a backup plugin .
Then, assuming that you have a backup, let’s find out how to delete old posts. When you log in, you can find it directly on the left, but if you don’t know how, it’s difficult, so click on the top one and then click the Search button at the top.
The reason I click Bitnami_wordpress first is because I want to search the entire site.
When the search option appears, in my case, I was using Kboard and deleted the post, so I entered the plugin name %kboard%.
If you have entered a word to search for, you will see a small Go button at the bottom right. Clicking on it will search for the word you entered in the database.
A variety of search lists will appear, and if you look at wp_posts, you will be able to see that there are matches. Instead of clicking Delete to delete immediately, click Browse to open it and decide what to delete to avoid mistakes.
If you click the Browse button, you will see a list of various posts. Here, you can find old posts and click the Delete button to delete them. Then, you can say that they are completely deleted within WordPress.
However, if you are using the Yoast Seo plugin, the data is also stored in a place called WP_yoast_indexable, so you can check this and delete old post data.
In the meantime, I had been leaving it alone because I didn’t know how to completely delete it because it kept being crawled even after I deleted it and when I reinstalled the bulletin board, the post was searched. But recently, I found out about this plugin and was able to delete old posts.
If you are using a bulletin board plugin like me and it is still searchable after deleting it, please try to completely delete it using WP phpMyAdmin. I emphasize once again that you should definitely make a backup before doing any work.
▶ How to add a WordPress WP CACHE definition
▶ Post Deleted? 3 Things You Might Be Wondering
▶ Webmaster Tools: Apply the latest version by re-requesting Robots.txt Webmaster Tools
