Noptin Logo
Dashboard

    How to Restore Email Subscribers from a cPanel Backup

    We recommend that you export your subscribers before installing a major update.

    This way, you can always re-import the subscribers if anything goes wrong.

    This tutorial shows you a workaround you can use to import your subscribers in case you forgot to export your subscribers.

    This will only work if you backed up your database via cPanel.

    Step 1: Access cPanel and Open phpMyAdmin

    1. Log in to your cPanel account.
    2. Navigate to the Databases section and click on phpMyAdmin.
    Open PHPMyAdmin on cpanel

    Step 2: Locate the Backup and Extract the SQL File

    1. Download the backup file from your cPanel to your local machine if you haven’t already.
    2. Extract the backup file using a file extraction tool like 7-Zip or WinRAR.
    3. Inside the extracted files, locate the SQL dump of your database. This file usually ends with .sql.
    Download MySQL database backup in cPanel

    Step 3: Open and Read the SQL File

    1. Open the SQL file in a text editor (e.g., Notepad++, VS Code).
    2. Find the SQL commands for the wp_noptin_subscribers table. Look for the section that begins with CREATE TABLE followed by wp_noptin_subscribers and the subsequent INSERT INTO statements. If you’re using a different database prefix then look for “${your_prefix}_noptin_subscribers“.
    Noptin subscribers dump

    Step 4: Copy the SQL Commands

    1. Copy the SQL commands related to the wp_noptin_subscribers table. Ensure you include both the CREATE TABLE statement and all INSERT INTO statements.

    Step 5: Prepare to Import the Table

    1. Go back to phpMyAdmin in your cPanel.
    2. Select the database where you want to restore the table.

    Step 6: Import the Table

    1. Click on the Import tab in phpMyAdmin.
    2. Create a new SQL file on your computer and paste the copied SQL commands into this file. For example, “noptin-import.sql“.
    3. In phpMyAdmin, click on Choose File and select the newly created SQL file.
    4. Click Go to import the table into the selected database.

    Related Guides

    • How to Manually Add an Email Subscriber

      Learn how to manually add an email subscriber in Noptin, set their status, tags, lists, and custom fields, and avoid duplicate contacts.

      Read More

    • Bounce Handling

      How to automatically delete subscribers who bounce or report your emails as SPAM

      Read More

    • Sync Subscribers

      Have you ever wished you had several newsletter sign-up forms on different websites that all collected subscribers into a single newsletter list? This guide shows you how to do that. Step 1: Create a listener on the master site. Open one of the sites and then create an automation rule that listens to incoming webhooks…

      Read More

    • Custom Fields

      Create and edit subscriber custom fields in Noptin, and choose when to use a custom segment for selectable subscriber groups.

      Read More

    • Create a Custom Subscriber Segment

      Learn how to create custom subscriber segments in Noptin, add segment choices, assign subscribers, collect preferences on signup forms, and organize your email audience.

      Read More

    • Importing Subscribers

      Learn how to import subscribers from another system into Noptin.

      Read More

    • Subscriber Lists

      Learn how to use subscriber lists to organize contacts, target specific audiences, and send more relevant email campaigns in WordPress.

      Read More

    • Tagging Subscribers

      Learn how to manually or automatically tag or untag subscribers based on how they signed-up and the actions they take on your site. You can then filter email recipients by tags

      Read More

    • Double Opt-in

      This guide shows you how to enable double opt-in and how to edit the double opt-in email. Double opt-in means that subscribers will not receive any marketing emails unless they confirm their email addresses.

      Read More

    • Unsubscribing

      To comply with the CAN-SPAM Act and other email sending requirements, Noptin automatically adds a List-Unsubscribe header to every email it sends. This header allows email clients (such as Gmail and Apple Mail) to display a one-click unsubscribe button directly in their interface, making it easy for subscribers to opt out without even opening your…

      Read More

    • How to block newsletter subscribers

      Blocked subscribers are permanently excluded from your list—they won’t receive emails, and they can’t be re-added through forms, imports, or integrations.

      Read More

    • Automatically delete non-confirmed subscribers

      If you’ve enabled double opt-in, you can set up an automation rule that automatically deletes any subscriber who does not confirm their email address after a certain period. To do this:- First, open your admin dashboard and then click on Noptin > Automation Rules to open the automation rules overview page. Next, click the “Add…

      Read More

    Leave a Reply

    Your email address will not be published. Required fields are marked *