Changing Table Prefix for multiple sites, single Database

  • Dr Wippit

    (@dr-wippit)


    15 years, 4 months ago

    I am running into some problems because I have two WordPress installations on the same database, and I did not realize I needed to change the table prefix in the second installation. I am wondering if there is away I can remedy this. I know just changing the table prefix in the wp-config file is not enough, I would need to make changes in the database as well, however I don’t want to lose the first site either. Is there a way I can get these two sites separated in the database without losing anything, and/or can I add a new database and direct the second site to the new database without losing anything? I really can’t have this site down for more than a minute or two if I can help it…..

Viewing 4 replies - 1 through 4 (of 4 total)
  • esmi

    (@esmi)

    15 years, 4 months ago

    Did the first site have any content? If so, do you have a recent database backup?

    Thread Starter Dr Wippit

    (@dr-wippit)

    15 years, 4 months ago

    Yes I’m trying to keep both sites going with the least amount of downtime/rebuild. I don’t have a recent database back up but I can certainly make one. Maybe I can back up the database and import that back up into a new database?

    Thanks!

    esmi

    (@esmi)

    15 years, 4 months ago

    You need a backup from before the second install.

    Thread Starter Dr Wippit

    (@dr-wippit)

    15 years, 4 months ago

    It’s too late for that if I never made one isn’t it?

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

The topic ‘Changing Table Prefix for multiple sites, single Database’ is closed to new replies.

Tags