[GUIDE] Export Mail Addresses from your Database

HOW TO EXPORT EMAIL ADDRESSES

Requirements for this guide
– phpMyAdmin
– A record of messing up databases (if you have ever doomed a database, you know what you shouldn’t do)
– Backup your database before doing anything (if you don’t know how to backup your database don’t continue)

PHEW! NOW THAT’S OUT OF THE WAY, LET’S START

STEP-1 BACKUP

Login with your database credentials (found in settings.php)
Hit the export button and leave everything else as is then click on the go button
Very good! You have now backed up your current database

STEP-2 TABLE

In you left side panel, expand your main database (the name you selected for your database)
At the very bottom, click on “chv_users”

 

STEP-3 USER_EMAIL

Don’t be afraid and don’t touch anything you don’t understand, keep calm this is going to be fine!
Click on the “SQL” tab in the upper navigation bar
You’ll get a view like this:

In the text editor where it says “SELECT * FROM ‘Chv_users’ where 1” mark the “*” symbol like this
As you can see in the image above I’ve selected the “user_email” in the “Columns” section. Go ahead and select “user_email” (make sure you still have marked the *) then click on the left arrow under the Columns box.

If your result is

you have done well. I’m proud!

Confirm with the GO button and it will give you an list of email addresses registered on your website.

STEP-4 EXPORT

Locate the export button at the bottom of the page you currently at
Click on “Export” (YOU DON’T NEED TO “CHECK-ALL” BEFORE THIS)
On the next page, select Custom Export Method and select “CSV” under the “Format” tab
Once you have selected this check if the “Format-specific options” is as follows
Don’t change any other options than these if they defer
Obviously hit “Go”
You will now download “chv_users.csv”
Open this file in a text editor such as Notepad++
Log out.
STEP-5 
Take a deep breath. It went good! If you magically deferred from this guide and fucked up everything, remember STEP-1 BACKUP ;)
Please follow and like us:

Leave a Reply