Results 1 to 2 of 2
  1. #1

    Export Email Addresses Mysql

    I've done this before but cant remember how i done it ! - I want to export the email address's from all my users in my mysql database to a plain .txt file -- I ran a query before but cant remember what it was. When i ran the query it listed all the email address from all my users in the mysql query windows in phpmyadmin

  2. #2
    Join Date
    Apr 2007
    Location
    Calgary, Canada
    Posts
    200
    Hmmm... If you want to list all the email address of all your users by running something like this:

    Code:
    SELECT `emailAddresses` FROM `users`
    If you want to save the list somewhere, you can use the INTO OUTFILE clause.

Similar Threads

  1. Export all MySQL databases
    By rotis in forum VPS Hosting
    Replies: 4
    Last Post: 09-25-2008, 08:58 PM
  2. MySQL 5 export to 4.1?
    By tm2000 in forum Hosting Software and Control Panels
    Replies: 2
    Last Post: 08-17-2007, 12:49 PM
  3. Replies: 9
    Last Post: 06-19-2007, 12:38 PM
  4. export & import mysql db
    By mygethosted in forum Hosting Security and Technology
    Replies: 0
    Last Post: 03-21-2006, 03:59 PM
  5. Export Email Address with Plesk
    By alogic in forum Hosting Software and Control Panels
    Replies: 0
    Last Post: 12-20-2004, 09:28 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •