• Resolved I am GrokGPT

    (@kenfox101)


    Hello,

    This is gonna be my first question about WordPress database. I’m a complete newbie. Sometime in the past I installed all in one security and better security plugins to test them out and while doing so I did change the table prefix to something like k3722_commentsmeta, users etc. when there is already a table prefix made like tn11_commentsmeta, users etc. Now I see both of them in my database. Is it safe to delete the prefix made by the security plug-in?

Viewing 9 replies - 1 through 9 (of 9 total)
  • You should check the wp-config.php file first to see exactly which tables are actually being used by wordpress. This file is in the root folder. Edit the file with a text editor and look for this line where xxxx will be whatever prefix is actually being used.

    $table_prefix = 'xxxx_';

    So do not delete the tables using whatever prefix is found here.

    Thread Starter I am GrokGPT

    (@kenfox101)

    I see. Thank you soo much..I’ll check it now.

    Thread Starter I am GrokGPT

    (@kenfox101)

    The official prefix is the k3722_something. So is it safe to delete the other table prefix? My DB name and DB USER is called something like kind_t11. This is a different story right? Is there an impact if I delete the other prefix?

    Yes the DB name and DB USER (do not publish these here) are a different story.

    Have you taken a backup of your database? You should do that before you delete anything. Do you know how to do that and if something went wrong do you know how to do a restore?

    There are a number of plugins that will backup your database but they do not help you if you need to restore it. You have to know how to do it manually.

    It is probably safe to delete those duplicate tables. But I personally would do a backup before doing that. I’ll provide more info on backing up if you need it.

    Thread Starter I am GrokGPT

    (@kenfox101)

    Wow, Thank you so much for your help. You are much like my host Chris at LightningBase: very helpful. It’s just that I want to learn things myself. I know I can just Google my way around but since you are ready to lend a hand. Is backing up done tru a plug-in or tru my cpanel? And the restore as well, how to go about it! I am indebted to you.

    You can do it either way.

    Use PHP Admin (In cpanel)
    or search the wordpress plugin site for WP Database Backup. It has been around for a long time.

    Duplicator is a great (free) plugin that backs up up your whole site including the database. It is sometimes a bit tricky getting it to work if permissions are not correct.

    Going off line now so won’t be able to answer more questions until later.

    Thread Starter I am GrokGPT

    (@kenfox101)

    LOL! yeah I was supposed to ask you if you’re not going to go to bed. But thank so much. See you around.

    Thread Starter I am GrokGPT

    (@kenfox101)

    I’ve removed it-backed the DB up and everything is now fine.

    Glad to hear you had no problems.

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Please help-Newbie here! WP Prefix: Duplicate Tables?’ is closed to new replies.