Good to know, I’ll send them an e-mail. I think it read the wp-config when it (the plugin) initially created tables, but then after I changed table names, it created a new set of tables, still named wp_ and started over recording data. Fixing the name it had in one of the wp_options table pointed it at the original tables (now renamed).
As for the remaining wp_ instances, I’m down to just a few. A few of them are maybe variables, and not meant to be changed (ex: there is a ‘wp_me’ under table: wp_options, col: option_name data: stats_options). The other few might need to be changed, but I guess I’ll wait till I run into some kind of issue or run across more info.
For example:
table: wp_options col: option_name data: wp_db_backup_excs
table: wp_options col: option_name=cron option_value: several wp_ variables in here
table: wp_postmeta col: meta_key data: _wp_page_template (a few of them)
table: wp_options col: option_name=sidebar_widgets option_value: wp_inactive_widgets in it)
There are a bunch of entries in table wp_options where option_name is:
_transient_xxxxxxxxxxxxxx (xxxx is some name). Many of these have wp_ things in the value, but I’ve not changed them, as I’m guessing they aren’t that important, and maybe are just non-related variables anyway.
Just for the sake of other readers… a few of the places you need to change:
(I’ll call them ‘wp_’ but you will have renamed to ‘yourname_’ already, so take that into account). BTW, this isn’t an exhaustive list…
table: wp_options col: option_name data: wp_user_roles (change to yourname_user_roles)
table: wp_usermeta col: meta_key data: wp_capabilities (several of them), wp_user_level (several of them), wp_autosave_draft_ids, wp_usersettings, wp_usersettingstime, wp_dashboard_quick_press_last_post_id (again, put yourname_ in place of wp_)
My initial 70-some included a bunch of records the stat plugin had been recording, so they are rather irrelevant for me to change or worry about.
