How to fix the cleaning process of WordPress Meta Data?

How to fix the cleaning process of WordPress Meta Data?

Do you know the process of getting information other elements of data? Metadata is the right choice! Either it is related to the document, website or file; you can get more from Metadata. Apart from this, metadata gives more info regarding size and format too! If Metadata grows with more size then it would automatically decrease the website performance. When coming to the growth of metadata size, it grows rapidly when you delete, create and upload the images or files on the website.

So, at regular intervals, we recommend you clean the metadata in WordPress. This would make your website work faster.

What else do you need to clean metadata now?
  • Your domain name
  • Credential of cPanel
  • Database of WordPress
Step 1: Go to the cPanel account and log in with credentials. Search for the section “Database” and then choose options such as phpMyAdmin, MySQL@Databases, PostgreSQL Database Wizard and phpPgAdmin.

Step 2: Choose the first option “phpMyAdmin” to tap on the database name. You can see the prefix in front of the database name such as err_comments etc.

Step 3: To work on the SQL Query window, you should select the tap “SQL”.

It is a must for you to remove the err_postmeta by copying below mentioned codes:
Code:
SELECT * FROM mrr_postmets pm LEFTJOIN mrr_posts wp ON wp.ID = pm.post_id WHERE wp.ID ISNULL;
DELETE pm FROM mrr_postmeta pm LEFTJOIN mrr_posts wp ON wp.ID = pm.post_id WHERE wp.ID ISNULL;
Don’t forget to tap on the button “Go”!

Step 4: Once if the queries get executed one by one, phpMyAdmin takes the responsibility to show the list of err_postmeta removal. You can clear the err_postmeta by this method.

Step 5:

Code:
SELECT * FROM mrr_commentmeta WHERE comment_id NOTIN ( SELECT comment_id FROM mrr_comments );
DELETEFROM mrr_commentmeta WHERE comment_id NOTIN ( SELECT comment_id FROM mrr_comments );
SELECT * FROM mrr_commentmeta WHERE meta_key LIKE'%akismet%';
DELETEFROM mrr_commentmeta WHERE meta_key LIKE'%akismet%';
You can even erase meta-comment by executing above mentioned query in the SQL query window.

That’s it! It won’t create much problem for removing metadata from WordPress. We recommend you to follow all the mentioned steps one by one to make your work easier than before.
Author
kumkumsharma
Views
2,096
First release
Last update
Rating
0.00 star(s) 0 ratings

More resources from kumkumsharma

Top