Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


How i Export User Email Only from My site Database?
New on LowEndTalk? Please Register and read our Community Rules.

All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.

How i Export User Email Only from My site Database?

20142014 Member

How i Export User Email Only from My site Database?

Comments

  • MuZoMuZo Member

    More informations? Are you using a CMS for your site?

  • vpsGODvpsGOD Member, Host Rep

    select email_col from table_name
    :)

  • Please add more information. Like what is the cms behind your website. What is your database type.

  • 20142014 Member

    @sdglhm @MuZo
    Sorry for my explain..

    Here is CMS im using - http://goo.gl/4LWHC2

    here is Screenshot
    http://postimg.org/image/oj8trams9/
    http://postimg.org/image/4ncubr5qx/

    i want to download all email address.. how i do that?

  • Open your users table. Then select the export based on that column

  • 20142014 Member

    @sdglhm said:
    Open your users table. Then select the export based on that column

    Dear i want User email List only... not users backup :(

  • That's why I've told you export based on that column. You can use CSV export.

  • 20142014 Member

    @sdglhm said:

    Check this image - http://postimg.org/image/4k6hn0e4x/

    so how ?

  • You'll have to use select with into outfile sql query. Or you can achieve this easily by using MySQL work bench.

  • 20142014 Member

    @sdglhm said:
    You'll have to use select with into outfile sql query. Or you can achieve this easily by using MySQL work bench.

    im a new for this field so I don't know exactly how i make it... i have install MySQL workbench but its not working.. anyway.. can you please tell me step by step? than hug help for me :)

  • Enable remote SQL on your web hosting and connect your Work bench with your data base. Use % as the IP because most of the times Sri Lankan IP's are fairly random.

    Then run a select query with your table. Export the result as CSV

  • MuZoMuZo Member

    Select email from users; would be the SQL query to get only users email address. You can use the query tool on phpmyadmin and copy the text result. There are other ways, it depends how you want to work with your data.

Sign In or Register to comment.