How To Share A DB Between Sites

**LouiseLloyd** · 09-14-2017, 08:41 PM

Originally posted by PamWinterReturns

The db needs to be shared on both sites

Have both sites use the same db!?

**freecartoonporn** · 09-15-2017, 08:21 AM

set up one DB.

set up two sites using same DB.

**HairyChick** · 09-15-2017, 04:11 PM

Set up one db? Seems too simple. Build site A, then configure site B with same credentials as site A!?

If so, how will B update ?? Don't I need to manually tell A you update B?
? ?

**Barry-xlovecam** · 09-15-2017, 04:49 PM

If the domains are on the same server they can use the same database logins as localhost.
Alternatively, each domain could be a separate database user (sharing the same database).

Each database has users with grant privileges given (configured) by the database root.
root@localhost

Code:

mysql -u root -p
Enter password:*******

CREATE USER 'user'@'localhost' IDENTIFIED BY 'password';
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
ON `databasesprefix%`.* TO user@localhost IDENTIFIED BY 'password';

FLUSH PRIVILEGES;

A database user (MySQL) can have a difference user name and password than the UNIX (webroot user) -- they probably should.

You can allow database remote connections restricted only to authorized static IPs also.

**Barry-xlovecam** · 09-15-2017, 04:51 PM

Originally posted by PamWinterReturns

Set up one db? Seems too simple. Build site A, then configure site B with same credentials as site A!?

If so, how will B update ?? Don't I need to manually tell A you update B?
? ?

Depends on A and B's write privileges to the shared database.

**TFCash** · 09-15-2017, 05:41 PM

Pam -

you need to specify, are you talking about a custom script that is running the two sites, or are you using wordpress like all your other posts talk about ???

If it's a custom script, then they should be able to share the same database with a few code changes. If your talking about using wordpress for two domains from the same database, it can be done, but it's a lot more headaches than it's worth. Better to just have siteB feed off of siteA with a plugin like https://wordpress.org/plugins/feedwordpress/

**wankawonk** · 09-15-2017, 05:58 PM

easy to do if you have tech skills but if you're fucking around with scripts that other people wrote and you don't understand how they work it's gonna be hard to figure out, and you probably won't find usable technical help on gfy

**brandonstills** · 09-15-2017, 06:20 PM

When you specify which database to use just specify the connection info to the database.

Typically connection info consists of:

- hostname or IP address (defaults to localhost usually)
- port (usually just leave at default)
- database name (you choose this during setup typically)
- username / password

**Ferus** · 09-15-2017, 11:00 PM

- Set the sites up individually
- have a developer build you a script that migrates the data from selected tabels in the database, to the new database
- Have a developer set up a script that replicates selected mediafolders (uploads and media)

Only migrate selected tabels (content related) and media/upload folders.

If you replicate eveything, it will be a pain to maintain in regards to uploads, updates and security

**TACNet** · 09-17-2017, 05:23 PM

Originally posted by PamWinterReturns

Set up one db? Seems too simple. Build site A, then configure site B with same credentials as site A!?

If so, how will B update ?? Don't I need to manually tell A you update B?
? ?

We been doing this for years. One DB server backend that updates multiple sites across multiple servers

Obviously all the sites need to connect to the db server which can be done using localhost (if everything is one one server) or you can grant access by IP address for a multi server environment

Then simply use a script (eg PHP, Perl etc) to produce your pages on-the-fly so any changes are instantly reflected accross all sites

If you have a high traffic page (eg your index page) then you may want to have a cron script update that page say once every hour rather than on-the-fly as it can overload the db server.

How To Share A DB Between Sites

Tech How To Share A DB Between Sites

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment