Database Prefix Question

  • Resolved MDC2957

    (@mdc2957)


    6 months, 2 weeks ago

    Hope someone can help me out here.. I was just looking through my database and notice that I have what appear to be duplicate tables with different prefixes. I think what happened was that I changed the prefix using this plugin, then later deleted the plugin which I think changed the prefix back to wp_ Is that what happens when you delete the plugin? Does the prefix go back to wp_? In any event, I just looked in my wp config file and the current prefix is indeed wp_ When the prefix gets changed, do the system duplicate all the existing tables with the new prefix? If that’s the case, can I drop all the other different prefix tables?

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Support hjogiupdraftplus

    (@hjogiupdraftplus)

    Hi @mdc2957

    If you deactivate or delete the AIOS plugin it does not change prefix back to wp_.

    It will keep the changed table prefix in database and in wp-config.php.

    Do you have any staging plugin installed it might be the reason or the website copied from another place it can also be the reason.

    Yes, please take the backup of the whole DB and keep tables with $table_prefix as per wp-config.php and drop all other tables.

    Regards

    Thread Starter MDC2957

    (@mdc2957)

    Ah yes, I did have staging set up via a backup plugin I was using (but no longer am as I had troubles with it), so that must be the reason. I Imagine that duplicate tables should have been deleted by that plugin when I removed the staging site, but as noted it was giving me issues. Thanks for the reminder, much appreciated.

    Plugin Support hjogiupdraftplus

    (@hjogiupdraftplus)

    Hi @mdc2957

    Ok,

    You’re welcome.

    Would you mind writing a quick five-star review on www.ads-software.com?

    https://www.ads-software.com/support/plugin/all-in-one-wp-security-and-firewall/reviews/#new-post

    Reviews also help others to make confident decisions about our plugin.

    Thread Starter MDC2957

    (@mdc2957)

    I wouldn’t be able to rate the plugin as I did not end up using it, so nothing negative, nor positive to say about the plugin itself. But I appreciate your prompt reply here on the support forum.

    Plugin Support hjogiupdraftplus

    (@hjogiupdraftplus)

    Ok, No problem.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Database Prefix Question’ is closed to new replies.