Dashboard

How to Retrieve and Restore Your 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

  • Cleaning Up Your Email List: A Step-by-Step Guide to Deleting Bounced Subscribers

    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

    One of the most powerful features of Noptin is its support for custom fields. You can use custom fields to store more information about your subscribers (such as their phone numbers and birthdays). This guide shows you how to create and edit custom fields. Creating Custom Fields To create a new custom field:- First, visit…

    Read More

  • Importing Subscribers

    Learn how to import subscribers from another system into Noptin.

    Read More

  • Subscriber Lists

    Subscriber lists allow you to categorize your subscribers, similarly to how you use normal categories in WordPress. You can set lists in such a way that subscribers can only be on a single list at a time or multiple lists at the same time. Unlike tags, subscribers can select their own lists either on the…

    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 anti-spamming laws, Noptin allows you to add the [[unsubscribe_url]] merge tag to your emails to give your subscribers a way to unsubscribe from your newsletter. This is added by default to your newsletter’s permission reminder. You can, however, add it anywhere in the emails you send. Customizing…

    Read More

  • Welcome New Subscribers

    74% of your subscribers expect a welcome email after they sign up for your email list. Invespcro A welcome email is the first email that you send to your subscribers after they sign up for your email list. To set up a welcome email:- First, click on Noptin > Email Campaigns > Automated Emails to…

    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

  • Bulk-delete newsletter subscribers

    Noptin allows you to bulk delete your newsletter subscribers. You can delete all your subscribers or filter them by:- This is useful, for example, if you have a comma-separated list of bounced emails and need to bulk-delete all of them. To do this:- First, open your admin dashboard and then click on Noptin > Email…

    Read More

  • Exporting Subscribers

    How to download your subscribers or only a segment of your subscribers.

    Read More

  • Hiding Forms From Existing Subscribers

    It’s annoying when you keep displaying newsletter subscription forms to your existing email subscribers. To hide the forms from existing subscribers:- Open the Noptin settings page and toggle the “Hide From Subscribers” switch. That’s all! Your existing email subscribers will no longer see any subscription forms, checkboxes, or popups. However, subscribers that you imported from…

    Read More

  • Manage Subscription Preferences

    Create a manage preferences form where subscribers can unsubscribe (or resubscribe) from your newsletter or update their subscription details.

    Read More

  • Notify the site admin when there’s a new subscriber

    This guide shows you how to notify the site admin whenever there’s a new subscriber. We’ll use automation rules to achieve this.

    Read More

  • Collecting Secondary Email Addresses

    It is possible to let your subscribers add a secondary email address and send newsletters to both email addresses. To do this, First, create a custom field for the secondary email as shown below:- Next, add the following PHP code snippet to your site.

    Read More

Leave a Reply

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