Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.


Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
  • Search
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Brand Logo

Cloudron Forum

Apps | Demo | Docs | Install
  1. Cloudron Forum
  2. LAMP
  3. Adding a second db to php 7.4 app

Adding a second db to php 7.4 app

Scheduled Pinned Locked Moved Solved LAMP
mysqlmigrationdrupalcivicrm
2 Posts 2 Posters 610 Views 2 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • ShaiS Offline
    ShaiS Offline
    Shai
    wrote on last edited by
    #1

    I have a couple of drupal/civicrm sites that I'm migrating to one of my Cloudrons. I will be using the php 7.4 app. The typical setup is for Drupal and CiviCRM to each have their own database.

    This snippet below is from the Cloudron php 7.4 docs; I can infer that it is possible to create more than one database from the comment "only set when using a single database, see below." However, later in the documentation there are no references that I found to adding another database. In both phpMyAdmin and via the MySQL terminal it is not possible to create a second database.

    It is possible to run Drupal and CiviCRM on the same database using table prefixes, but I'd prefer to have two databases for a bunch of reasons.

    Is it possible to create another database? And if so, how do I do it?

    CLOUDRON_MYSQL_URL=            # the mysql url (only set when using a single database, see below)
    CLOUDRON_MYSQL_USERNAME=       # username
    CLOUDRON_MYSQL_PASSWORD=       # password
    CLOUDRON_MYSQL_HOST=           # server IP/hostname
    CLOUDRON_MYSQL_PORT=           # server port
    CLOUDRON_MYSQL_DATABASE=       # database name (only set when using a single database, see below)
    
    girishG 1 Reply Last reply
    0
    • ShaiS Shai

      I have a couple of drupal/civicrm sites that I'm migrating to one of my Cloudrons. I will be using the php 7.4 app. The typical setup is for Drupal and CiviCRM to each have their own database.

      This snippet below is from the Cloudron php 7.4 docs; I can infer that it is possible to create more than one database from the comment "only set when using a single database, see below." However, later in the documentation there are no references that I found to adding another database. In both phpMyAdmin and via the MySQL terminal it is not possible to create a second database.

      It is possible to run Drupal and CiviCRM on the same database using table prefixes, but I'd prefer to have two databases for a bunch of reasons.

      Is it possible to create another database? And if so, how do I do it?

      CLOUDRON_MYSQL_URL=            # the mysql url (only set when using a single database, see below)
      CLOUDRON_MYSQL_USERNAME=       # username
      CLOUDRON_MYSQL_PASSWORD=       # password
      CLOUDRON_MYSQL_HOST=           # server IP/hostname
      CLOUDRON_MYSQL_PORT=           # server port
      CLOUDRON_MYSQL_DATABASE=       # database name (only set when using a single database, see below)
      
      girishG Offline
      girishG Offline
      girish
      Staff
      wrote on last edited by
      #2

      @shai you have to build a custom app, please see this guide https://docs.cloudron.io/guides/multiple-databases-lamp/

      1 Reply Last reply
      1
      Reply
      • Reply as topic
      Log in to reply
      • Oldest to Newest
      • Newest to Oldest
      • Most Votes


      • Login

      • Don't have an account? Register

      • Login or register to search.
      • First post
        Last post
      0
      • Categories
      • Recent
      • Tags
      • Popular
      • Bookmarks
      • Search