Support » Fixing WordPress » Where is my user email database located?

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

Viewing 9 replies - 1 through 9 (of 9 total)
  • 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

    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.

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Where is my user email database located?’ is closed to new replies.