WordPress.org

Ready to get started?Download WordPress

Forums

Where is my user email database located? (10 posts)

  1. JohnnyScience
    Member
    Posted 1 year ago #

    Ok I have a file entitled "backup" & inside of this folder has 15k other files & folders so I'm hoping my user email database is somewhere in there.

    Where is it usually located?

    I have Buddypress installed if it makes a difference.

    Thanks.

  2. Pioneer Valley Web Design
    Member
    Posted 1 year ago #

    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?

  3. JohnnyScience
    Member
    Posted 1 year ago #

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

  4. Pioneer Valley Web Design
    Member
    Posted 1 year ago #

    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)

  5. Pioneer Valley Web Design
    Member
    Posted 1 year ago #

    Note there are very important 'ticks' in the string - you can also build the query in phpMyAdmin

  6. Pioneer Valley Web Design
    Member
    Posted 1 year ago #

  7. JohnnyScience
    Member
    Posted 1 year ago #

    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...

  8. Pioneer Valley Web Design
    Member
    Posted 1 year ago #

    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.

  9. JohnnyScience
    Member
    Posted 1 year ago #

    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.

  10. JohnnyScience
    Member
    Posted 1 year ago #

    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.

Topic Closed

This topic has been closed to new replies.

About this Topic