Enterprise Pro – database confusion

[jhguynn]

I use Backup Buddy (iThemes) to backup my WP sites. One advantage of Backup Buddy I like is the ability to "micro" control which files and databases get copied and / or backed up.

Since I always rename my database prefix (as a security measure), it's easy for me to identify the database tables I want to copy.

Oddly, when using Backup Buddy, I also see WP database tables with the prefix "sog" Here is a complete list of them:

sog_users
sog_usermeta
sog_terms
sog_term_taxonomy
sog_term_relationships
sog_posts
sog_postmeta
sog_options
sog_links
sog_comments
sog_commentmeta

Apart form the prefix "sog" these are all duplicates of existing databases with the prefix I chose when I renamed the tables. Does anyone here have any idea what the source of these additional tables might be?

When I include them in the backup, the resulting website when I restore is non-functional.

I'm sure I can just manually exclude them from the backup, but I want to track down their origin.

Thanks for the help.

[nutsandbolts]

Do you have any subdomains attached to that site, by chance? Sometimes I forget to go into my BackupBuddy settings and update the list of excluded folders, so I end up with partial tables from subdomains' databases. Just a thought!

---

Andrea Whitmer, Owner/Developer, Nuts and Bolts Media
I provide development and training services for designers • Find me on Twitter and Google+

[Author]

Posts