How to export emails from WordPress comments

Sometimes you have had to clean your database or your users, but the problem is that you lose some contacts from great interest .

Likewise, if you want to send emails to your visitors who have commented the internal process can be tedious, and it would be better to send them an email through a newsletter system right? [19659003] Well, let's see a simple way to export the emails of your commentators so you can have them in a more appropriate and clean format to send them an email or a newsletter, of course with prior consent. [19659003] For this we are going to use an SQL command so we will go to the hosting panel and open the application PHPMyAdmin which is the database manager.

[19659003] Once inside select your base of data and go to the SQL tab

That's where will execute the following SQL command :

Where you will have to substitute the default code prefix (wp_) for the one you use .

In any way it's easy because PHPMyAdmin has a predictive search engine as you type the name of a table

Then press the continue button and it will show you the results:

[19659003] You only have to click on the link of Export from the bottom of the list and on the next screen choose the format, for example CSV .

Y exports a super cute list to be used at your will.

Oh, what do you prefer a plugin?

Well, nothing, you learn less but existing exists, it's called Comments Emails and it's very easy to use … and pull, when you have finished using it.

Loading …

may also help you:

How to completely uninstall a WordPress plugin

Install WordPress plugins is easy just like install WordPress themes but sometimes there are plugins that resist , as for example, cache plugins, which are not so easy to uninstall . And they are not the only ones that are not completely uninstalled.

In principle the concept is easy:

  1. Go to the administration of your WordPress> Plugins
  2. Click on Deactivate.
  3. Once deactivated click in Delete.

Done this the plugin is inactive and you have deleted the folder and files inside that folder, of the plugin, but have you completely uninstalled the plugin? [19659003] Many times this is not the case, since sometimes plugins can leave traces in the following sites :

  • Additional lines in the wp-config.php file
  • Additional lines in the .htaccess file [19659005] New tables in the database
  • Own information in the WordPress tables
  • Additional files and directories in the root folders, wp-content, uploads, plugins.

So, the first step to be able to identify what is WordPress and what the plugins add is know what makes a standard installation of WordPress and what not .

What's in a standard WordPress installation

 standard installation desktop wordpress

Tables of the database

Tables by The default of a newly installed WordPress database is 12, these:

  1. wp_commentmeta
  2. wp_comments
  3. wp_links
  4. wp_options
  5. wp_postmeta
  6. wp_posts
  7. wp_termmeta
  8. wp_terms [19659005] wp_term_relationships
  9. wp_term_taxonomy
  10. wp_usermeta
  11. wp_users

And in the case of a multisite installation there are 6 additional tables:

  1. wp_blogs
  2. wp_blog_versions
  3. wp_registration_log
  4. wp_signups
  5. wp_site
  6. wp_sitemeta

Seen which, if in a simple installation of WordPress you have more than 12 tables you can already assume that some plugin, or even the theme, has created some additional table. Likewise, in a multi-site installation, if you have more than 18 tables.

WordPress installation folders

By default, WordPress creates these main folders:

  • wp-admin
  • wp-includes
  • wp -content

Later, when you have some life, you will usually grow a bit, like this:

  • wp-admin
  • wp-includes
  • wp-content
    • languages ​​
    • mu-plugins [19659005] plugins
    • themes
    • upgrade
    • uploads

And, in both cases, all these folders minus uploads will have subfolders.

As you'll see, If some plugin gets files and / or folders in additional subfolders the thing would be really complicated. Fortunately most of the plugins that do these things add folders and / or files to wp-content and / or uploads.

Where do I find unused WordPress plugins residues?

Based on the above, most common suspicious sites where you can find uninstalled plugins residues would be the following:

  1. Additional folders and / or files within wp-content and / or uploads .
  2. Additional tables in the database.
  3. Additional lines in the table wp_options from WordPress (almost all)

How uninstall a WordPress plugin

 clean wordpress

Seen the above are many things to review, and aware that each developer and each plugin is a world and that there is no standard for how a plugin should be uninstalled, we do not have another to manually check each time we uninstall a plugin .

But for that we will see some specific cases both of those who do it well and allow themselves to be uninstalled from the everything, like those that leave you with a garbage everywhere.

Cache plugins

As we saw in a previous article the cache plugins are the ones that leave the most and usually require manual actions.

And since we are not going to repeat everything explained on that occasion, I encourage you to take a look at the article in question, with information and detailed guides to uninstall the most popular WordPress cache plugins , this:

How to completely uninstall the cache plugins in WordPress

Plugins that are uninstalled completely (or almost)

There are many more plugins that are completely uninstalled than those that do not. There are thousands, so we are not going to quote them all.

However I leave you some (pretty) good examples to highlight, which have their own uninstaller:

  • Broken Link Checker: Has a script if you run it uninstalls completely, and thank goodness, because it creates a lot of information in your database.
  • Gravity Forms: When you uninstall it asks you for confirmation to delete all your information, which deletes the 9 tables of the database he added You will only have to clean lines manually in the table wp_options (I told you that most of this is wrong).
  • WordFence: If you install the plugin WordFence Assistant (always advisable) you can delete all 23 plugin tables when uninstalling

My advice is that you do not trust any and always look – at least – if they have left folders, files, new tables or – almost always – additional information in the table wp_options .

Plugins that require additional work to uninstall them entirely

There are also many, in fact are legion and I would not even know where to start , so we will take some significant cases as an example, to know what to look for and what possibilities they offer to uninstall them.

WooCommerce

If you have ever installed WooCommerce to test if you installed an online store and then you have desisted after trying for whatever reason, you should know that it is not uninstalled at all even if you have deactivated and deleted it.

In fact, from the official WooCommerce page itself it is indicated that to uninstall the plugin completely , before deactivating it, you must add the following line to your file wp-config :

In this way, when you deactivate it and erase it, that constant will erase the, nothing less than, 16 tables that you add to your database these:

  1. wp_wc_download_log
  2. wp_wc_webhooks
  3. wp_woocommerce_api_keys
  4. wp_woocommerce_attribute_taxonomies
  5. wp_woocommerce_downloadable_product_permissions
  6. wp_woocommerce_log
  7. wp_woocommerce_order_itemmeta
  8. wp_woocommerce_order_items
  9. wp_woocommerce_payment_tokenmeta
  10. wp_woocommerce_payment_tokens
  11. wp_woocommerce_sessions
  12. wp_woocommerce_shipping_zones
  13. wp_woocommerce_shipping_zone_locations [19659005] wp_woocommerce_shipping_zone_methods
  14. wp_woocommerce_tax_rates
  15. wp_woocommerce_tax_rate_locations [196590] 07] Then delete that line from your wp-config.php .

    Otherwise, if you have already deactivated and deleted the plugin you will have to delete the tables manually from PHPMyAdmi n, either one by one or by selecting the previous ones all at once, as in the following screenshot …

     delete tables wordpress

    Important note : Before modifying and / or deleting anything in the database beam Backup

    Yoast SEO

    Another of the most popular plugins also leaves a lot of residue if you uninstall it.

    Yoast SEO creates 2 tables:

    • wp_yoast_seo_links
    • wp_yoast_seo_meta

    But it also stores information in :

    • wp_usermeta – meta_key values ​​as wpseo_title.
    • wp_postmeta – meta_key values ​​for several input IDs, including:
      1. _yoast_wpseo_linkdex
      2. _yoast_wpseo_title
      3. _yoast_wpseo_metadesc
      4. _yoast_wpseo_focuskw
      5. _yoast_wpse o_focuskw_text_input
      6. _yoast_wpseo_primary_category
      7. _yoast_wpseo_content_score

    And all this after deactivating and deleting.

    Akismet

    Akismet stores lots of data in table wp_commentmeta that will remain there after deleting the plugin. And I'm talking about thousands of lines .

    EWWW Image Optimizer

    This plugin for optimizing images, after deleting it, stores routes to your images, in their original size, the size after compressing them and the percentage of reduction.

    Everything saved in a single table, wp_ewwwio_images .

    You will also have to manually delete the folder ewww within wp-content

    And the shortcodes?

    Another one of the dump that plugins usually leave when you uninstall them are the shortcodes that use to show contents of any kind.

    This is another additional task that you will have to perform usually looking at the input screen for the shortcode of the plugin, and then editing the entry that contained it. [19659003]  delete shortcodes wordpress [19659] 138] Summing up, what do I do? </span></h2>
<p> Well, if you have read all of the above, I would summarize it like this: </p>
<ol start=

  16. First of all back up the database and files
  17. Go to your Desktop> Plugins and disable the plugin
  18. Also in Desktop> Plugins delete the plugin
  19. Delete any folder and / or additional file that installed the plugin
  20. Delete any table from the database that the plugin added when installing it
  21. If you used shortcodes, search for them and delete them from your entries and / or pages
  22. Check the wp_options table to see if you have left your own lines

That the Codex I will accompany you and force you, you will need it.

Loading …

That may also help you:

Reduce hundreds of Mb of your database in less than 1 minute

Yesterday I was taking a look at the blog database in PHPMyAdmin, something I recommend everyone do from time to time, and I found, as always, a lot of tables loaded with megs, usually plugins that I no longer use and other plugins I do use.

Of course I deleted all the plugins that I no longer use, but there were some that were of active plugins and they caught my attention because of their enormous size.

In fact each of them occupied more than 30Mb and they all started with wf .

As you have already guessed were from WordFence a great security plugin yes, but that stores a lot of information in the database . And I thought it important to share how to make it clean as it is one of the most popular plugins, which many of us use.

For example, the table _wfFileMods which stores the modifications in files, occupied she only solves more than 30Mb, let alone if you have active traffic visualization in real time, in which case you can find tables with hundreds of megabytes.

And one might think , because I erase them and the plugin starts again and I stop by every now and then and I'm cleaning, and yes, it's not a bad idea, but has a problem, if you delete the tables you will lose plugin settings so the correct way to do clean is as follows …

Save WordFence settings

Go to the bottom of the WordFence options page and export the WordFence settings.

]

After pressing the button a window will be displayed with a token, which is stored in the WordFence servers with your settings, copy it into a text file out there to use it later, it's a bunch of numbers and letters, or try to memorize it, it's impossible.

Make WordFence delete the tables when you deactivate it

A little above the previous section you will see a box for WordFence to delete its tables when it is deactivated, check the box and save the changes in the settings.

Disable and re-activate the plugin

Simple, go to the plugins management page, deactivate it, and then activate it again. No need to put capture not?

Import the settings

Go back to the WordFence options page and in the box to import settings paste the token you copied before and press the import settings button.

Below is a pop-up window that will confirm that your previous settings have been applied. Just click on the reload page and there you will have them again.

And gotten, WordFence active and configured to your liking, and without it occupying your precious space in the database

Now we only have to do the same with other plugins that also have the ugly habit of filling our database with megabytes, something that affects the performance of our server, do not hesitate.

Loading … [19659023] That may also help you: