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


    Cloudron Forum

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular

    Solved Adding a second db to php 7.4 app

    LAMP
    mysql migration drupal civicrm
    2
    2
    178
    Loading More Posts
    • 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.
    • Shai
      Shai last edited by

      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)
      
      girish 1 Reply Last reply Reply Quote 0
      • girish
        girish Staff @Shai last edited by

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

        1 Reply Last reply Reply Quote 1
        • First post
          Last post
        Powered by NodeBB