Importing a database from backup 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:

Best practice on importing Craft db backups?

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.

Thank you
Your problem is "only" database.

The first thing - create a another copy of your backup file.

Have you got phpMyAdmin?

You can create a new database and set env file in Craft.

or

You can drop all tables there and try load sql backup. If it is not working try create individual tables first after relations and data.