WordPress.org

1. Floyd3
   Member
   Posted 3 months ago #

   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:

   define('DB_NAME', 'uniquenamewp_hostingacctname');

   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?

2. govpatel
   Member
   Posted 3 months ago #

   If this three separate databases it does not matter and since you have wp_ in config files that is prefix used you have unique database names for each install.
   It is when you have one database for three installs you will need separate prefix

3. Floyd3
   Member
   Posted 3 months ago #

   OK thanks govpatel, so if I understand correctly, I need to download the wp_ tables in phpMyAdmin and it will include all 3 websites WordPress backups?

4. hdcrunch
   Member
   Posted 3 months ago #

   You will need to download the wp_tables in each individual database. Your phpMyAdmin should show all 3 WordPress databases in it.

5. govpatel
   Member
   Posted 3 months ago #

   If you install using install script wp_ is default table while if you install manually you can change wp_ to what ever you want when creating wp-config.php file.

   Now that you have database tables created the only way you can change them is to change each table using Sql tab for example
   RENAME table wp_commentmeta TO newprefix_commentmeta;

   and change wp_config.php with same preifix

6. Floyd3
   Member
   Posted 3 months ago #

   Thanks you guys, found it and was able to download. :)

   Cheers.

Reply

You must log in to post.