Hi. I have 3 different .com site's, all running WordPress on the same hosting account.
All 3 websites are working properly. It's only just now that I noticed I may have made a mistake: All 3 have the same table prefix of "wp_".
I was in the process of backing up 1 of the 3 websites via phpMyAdmin, when I noticed I couldn't find the specific site I was looking to backup.
Did all 3 sites somehow get put under the same wp_ table/database? Would this not cause an error when installing?
Should I just backup the wp_ databases to backup all 3 sites at once?
I thought I had given the sites unique prefixes when I installed, but I downloaded the wp-config file to check, and it says:
But I don't see the uniquename table, and further down the wp-config file, it says:
$table_prefix = 'wp_';
Also, it says "You can have multiple installations in one database if you give each a unique prefix. Only numbers, letters, and underscores please!" But it looks like I failed to do it to that part, and only did it to the define db name part.
Any ideas how to fix, or if it's OK to leave it as is, since everything seems to be working properly, and still backup? If so, how do I just backup just the site database I'm looking for?