2

How to dump the database to local system from Magento Cloud server with Magento 2 Commerce. I have only access to the ssh but that ssh user doesn't have write permission into the server. So by any how I need to download the database to the local system.

I have also tried to run the below command in my local system:

mysqldump -h hostname -u username -p dbname > dbname.sql

Hostname I used same as ssh host because I found 127.0.0.1 as db host on app/etc/env.php. But unfortunately it doesn't help.

I have checked this Magento 2 Commerce cloud database export but I dont know how to use this?

Is ece-tools db-dump already available in Magento cloud? Or we need to install it? If I need to install it then I cannot do this as there is no write permission is there in the server. I can only use git.

Is there any other way to do this Or How can I achieve this?

5
  1. Install magento-cloud cli

  2. Get a project and environment with the magento-cloud cli

  3. Run command to go into the current environment, dump the file, and then download it to your local computer

    • magento-cloud db:dump
| improve this answer | |
  • This is very bad idea, as magento-cloud dump also exports the views with original owner, so access to most of tables will be non accessible. BTW Magento does not reccomend using it on a cloud see support.magento.com/hc/en-us/articles/… – PassTeT Sep 18 at 7:41
2

ece-tools is available in magneto 2 . You can just refer link https://devdocs.magento.com/cloud/reference/ece-tools-reference.html

| improve this answer | |
0

Like @Carlos Reynosa said, it worked.

While installing magento-cloud cli through git bash, I got the error saying

stdin is not a tty

curl: (23) Failed writing body (343 != 7113)

then I tried the following to install magento-cloud in local

$ curl -sS https://accounts.magento.cloud/cli/installer -o cli-installer.php

$ php cli-installer.php
  1. Get into appropriate project and environment
  2. Run the command magento-cloud db:dump
| improve this answer | |
0

just install magento cloud cli and then

magento-cloud db:dump
| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.