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 fix the "Error establishing a connection to the database" in WordPress

One of the ugliest errors you can find in WordPress is the one that says " Error establishing a connection to the database ", basically because it is a blank screen that leaves no room for action on it, something must be done, but behind the scenes.

Although this error is quite radical in the result you see (your entire site has disappeared ) is usually not hard to fix .

The first thing you should know, before panicking, is that it's quite likely that your data is still alive and safe, so , take a deep breath and let's get down to work, okay?

What does "Error establishing a connection to the database?"

The ugly mistake!

To begin with, it is important that you know the mechanisms that are behind the error.

In WordPr There are two main parts:

  • The HTML / PHP code – This is what controls how your site and its features look.
  • Your database – It's where all the information is stored of your entries, pages, settings, comments, and everything else.

When a user comes to your site the HTML / PHP part of WordPress consults in your database to know what content to insert in HTML / PHP. [19659003] So the first thing that WordPress does is consult the database and for that you need to establish a connection with the database.

Offline, WordPress does not You could access any of the content you have to show your visitors. So if WordPress is not able to establish a connection to the database, specified in your file wp-config.php shows you that ugly error .

we have a first place to look!

What causes the "Error establishing a connection to the database?

Once we know what the message really means we will begin to investigate to see why the error is showing on your site.

If you just installed WordPress, you probably entered the database credentials wrong.

But if you see the error in a WordPress site already running, there are other possible guilty:

  • Your database is corrupt. Sometimes, WordPress will show this error if your database is corrupted. Next we see how to check this, do not worry.
  • Your credentials to access the database are not correct. If you have recently changed your credentials to the database you will see this error if you forgot the credentials or did not add them to your file wp-config.php . They could also be errors with the user's permissions to access the database.
  • You are having a problem with your hosting provider . There are some other possible problems that could also cause this error.

Seen this, we will see how to solve each of the possible problems.

How to fix a corrupted database

There is a simple trick that will tell you if the problem is causing a corrupted database:

Try accessing your WordPress desktop, wp-admin

If the error message changes to "One or more tables the database is not available "then you have been lucky, you have to repair the database!

That means that the database is really corrupt, not that there is a broken connection to the database. On the contrary, if the error message does not change, you should go to the next section of this article .

To fix your corrupt database you will have to do 2 things:

  • Add a code to your file wp-config.php to activate the repair tool.
  • Run this repair tool.

So to start, open your favorite FTP program or the file manager panel of your hosting to edit the file wp-config.php . In this article I will use the file manager, which is what you will have on hand, and you do not need to install any additional program or learn to use it.

Go to the panel of your hosting and look for the File Manager ]then locate the site affected by the error.

In the root folder of your WordPress installation with the problem click on the file icon wp-config.php ] and, at the top of the file manager, click on the Code Editor.

When the file wp-config.php is open in the code editor add the following code before the line that says that " That's all, stop editing! Happy blogging ":