So, I created a brand new site in Local by Flywheel. I did not choose any custom settings.
I went to adminer, and deleted all of the wp tables in local databases.
I then uploaded my database.
Then I looked for any of these and deleted them: Wordfence 7 Tables
wp_wfBadLeechers
wp_wfBlockedCommentLog
wp_wfBlockedIPLog
wp_wfBlocks (Legacy)
wp_wfBlocks7
wp_wfBlocksAdv
wp_wfConfig
wp_wfCrawlers
wp_wfFileChanges
wp_wfFileMods
wp_wfHits
wp_wfHoover
wp_wfIssues
wp_wfKnownFileList
wp_wfLeechers
wp_wfLockedOut
wp_wfLocs
wp_wfLogins
wp_wfNet404s
wp_wfNotifications
wp_wfPendingIssues
wp_wfReverseCache
wp_wfScanners
wp_wfSNIPCache
wp_wfStatus
wp_wfThrottleLog
wp_wfVulnScanners
According to this: https://www.wordfence.com/help/advanced/remove-or-reset/
No need to remove plugin files because none were added.
I also deleted:
ffwjh_bpspro_login_security
ffwjh_bpspro_seclog_ignore
ffwjh_bwps_lockouts
ffwjh_bwps_log
In case they would cause similar issues.
I then created an SQL command with this: https://wpmultisitedomainreplace.com/
And ran it.
I had a number of errors saying files don’t exist.
Error in query (1146): Table ‘local.ffwjh_blogs’ doesn’t exist
Error in query (1146): Table ‘local.ffwjh_site’ doesn’t exist
Error in query (1146): Table ‘local.ffwjh_sitemeta’ doesn’t exist
Error in query (1146): Table ‘local.ffwjh_1_options’ doesn’t exist
Error in query (1146): Table ‘local.ffwjh_1_options’ doesn’t exist
Error in query (1146): Table ‘local.ffwjh_2_options’ doesn’t exist
Error in query (1146): Table ‘local.ffwjh_3_options’ doesn’t exist
Restarted the site in Flywheel.
I clicked view site, and it took me to a page asking to install Wordpress. So I followed the wizard.
I got into admin but none of my articles are there. It’s just a blank install.