Long story short, I migrated from Craft 2 to Craft 3 but had an issue with a plugin.
Database Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'emailTemplateId' in 'where clause' The SQL being executed was: UPDATE craft_sproutemail_notificationemailsSET emailTemplateId='barrelstrength\sproutforms\integrations\sproutemail\emailtemplates\basic\BasicSproutFormsNotification' WHERE emailTemplateId='sproutforms-basicsproutformsnotification'
I was told to reinstall Craft 2, update the plugin, and then migrate over to Craft 3.
I moved the Craft 3 files, reinstall Craft 2 and am trying to import the backup database. The problem is my backup database has existing tables that cause errors.
According to this post:
They key is to get the database from the "backup database" function in the control panel that includes DROP TABLE IF EXISTS craft_analytics_settings; ... before it creates all the tables so you shouldn't have to delete any tables first, been working for us that way since the beginning.
I just don't know where to begin doing so. Is there any suggestions? At this point, I just want to get any version of the site back.