Most WordPress users have the same table prefix ‘wp_’ in wp-config.php. That is not good for security reason. I did researched how to do it but I would like to know your experience how-to in Webfaction before I start. asked 31 Oct '10, 10:05 Mikey3D |
WebFaction's built-in installers use the default table prefix. If you want to use a different table prefix for a new WP installation, then you can install WP manually with the following general steps:
If you want to change the table prefix for an existing WP installation, there are many examples of how to do this available on the web. This one seems reasonable: 6 Simple Steps to Change Your Table Prefix in Wordpress Hope that helps!
permanent link
This answer is marked "community wiki".
answered 31 Oct '10, 10:13 seanf OK, how would you change table prefix in productive site?
(31 Oct '10, 10:28)
Mikey3D
I've updated my original answer with info to help you change the prefix for an existing site.
(31 Oct '10, 10:35)
seanf
Good, I haven’t missed anything by your research. I’m going to do it now. Thanks seanf.
(31 Oct '10, 10:45)
Mikey3D
I did login phpMyAdmin. I can change all WordPress table prefixes but why can’t I changed some parts of BuddyPress table prefixes: I can change this:
Why can’t I change this?
When I run SQL query/queries on database myWPdatabase:
I get this:
Thanks, Mikey3D
(31 Oct '10, 14:05)
Mikey3D
Try using
(31 Oct '10, 14:19)
seanf
My fault! I can’t believe it how I could miss that bb and bp are difference. Sorry! Are those two commands the same difference?
(31 Oct '10, 14:36)
Mikey3D
Haha, I didn't notice that either! Regarding the difference
(31 Oct '10, 14:42)
seanf
showing 5 of 7
show 2 more comments
|