SPECIAL OFFER: Only $59 for access to everything in OSTraining for 1 year! You save $85!  1
Join today and get access to 1,000's of books and videos. Learn WordPress, Drupal, Magento, Joomla and more! Sign up today!

Multtiple sites and the database

3 years 3 months ago #126015 by davidmcmurrey
Multtiple sites and the database was created by davidmcmurrey
I am creating four different directories in which I install Drupal. I'm wondering how I differentiate the database access for each of these four installations. Is there something about prefixes? Create a table for each?

I've had to leave an environment where I used cPanel, which enables me to give each installation a unique database name. My new environment does not use cPanel and, in the Drupal install, all I get is the raddio button for SQL Lite.

My new environment does have MySQL and phpMyAdmin

Help! -- David

Please Log in to join the conversation.

3 years 3 months ago #126017 by Nick
Replied by Nick on topic Multtiple sites and the database
Hi David,

Does the new server include support by the hosting company? If so, it's best to contact them and ask them how to create a separate database for each site, since it sounds like their hosting environment is unique.

Kind regards,
Nick

Follow us on Twitter - twitter.com/OSTraining
Like us on Facebook - facebook.com/ostraining

Please Log in to join the conversation.

3 years 3 months ago - 3 years 3 months ago #126018 by davidmcmurrey
Replied by davidmcmurrey on topic Multtiple sites and the database
Here is are clips from the setting.php

[removed by Nick for security reasons]

Please Log in to join the conversation.

3 years 3 months ago #126019 by davidmcmurrey
Replied by davidmcmurrey on topic Multtiple sites and the database
maybe that's it. I couldn't create new tables

Please Log in to join the conversation.

3 years 3 months ago #126020 by Nick
Replied by Nick on topic Multtiple sites and the database
Hi David,

I've gone ahead and removed the settings, since it would expose your database name, user, password, path, etc, which is a security concern since this is a publicly viewable forum. You can email us privately at support@ostraining.com at any time for sensitive information.

Hope this helps! Let us know if you have any questions and we'll be glad to answer.

Kind regards,
Nick

Follow us on Twitter - twitter.com/OSTraining
Like us on Facebook - facebook.com/ostraining

Please Log in to join the conversation.

3 years 3 months ago #126021 by davidmcmurrey
Replied by davidmcmurrey on topic Multtiple sites and the database
ooops -- thanks

Please Log in to join the conversation.

3 years 3 months ago - 3 years 3 months ago #126022 by Nick
Replied by Nick on topic Multtiple sites and the database
No problem! :)

Cheers,
Nick

p.s. please make sure you didn't miss my initial reply which was written at about the same time as your reply. Here's the link:
www.ostraining.com/support-forum/drupal-...the-database/#126017

Follow us on Twitter - twitter.com/OSTraining
Like us on Facebook - facebook.com/ostraining

Please Log in to join the conversation.

3 years 3 months ago #126027 by davidmcmurrey
Replied by davidmcmurrey on topic Multtiple sites and the database
Yes, I'm contacting them now

Please Log in to join the conversation.

3 years 3 months ago #126031 by Nick
Replied by Nick on topic Multtiple sites and the database
Great, thanks David! Let us know how it goes.

Cheers,
Nick

Follow us on Twitter - twitter.com/OSTraining
Like us on Facebook - facebook.com/ostraining

Please Log in to join the conversation.

3 years 3 months ago #126044 by Daniel Pickering
Replied by Daniel Pickering on topic Multtiple sites and the database
Hi David

davidmcmurrey wrote: My new environment does have MySQL and phpMyAdmin

Help! -- David


If you already have phpMyAdmin.
Open phpMyAdmin create a user for the site to be the master user.

For Drupal 7

Create a database. You don't need to add anything else just the database name. Now use the user name password and database name during installation.

For Drupal 8

If it is configured properly you don't need to create the database at all just the master user for that database. But you can create it if you want.

Thanks
Daniel

Please Log in to join the conversation.

3 years 3 months ago #126057 by davidmcmurrey
Replied by davidmcmurrey on topic Multtiple sites and the database
The problem is this: when I ran the Drupal install in a non-cPanel environment, the database setup page did not give the ability to set up a database name, user, password -- instead just a radio button for SQL Lite.

So I think I can go into settings.php and use the lines from an existing settings file that works. But then I need to import the zip of the database (that I made using the Backup & Migrate module). Not sure how I'm going to do that!

-- David

Please Log in to join the conversation.

3 years 3 months ago #126059 by Daniel Pickering
Replied by Daniel Pickering on topic Multtiple sites and the database
That sounds to me like your host is limiting the mysql.

You might have to contact them and ask them if you need do anything specifically.
The following user(s) said Thank You: davidmcmurrey

Please Log in to join the conversation.

3 years 3 months ago #126064 by davidmcmurrey
Replied by davidmcmurrey on topic Multtiple sites and the database
I did an am waiting. thanks

Please Log in to join the conversation.

3 years 3 months ago #126080 by Daniel Pickering
Replied by Daniel Pickering on topic Multtiple sites and the database
Great David let us know how you get on you could always connect to the mysql hosted elsewhere if it is going to be an issue with the hosting service but I prefer to avoid that personally.

Thanks
Daniel

Please Log in to join the conversation.

Join today and get access to 1,000's of books and videos. Learn WordPress, Drupal, Magento, Joomla and more! Sign up today!