Accelerate your eCommerce ambitions with adeptCommerce Suite

SEO Egghead Consulting Group is a web development firm dedicated to creating custom, search-engine-optimized web site applications.

We specialize in eCommerce and content management web sites that not only render information beautifully to the human, but also satisfy the "third browser" - the search engine. To us, search engines are people too.

image description image description image description image description

WordPress Table Prefix Rename Plugin

Change your WordPress table prefix in 2 easy steps!

NEED A GREAT WEB SITE? NEED IT TO BE SEARCH-ENGINE-FRIENDLY?

SEO Egghead is a web development firm dedicated to creating custom, search engine optimized web site applications. We specialize in eCommerce and content management web sites that not only render information beautifully to the human, but also satisfy the "third browser" — the search engine. To us, search engines are people too. Click here to talk to us. We'd love to help!
X
This WordPress plugin facilitates renaming all WordPress tables with a custom prefix. Why do that?

Well, it turns out that the majority of exploits we've seen against WordPress-based web sites (this one and those for clients) have a very simple signature — they attempt SQL injection attacks with the assumption that the table prefix is set to "wp_." So why not just change the prefix?

Now this is nothing new, and other people have written it up or made plugins. But they require that one make the changes manually and/or live. Our version does the following in 2 easy steps with a button-click for each —

1. Creates a duplicate set of tables with the same structure/schema.
1a. Copies a coherent version of the old tables to the new tables.
1b. Makes a few changes to the data in the new tables with regard to the new table names.
(all the while showing all executed queries to keep you informed).

2. Swaps to the newly-created set of tables.

To be added in a future version — Lock tables to prevent any (obscure) race-conditions during step 1.

It should not result in any problems; but if it does blow up for whatever reason, your old tables are still there as they were. And that's a good thing.

Screenshot —




Instructions —


0. Install and activate plugin.
1. Make a backup of everything (just in case).
2. Click "Generate New Tables."
3. Click "Change $table_prefix," and follow directions to manually modify wp-config.php if applicable.

Tell an amigo:
Sphinn Digg Reddit del.icio.us StumbleUpon Facebook