Installation has extra mysql tables

  • Resolved Andrzej

    (@awoz)


    12 years, 8 months ago

    I’m unsure when this first happened, but my site database has extra tables that are named similar to the default ‘wp_’ tables. The extra tables names have a 3 character prefix; nqk_options, nqk_posts…

    The nqk_options table appears to have default? installation values. While the wp_options table has valid live site values. The table_prefix value at wp-config.php = ‘wp_’

    Are these extra tables remnants of the default WP installation process or from the one-click installer supplied by my hoster? I have deleted these extra tables with no adverse affect on site operations.

    Thanks for your thoughts about this.

Viewing 4 replies - 1 through 4 (of 4 total)
  • esmi

    (@esmi)

    12 years, 8 months ago

    WordPress doesn’t install any extra tables like that, so I’m afraid I don’t have any idea where they came from.

    Thread Starter Andrzej

    (@awoz)

    12 years, 8 months ago

    esmi, Thanks for that clarification. I will investigate the hoster’s one-click installer and will report back what I find.

    -cheers

    Thread Starter Andrzej

    (@awoz)

    12 years, 8 months ago

    It appears that some one-click installers replace the ‘wp_’ table prefix with any number of character patterns. In my case, I used a one-click install as a baseline for a site restore. A subsequent dbase import from backup merged in valid wp_ tables, to produce the stale nqk_ tables.

    esmi

    (@esmi)

    12 years, 8 months ago

    It appears that some one-click installers replace the ‘wp_’ table prefix with any number of character patterns.

    Yep. I’ve come across that with (eg) a Softaculous install. But I thought you only had a few of these “odd” tables – not a complete set. Hence the confusion. Glad to hear that you got to the bottom of it.

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Installation has extra mysql tables’ is closed to new replies.