Backup, Recovery, Delete

Warning: the import and export procedures you find on administration side of Newsletter ARE NOT meant to do a backup and a restore. They are just options to import formatted data and export the subscribers.

Backup and where data is stored

Newsletter stores all its data into the WP database. You can find it in two locations:

  • the wp_options table under the keys newsletter* (which is the standard WP way to store the plugin settings)
  • the wp_newsletter* tables

Note: we cannot grant someone else is using the newsletter prefix on tables and options keys.

If you want backup only the Newsletter settings and data you need to extract the Newsletter options from the wp_options table and dump all the wp_newsletter* tables. Of course, if your installation uses a different table prefix, you need to replace the wp_ prefix with your own.

The table prefix is defined inside your wp-config.php file.

If you developed custom themes or someone developed them for you, they should be stored inside the wp-content/extensions/newsletter folder. You should backup it as well.

Maybe you’re even interested in other two folders:

  • wp-content/logs/newsletter contains, if enabled, the plugin working logs
  • wp-content/uploads/newsletter contains the resized images used in newsletter to fix the layout

The Newsletter generated images stored on wp-content/uploads/newsletter are not referenced in the media database so there is not the need to extract media data from the database. If you change the domain or remove the generated thumbnails images won’t be visibile on old newsletters anymore.

Using backup plugins

Every backup plugin has its own behavior. You need to be sure the plugin you use is able to backup even tables not strictly part of WP, like the ones Newsletter creates (wp_newsletter*). This is a common consideration valid for all plugins which need custom tables.

Moving everything to a new site

So, you’re transferring the whole site to another provider.

If you use a backup and restore plugin and it backup even the Newsletter custom tables, you should have no problems at all. When the backup and restore is made by a consultant, he should move all tables by default or ask you what you need to be transferred. Transfer provided as service by providers usually mirror completely the site and the database without any possibility of data loss.

Domain changing

If you change the domain, some problems will arise. Newsletter contains absolute references to images which probably won’t be fixed by who manage the migration. Usually it’s not a big problem since old newsletter could have already been deleted by your subscribers or not opened anymore.

Anyway you should review all Newsletter configurations (specially the subscription, activation and cancellation panels) to fix the links.

Restore/Move only Newsletter

If you need to restore or move only Newsletter, you need to make a backup as explained and import it on the new site. Please note that backing up and restoring only a small set of options is not an easy task.

Deleting Newsletter

If you need to clean up totally your blog from Newsletter and its data, you should:

  • uninstall the plugin and all the addons from your blog plugin admin panel
  • use a database manager and drop every table named wp_newsletter*. wp_ is the prefix used by WP as default on not customized installations but it could be different in your blog
  • remove the folder wp-content/logs/newsletter/
  • remove all options in the wp_options table with name newsletter or starting with name newsletter_
  • remove the folderĀ wp-content/uploads/newsletter/
  • remove the folderĀ wp-content/extensions/newsletter/