Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
By Dubber Dan on
I'm hoping to set up Drupal for our company intranet but have hit a snag when trying to gett everything installed. We've got a servers that is already running MySQL for another program so I was hoping to use that. I've managed to install Apache and PHP onto it and just needed to create a new database for Drupal on the exisiting install of MySQL.
The snag is that MySQL was installed by a 3rd party to run a specific application and I've asked them for the admin details so I can set up another database within it, but they won't give them to me as they say they don't want another database set up. So it appears I'm stuck!!
I've got another server but that is business critical so I'm not happy to run extra things on that, and I've got a mail server but all the advice I read is not to install MySQL or Exchange on the same box so that's ruled out. I suppose if worst comes to it, I could always try setting it all up on a high powered pc, but then I don't get the security of RAID or backup devices.
Is it possible to have a second installation of MySQL on one server, that works independantly of the other? Or what other suggestons do folks have?
Comments
Drupal
Please send me Acidfree,AJAXSpellCheck,Bannar,Blog Theme
codings and how to configure in the Drupal Software.
?
Sorry? You can download Acidfree and other modules yourself. How to configure Drupal is explained in the handbook. If you have specific issues or questions you can ask in the forum after checking the handbook and searching the site.
--
Tips for posting to the forums.
When your problem is solved, please post a follow-up to the thread you started.
Yes
Apparently, see this story.
--
Tips for posting to the forums.
When your problem is solved, please post a follow-up to the thread you started.
DBMS on another host
This is not a answer to your question but just wanted to point out that you can have your database and Drupal installations (i.e. the folders and files) on different machines.
As I said this is NOT an asnwer to your question but just might prove useful for you. Have a nice day.
My Drupal-powered Blog: ThoughtfulChaos
Heine - thanks for the link,
Heine - thanks for the link, so it is possible, but I'm still a bit in the blind as to how to go about it, having never set up MySQL before. But I've been given this link on the MySQL website from someone on Experts Exchange , so hopefully I'll get there!!!
Varun V Nair - I'll bear that in mind if I get lost when setting upa 2nd MySQL server on the one machine ;-)
One more thought. Would it
One more thought. Would it be best to go with MySQL 5.0 now it's out, or go with 4.1.16??
Do not install MySQL on the
Do not install MySQL on the same box as your Exchange server. You do not want to troubleshoot Exchange.
If you own the other box, then I do not know why the 3rd party cannot grant you access to your own server.
If you have to go with a high powered workstation, just setup an automated backup solution that saves the database dump and webfiles directory off the box to a different server.
-sp
---------
Test site, always start with a test site.
Drupal Best Practices Guide -|- Black Mountain
-Steven Peck
---------
Test site, always start with a test site.
Drupal Best Practices Guide
Don't worry, I wasn't going
Don't worry, I wasn't going to set it up on the exchange box as I know MySQL/SQL and exchange are not happy bed-fellows.
I've got admin access to the server but it's the admin details to MySQL they are not happy to give me. I explained that MySQL is perfectly happy running 2 databases etc, but they are just not happy to let me do it. If I insist then they'll waive liability if anything happens on MySQL
Waive Liability?
I am not a MySQL expert, but wouldn't the logs show where the errors with MySQL occurred so that they would know whether or not they needed to 'fix' something and to identify where the error originated?
As a buisness owner, I find their reply unusual and curious. I would have thought they would say, "We would be happy to handle that installation for $xxx and maintain it for $xxx.." Maybe you just need to ask them that whether they would be willing to install it and maintain it for you. If not, maybe you should shop for another firm to handle your MySQL database(s)?
I am using a PII 400 to run mepis (linux). I have mysql, etc. up and running, and the box cost me nothing since it was a 'throwaway." Just a thought...
C
It's not a company that
It's not a company that handles our MySQL databases but one that has supplied a specific bit of software for us that runs on MySQL, so it's not like I could ask them to manage this it for Drupal too.
But yes, you're probably right that it would show in the logs (but I'm a total novice having never yet installed MySQL).