Did I screw up? Installed multiple copies of WP with same table prefix

  • Floyd3

    (@floyd3)


    12 years, 2 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?

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

    (@govpatel)

    12 years, 2 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

    Thread Starter Floyd3

    (@floyd3)

    12 years, 2 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?

    hdcrunch

    (@hdcrunch)

    12 years, 2 months ago

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

    govpatel

    (@govpatel)

    12 years, 2 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

    Thread Starter Floyd3

    (@floyd3)

    12 years, 2 months ago

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

    Cheers.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Did I screw up? Installed multiple copies of WP with same table prefix’ is closed to new replies.