wrong database backed up

tl;dr
Do a WordPress Export (in addition to a database backup) prior to running this plugin.

I’m running on localhost/MAMP. I installed the plugin and backed up the database, .htaccess, and wp-config.php before making any changes in the plugin settings. After completing the plugin setup I discovered that almost all of my pages were missing. Restoring the backup didn’t work. After several hours of forensic work here’s my theory.

I have two different WP installations (call the WP1 and WP2) on localhhost. I stopped developing WP1 but did not delete the WP1 database or WP1 files. I installed your plugin in the newer WP2 installation only. Each database had a unique name and unique table prefix. Both databases had the same username and password.

The plugin appears to have backed up the old database (associated with WP1) rather than the newer database (WP2). Something corrupted the WP2 database (I assume this plugin), and now all of the newer database content is lost and can’t be restored from backup because there isn’t one.

The older (WP1) database name is dl*** while the newer database name is te***. Both of them contain several tables associated with your plugin, such as wp_aiowps_events.

Question-was this caused by my having identical login credentials for both databases? Does the plugin look for the first (alphabetical) database it can log into? The correct DB name is in wp-config but the plugin didn’t use it.

In any case, you should have users do a WordPress Export as well as backing up the database. I have an older Export but I still lost 80% of my work.

https://ww.wp.xz.cn/plugins/all-in-one-wp-security-and-firewall/