Does destination site use same database name?

  • Resolved RJaggers

    (@rjaggers)


    5 years, 9 months ago

    My wordpress website is hosted by a company that allows unlimited add-on domains!

    I have successfully added new domain names in the past, installed WordPress, and built up websites!

    I am in the process of completely rewriting the main/host/primary website.

    I have decided that I want to use a different domain name and I want to migrate my work.

    Primary URL = ABCInc (has current work-in-progress)
    Add-on Domain #1 = MySCC (Previously successful add-on domain WP instance)
    Add-on Domain #2 = MyWW (Proposed destination)

    I have successfully created a migration file from ABCInc, and used the search-and-replace feature to change ABCInc to MySCC.

    I have not installed the migration file.

    Issue #1 – The migration file contains some 7,000 files, so I suspect it included all the files for MySCC because it is a sub-directory under ABCInc. My solution: use the cPanel file manager to clean those out.

    Issue #2 – The SQL database is shared across all the add-on domains. The SQL database in the migration file is for the ABCInc installation.

    Question: When I apply the migration file to MyWW, will the new WP instance use the same data base name used by ABCInc? Will that cause conflict in the settings table when both ABCInc and MyWW access the database?

    One possible course of action would be to restore to separate cPanel WordPress installation, clean out the extraneous files and rename the database, and then create a new migration file that I would upload to the add-on domain.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Yani

    (@yaniiliev)

    Question: When I apply the migration file to MyWW, will the new WP instance use the same data base name used by ABCInc? Will that cause conflict in the settings table when both ABCInc and MyWW access the database?

    When you install WordPress, it prompts you for 2 things:
    1. Database name
    2. Database prefix

    You can install multiple WordPress installs into 1 database as long as you keep the prefix different. I, however, do not recommend you this. There are plugins who use custom tables that are not prefixed properly and you will run into issues if you do this.

    Back to your question, the plugin will use the database and prefix that the WordPress site has in its wp-config.php file.

    Example:
    Site 1 has database named site_1. You export site 1 into a backup.wpress

    Site 2 has a database named site_2. You import backup.wpress. The database that will beused is site_2. After import, site_2 will contain the same data as site_1.

    Thread Starter RJaggers

    (@rjaggers)

    Thank you!

    My take-away is to not worry about it ~ because ~ site_2 will use a database created and named during the 2nd WP installation. Site_1 data will be restored into the site_2 database.

    Plugin Author Yani

    (@yaniiliev)

    Exactly. You are welcome.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Does destination site use same database name?’ is closed to new replies.