Can I remove Multiple installations prefix?

  • Hello. When I first set up my WordPress a long time ago I accidentally created a unique prefix for my databases. It was in answer to this option, which I didn’t really understand at the time –

    // You can have multiple installations in one database if you give each a unique prefix
    $table_prefix = ‘******’;

    Subsequently I’ve been slightly annoyed that every table in my WordPress database has a random set of numbers and letters as a prefix. Of course it shouldn’t make any difference, but I’m using a plug-in that tries to identify orphan tables etc. and I’m wondering if having the prefix is making it not recognise some tables?

    So my question is, is it possible to remove the prefix from all of the tables without causing any problems? Or is it just too late, or too much messing about?
    Many thanks

    • This topic was modified 2 years, 4 months ago by XyZed.
Viewing 2 replies - 1 through 2 (of 2 total)

  • I’m using a plug-in that tries to identify orphan tables etc. and I’m wondering if having the prefix is making it not recognise some tables?

    No… if the plugin is any good, it should ignore the prefix entirely since that is constant for all tables.

    So my question is, is it possible to remove the prefix from all of the tables without causing any problems? Or is it just too late, or too much messing about?

    There are several plugins that do this, like this and this and this… but in the name of security (for sites that used the default wp_ prefix).

    In your case, I really don’t see the point.

    But if you decide to do this, please make absolutely sure you have an up-to-date and complete backup of your website that you can quickly restore just in case something breaks.

    Good luck!

    Thread Starter XyZed

    (@xyzed)

    Thanks George. I think I’ll leave things as they are then. Life’s complicated enough ??

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Can I remove Multiple installations prefix?’ is closed to new replies.