>> If so, is there a way to determine which is database is in use and which one can be deleted? <<
Look at wp-config.php. It will tell you which database is in use and, if there are multiple sets of WP tables, the $table_prefix variable tells you which is the active set.
I was able to identify the database that is in use using the wp-config.php file as you suggested, thank you.
I can also see also a $table_prefix variable has been set.
I notice that in the database, there seem to be two versions of each table. One with the same prefix as is listed in the wp-config.php file and another set of (what seems to be) the same tables prefixed by a bunch of letters/numbers.
Is this typical?
Should I delete the second set of tables that are prefixed by the letters/numbers?
I am assuming this would leave the active tables only? Could this potentially improve performance/speed?
Thanks again for your help with this. I am not very familiar with databases so just want to be sure I am not going to make any major errors.
>> Should I delete the second set of tables that are prefixed by the letters/numbers? <<
Yes, but back them up first. (Select them and export them via PHPMYADMIN.)
It’s unlikely this will result in any noticeable difference in performance.
That’s great, thank you for confirming.