Cloud IDE
Managing databases in Cloud IDE
When you pull your Cloud Platform application in Cloud IDE, the MySQL data is stored in the /home/ide/mysql-data directory. Log files can be viewed in the /var/log/mysql directory.
The provided version of MySQL runs on the port 3306 and has a default database with the following details:
drupaldrupaldrupalIf you use the Acquia require line, your application is automatically connected to the Cloud IDE database.
drupal database and a drupal2 database, which is primarily intended to perform Drupal migrations through Acquia Migrate Accelerate.Cloud IDE comes with a 60GB disk. Your code, database, and files coreside on the same disk, and you need to factor this when importing your application. Also, when you pull your database to the IDE, the database is stored on the disk as a flat file until it is fully imported in the MySQL engine, thus temporarily doubling the size on the disk.
For example, if you have a 20GB Drupal files directory and you try to import a 20GB database, consider the total disk space used on the disk is temporarily 60GB, and will cause the import to fail because you will max out the total disk allocation.
You can easily manage databases by using either of the following ways:
To manage your Cloud IDE databases with the MySQL command-line client:
Connect to the MySQL command-line client with the credentials provided in the preceding section.
ide:~/project (main) $ mysql -u drupal -pdrupal -h localhost
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.34 MySQL Community Server (GPL)
Copyright (c) 2000, 2021, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>Cloud IDE comes preconfigured with adminer, which is a lightweight and secure one-file database management tool written in PHP.
To manage your Cloud IDE database using a visual database editor:
In the Cloud IDE menu bar, select Manage Drupal application and double-click Open Database Editor. If you click the Open Database Editor option once, you are redirected to your Drupal application instead.
The system displays a new window with your database credentials pre-populated.
In the right content pane, edit data as shown on the following screen:
You can change MySQL options and variables by creating custom configuration files in the /home/ide/configs/mysql/ directory. After creating or modifying the MySQL configuration file, restart the database service by running the following command:
acli ide:service-restart mysqlTo import your local example.sql file:
To push a database from IDE to Cloud Platform, run the acli push:database command in the IDE terminal and follow the prompts:
My IDE:~/project (master) $ acli push:database
Using Cloud Application myapp
Choose a Cloud Platform environment [Dev, dev (vcs: master)]:
[0] Dev, dev (vcs: master)
[1] Next, next (vcs: tags/2021-02-17)
[2] RA, ra (vcs: tags/2021-02-17)
[3] Stage, test (vcs: test_branch)
> 0
! [NOTE] This is a multisite application. Drupal will load the default site unlessyou have you've configured sites.php for this
! environment: https://docs.acquia.com/cloud-platform/develop/drupal/multisite/
Choose a database [myapp (default)]:
[0] mysiteDB1
[1] myDefualtDB (default)
> 0
Overwrite the mysiteDB1 database on dev with a copy of the database from the current machine? (yes/no) [yes]:
> yes
If this content did not answer your questions, try searching or contacting our support team for further assistance.
If this content did not answer your questions, try searching or contacting our support team for further assistance.
Cloud IDE