I am working on a project based on Magento Commerce Cloud.
Can anyone please guide on how can i access DB of staging branch.
Thanks!
If your goal is to access it using some type of GUI client, you could accomplish this by opening an ssh tunnel using the magento-cloud utility, similar to the above answer:
magento-cloud tunnel:open --project=<PROJECT_ID> --environment=staging
Then run the command magento-cloud tunnel:info to get the appropriate credentials to input into whatever utility you may be trying to use.
[edited] syntax error on "tunnel:open"
-
Can you configure something like dbeaver to connect to mysql across a ssh tunnel? – Dominic Xigen Jun 11 '19 at 0:25
-
I'm not familiar with dbeaver but once the tunnel is open (via the cli tool), any client should be able to connect through it.
magento-cloud tunnel:infowill give the connection information which would have a port on localhost to connect to as well as a username and password if it is staging or production. – Billy Gilbert Jun 11 '19 at 16:15 -
should be
magento-cloud tunnel:open --project=<PROJECT_ID> --environment=stagingbut of course one syntax error requires 10 characters to be edited in order to improve the answer. – MagentoAaron Apr 22 '20 at 12:17
Try:
SSH to the Integration environment.
magento-cloud ssh
Connect to the database.
mysql -h <db-host> -P <db-port> -p -u <db-user> <db-name>
-
-
I think no, as this is managed by aws. I'll update if I got any solution in future – Saphal Jha May 21 '19 at 14:11
I use dbeaver software. It gives you a visual editor
Once the tunnel is open (via the cli tool), any client should be able to connect through it.
magento-cloud tunnel:infowill give the connection information
Connect to MySQL server in Dbeaver
Create new connection button
Select MySQL
In the ‘General’ window this is ‘User name’ and ‘Password’ for databse
User name: MYSQL user name you want to use
Password: Password of the MYSQL user
When you have already filled the required fields click to Next button. After it the second important window appears:
First of all click to the checkbox icon ‘Use SSH Tunnel’ to gain access to the settings. Fields you have to fill in the right way:
HOST/IP: IP of details shown by magento command
User Name: ssh connection user name you want to use as tunnel to MySQL connection
Authentication Method: ‘Public Key’
Private Key: Path of the private key on your PC
Password: ssh tunnel connection password
If everything has configured correctly when you click to ‘Test Connection’ a confirmation message box will appear.
answered Jun 11 '19 at 21:38
You can also use the ece-tools package for taking a db dump:
/vendor/bin/ece-tools db-dump
