Title: Does destination site use same database name?
Last modified: January 30, 2019

---

# Does destination site use same database name?

 *  Resolved [RJaggers](https://wordpress.org/support/users/rjaggers/)
 * (@rjaggers)
 * [7 years, 3 months ago](https://wordpress.org/support/topic/does-destination-site-use-same-database-name/)
 * 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](https://wordpress.org/support/users/yaniiliev/)
 * (@yaniiliev)
 * [7 years, 3 months ago](https://wordpress.org/support/topic/does-destination-site-use-same-database-name/#post-11148918)
 * > 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](https://wordpress.org/support/users/rjaggers/)
 * (@rjaggers)
 * [7 years, 3 months ago](https://wordpress.org/support/topic/does-destination-site-use-same-database-name/#post-11149390)
 * 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](https://wordpress.org/support/users/yaniiliev/)
 * (@yaniiliev)
 * [7 years, 3 months ago](https://wordpress.org/support/topic/does-destination-site-use-same-database-name/#post-11152105)
 * 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.

 * ![](https://ps.w.org/all-in-one-wp-migration/assets/icon-256x256.png?rev=2458334)
 * [All-in-One WP Migration and Backup](https://wordpress.org/plugins/all-in-one-wp-migration/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/all-in-one-wp-migration/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/all-in-one-wp-migration/)
 * [Active Topics](https://wordpress.org/support/plugin/all-in-one-wp-migration/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/all-in-one-wp-migration/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/all-in-one-wp-migration/reviews/)

## Tags

 * [add on domain](https://wordpress.org/support/topic-tag/add-on-domain/)

 * 3 replies
 * 2 participants
 * Last reply from: [Yani](https://wordpress.org/support/users/yaniiliev/)
 * Last activity: [7 years, 3 months ago](https://wordpress.org/support/topic/does-destination-site-use-same-database-name/#post-11152105)
 * Status: resolved