I've been working on improving the security of my existing 4-blog multi-site WP install. One of the things I attempted to do was change the database table prefix from the standard "wp_" to something more obscure. I followed the directions for this in both John Hoff's "WordPress Defender" ebook and in the excellent "Digging into WordPress", which are for standard, not multi-site, installs. I tried:
1. The WordPress Table Prefix Rename Plugin.
2. Downloading my database, doing a full search and replace for "wp_", and replacing my old database with this new one.
Neither method worked. The plugin method fatally broke all but the main site, while the second method introduced a variety of problems that awkwardly displayed bare naked code (instead of menus and other elements) here and there on all my sites. I assume the problem is that some instances of "wp_" WITHIN the tables need to be changed (as well as the table names) -- but not all. But I have no idea which need to be changed and which don't.
Does anyone know how to change the database table prefix in an existing multi-site install? Is there a walk-through somewhere that lays out what needs to be done (and not done)? This seems like a good security precaution (wish I'd know about it when I set up the site), but I can't find any help for accomplishing it on a multi-site install. Any guidance would be most appreciated.