Importing a database dump file into a site factory site

In some cases, you may have a Site Factory site that you want to import a database into that you may have from another environment, application, or a Drupal site that you have into an Acquia Cloud Site Factory site. There is not a simple drag and drop method from the Acquia Cloud UI, however you can import a database into a site from a database dump file using Drush.

Here are some steps that you can follow in this case:

1. Create the database dump file, for steps on Acquia Cloud follow these instructions: Creating a database dump file.
2. Place the file on to your server and in a location that you can point to such as /mnt/tmp/[sitename]/.
3. Navigate to your docroot location (/var/www/html/sitename.env/docroot) and then run the subsequent Drush command against the site that you want to import the database into, making sure to note the location of the file that you created/imported in Step 2. Drush commands for running a database import can be found here: Importing your database dump file.