• When I set up a website for my wife to do a blog, somehow I managed to create 3 databases. How can I combine these into one?

    When I update WordPress all three update, so I presume they are all used.

    I am trying to tidy up the site, so would like to only have one database to deal with.

    Thanks

    Bill

Viewing 5 replies - 1 through 5 (of 5 total)
  • When I update WordPress all three update, so I presume they are all used.

    Sorry, that sounds a bit odd to hear all three database get updated.
    Because If you know in the config file you define only single database for site.

    • This reply was modified 3 years, 8 months ago by deepvyas.
    • This reply was modified 3 years, 8 months ago by deepvyas.
    • This reply was modified 3 years, 8 months ago by deepvyas.
    Thread Starter bklewes

    (@bklewes)

    Deepvyas,
    Well WP Manager by Softaculous shows three installs and if I check the database settings they are different numbers.

    So are two of the DBs just on the system, but not being used by the website?

    lisa

    (@contentiskey)

    -are you able to see the database settings in your website’s wp-config.php file? does the database name match one of the databases in your webhosting account?
    -do the other 2 databases have any content in the tables that corresponds to your active website?
    -if you are not sure how to find WP-config.php file, please contact your webhost support for specific instructions.
    IMPORTANT: before deleting or combining any database(s) — be sure to create and save a complete backup copy of the all database(s).

    Thread Starter bklewes

    (@bklewes)

    Lisa,

    Thanks.
    wp-config shows:
    /** MySQL database username */
    define(‘DB_USER’, ‘bn9couk_wp124’);

    wp124 runs right through from 2013 to today.

    Other two only 2013-2015.
    So as wp-config doesn’t mention other two databases I presume they can go.

    Even with a complete backup of all DBs, still not sure easiest way to remove the surplus databases.

    wp-config shows:

    First, No need to share wp-config details here.

    not sure easiest way to remove the surplus databases.

    On your hosting login goto MySQL Databases and delete unused one from the list.

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

The topic ‘Multiple databases’ is closed to new replies.