duplicate database tables

  • Resolved jaimehotdish

    (@jaimehotdish)


    16 years, 11 months ago

    A few days ago, my blog stopped connecting to the database, after running normally for many months. I’ve looked at the database, and it appears that there is a set of duplicate tables, one that contains all my data and one that doesn’t. For instance, it contains these two tables:

    wp_users
    wp_myblognameusers

    Where wp_users has no records and wp_myblognameusers contains all my data. Did my host somehow cause these duplicates, or is this normal? I just can’t seem to figure out why there isn’t a connection (all info in my config file is correct).

Viewing 2 replies - 1 through 2 (of 2 total)
  • MichaelH

    (@michaelh)

    16 years, 11 months ago

    ‘users’ is the table holding your WordPress users. ‘wp_’ is the table prefix as is defined by the $table_prefix variable in your wp-config.php.

    So at one time guessing you had $table_prefix = ‘wp_myblogname’ and now you have $table_prefix = ‘wp_’

    Thread Starter jaimehotdish

    (@jaimehotdish)

    16 years, 11 months ago

    awesome – that fixed it. thank u!

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

The topic ‘duplicate database tables’ is closed to new replies.