Where is my user email database located?

my user email database is somewhere in there

I do not believe such exists…are you wanting to extract all your registered users email addresses?

Yes, looking to get all email addresses of the registered members.

Using phpMyAdmin, you can run a query on the user table and then export that.

SELECT COUNT(*) ASRows,user_login,user_emailFROMwp_usersGROUP BYuser_loginORDER BYuser_login

Note, wp_ is the default…

Please never work with phpMyAdmin unless you first do a backup at that time first! (Not heeding this advise can leave you without a site)

Note there are very important ‘ticks’ in the string – you can also build the query in phpMyAdmin

Also now posted:
https://seacoastwebservice.com/using-phpmyadmin-to-get-registered-users-email-addresses/

Hmm, I don’t have phpmyadmin so I’m not familiar with it. I’m sure I could download it & follow directions though, just a matter of taking enough time to set aside for the learning curve…

I may just have to put this on the back burner for now (I MIGHT tackle this tonight) & “hope” the entire user email list is somewhere in the pile of 15k files in the “backup” folder I downloaded…

entire user email list is somewhere in the pile of 15k files in the “backup” folder I downloaded

They are in the MySQL database – ask your host how to access it. But heed this advice: do a full db backup first and make sure that it is right….

You would have set this db up – how did you? If your host did as part of a wordpress installer, again ask them.

I had help in the beginning when transferring everything over to WP, so I’m sure there was a DB created as I paid the guys about $600 to make the move & setup for me.

I’m going to try to give it a tackle later perhaps. I’ll try following your walk-through & hopefully I can get the list I’m looking for.

But I’m no longer with the guys who transferred my DB & hostgator couldn’t help me find the DB for some reason.

So I’m kind of on my own other than the help from you.

Thanks.