Manually Export Subscribers

  • Resolved MitchGusdal

    (@mitchgusdal)


    10 years ago

    Hi there,

    I’ve been rebuilding my client’s website, and need to import the subscriber list for their newsletter. However, there is no live version of their old website to export the list from…

    I do have a complete backup of the old site, with databases and everything. Is there a way to extract the subscribers from the backup files? Where is the information stored?

    Hoping I can do this without having to re-activate the old site.

    Thanks,
    Mitch

    https://wordpress.org/plugins/wysija-newsletters/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Wysija

    (@wysija)

    10 years ago

    Hi Mitch,

    The subscribers are stored in the wysija_users table in the database. You’ll need to be familiar with SQL in order to extract them.

    Hopefully that helps!

    Thread Starter MitchGusdal

    (@mitchgusdal)

    10 years ago

    It does help! Thanks.

    So I do actually have access to the old database through phpMyAdmin, and I see a few tables that seem like they might be the answer:

    wysija_user
    wysija_user_history
    wysija_user_list

    Is there a specific one that I could export the list from, or is is sort of a bit from each?

    Thread Starter MitchGusdal

    (@mitchgusdal)

    10 years ago

    Nevermind, figured it out. Thanks for the support.

    -Mitch

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Manually Export Subscribers’ is closed to new replies.