[Resolved] Table prefix change: Old topics don’t display, New topics go to db table with old prefix
I feel the answer is very close, just don’t know which file to look in.
Could anyone please assist with the below?
My db prefix was wp_
Using a security plugin I changed prefix wp_ to, say, mynewprefix_
1) DB side:
I was not able to log in to the phpMyAdmin under the old db user name. (But I was able to log in to WordPress Admin pages)
I created a new one db user and logged in successfully.
In wp-config.php I still see
/** MySQL database username */
/** MySQL database password */
Should I change a db user here? (may be it causes what happens in “2)” below)
If yes, how do I get an encrypted password?
Posts, Plugins, and Groups showed up after the prefix change, but
Forums do not display. Neither forum topics nor forum tags.
I created a topic. It saved, I see it in the web-site, but no old topics, they do not display.
I used this link http://tdot-blog.com/wordpress/6-simple-steps-to-change-your-table-prefix-in-wordpress
and manually went through steps. I found a couple of places with wp_ and changed them to mynewprefix.
In the PhpMyAdmin I see that I have several tables duplicated. Eg:
I see mynewprefix_bb_topics and wp_bb_topics.
The first table contains all old topics, the second table has the only the topic I created after changing the prefix using the plugin.
So it looks like all old topics exist, which is good.
But WordPress or buddypress does not see the renamed tables. And it writes all new topics to tables that been (automatically? re-)created and named with an old prefix (wp_).
What am I missing? Where?
Thanks heaps for your help. I looked through everything I could think of…
(I use wordpress Version 3.2.1, buddypress Version 1.2.9)
You must be logged in to reply to this topic.