Redundant tables?

  • Adendum

    (@adendum)


    8 years, 4 months ago

    I am now using MailPoet3 but previously used MailPoet2 and the earlier version Wysija.

    When I am look at my database I see old tables from the earlier versions but wanted confirmation which tables I can safely drop. The plugin, Plugins Garbage Collector, is showing ambiguous results for many of the _mailpoet_ tables so it would be helpful if someone at MailPoet could identify all the tables I can manually drop….

    UNSURE WHAT THESE ARE:
    _es_deliverreport
    _es_emaillist
    _es_notification
    _es_sentdetails

    MAILPOET3 tables but any MAILPOET2 tables here also?
    _mailpoet_custom_fields
    _mailpoet_forms
    _mailpoet_mapping_to_external_entities
    _mailpoet_newsletters
    _mailpoet_newsletter_links
    _mailpoet_newsletter_option
    _mailpoet_newsletter_option_fields
    _mailpoet_newsletter_posts
    _mailpoet_newsletter_segment
    _mailpoet_newsletter_templates
    _mailpoet_scheduled_tasks
    _mailpoet_scheduled_task
    _mailpoet_segments
    _mailpoet_sending_queues
    _mailpoet_settings
    _mailpoet_statistics_clicks
    _mailpoet_statistics_forms
    _mailpoet_statistics_newsletters
    _mailpoet_statistics_opens
    _mailpoet_statistics_unsubscribes
    _mailpoet_subscribers
    _mailpoet_subscriber_custom_field
    _mailpoet_subscriber_ips
    _mailpoet_subscriber_segment

    I ASSUME OLD TABLES I CAN DELETE?
    _wysija_campaign
    _wysija_campaign_list
    _wysija_custom_field
    _wysija_email
    _wysija_email_user_stat
    _wysija_email_user_url
    _wysija_form
    _wysija_list
    _wysija_queue
    _wysija_subscriber_ips
    _wysija_url
    _wysija_url_mail
    _wysija_user
    _wysija_user_field
    _wysija_user_history
    _wysija_user_list

    Thanks in advance 🙂

Viewing 1 replies (of 1 total)
  • Jack K

    (@jack-kitterhing)

    8 years, 3 months ago

    Hi there @adendum,

    I’ve checked this out and can confirm. You need these tables:

    _mailpoet_custom_fields
_mailpoet_forms
_mailpoet_mapping_to_external_entities 
_mailpoet_newsletters 
_mailpoet_newsletter_links
_mailpoet_newsletter_option
_mailpoet_newsletter_option_fields
_mailpoet_newsletter_posts
_mailpoet_newsletter_segment 
_mailpoet_newsletter_templates
_mailpoet_scheduled_tasks
_mailpoet_scheduled_task_subscribers
_mailpoet_segments
_mailpoet_sending_queues
_mailpoet_settings
_mailpoet_statistics_clicks
_mailpoet_statistics_forms
_mailpoet_statistics_newsletters
_mailpoet_statistics_opens
_mailpoet_statistics_unsubscribes
_mailpoet_subscribers
_mailpoet_subscriber_custom_field
_mailpoet_subscriber_ips
_mailpoet_subscriber_segment

    These tables

    _es_deliverreport
_es_emaillist
_es_notification
_es_sentdetails

    Are from this plugin: https://github.com/projectestac/wordpress-email-subscribers so as long as you aren’t using that you should be safe to delete those.

    You’ll also be safe to delete those old MailPoet 2/WYSIJA tables.

    As always before deleting any tables, I’d recommend taking a full backup in case anything goes wrong. 🙂

    Thanks!

Viewing 1 replies (of 1 total)

The topic ‘Redundant tables?’ is closed to new replies.

Tags