Two Active Databases for WP Single Site

  • Resolved Roger Watts

    (@ra1953watts)


    1 year, 5 months ago

    My wp-config.php shows the expected connection details to DB_Correct.
    It does not show any details about another DB on my site DB_Wrong.
    I am using MemberPress plugin linked to Kit (was Convertkit).
    MemberPress registration appends new user records to wp_users in DB_Correct.
    MemberPress mepr_ tables are all in DB_Wrong and contain the correct records.
    From a WP admin pov everything appears ok but little unexplained niggles have occured from time to time.

    Browsing the DB tables/records confirms that both databases are being used by the same application.

    I am concerned as to whether my backups will have the required integrity if I really do need to restore the site.
    Should I be looking to merge the DBs?

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter Roger Watts

    (@ra1953watts)

    1 year, 5 months ago

    A further thought – it is possible I have used a test-site where hosting was using MariaDB at some point while the production site uses mySQL.

    Moderator threadi

    (@threadi)

    1 year, 5 months ago

    That would be quite unusual, but it is theoretically possible that a plugin you are using opens its own database connection and therefore some data is in a different database. However, you would have to have deliberately set this up, as a plugin cannot simply guess access data for this.

    My recommendation would be to check whether any plugin provides the necessary configuration for this. If you have already noticed MemberPress as an anomaly, it is best to contact their support: https://memberpress.com – as this is a commercial product, they cannot help you further here in the forum.

    cartpauj

    (@cartpauj)

    1 year, 5 months ago

    MemberPress does not use a separate database or any outside database connections. All queries are run through standard $wpdb class.

    Thread Starter Roger Watts

    (@ra1953watts)

    1 year, 5 months ago

    Thanks for the comments.

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

The topic ‘Two Active Databases for WP Single Site’ is closed to new replies.