Copy a SQL database

Overview

This guide will walk you through the procedure of copying a SQL database between environments using the Jelastic GUI.

Export the database

1. Open up phpMyAdmin on the source environment by clicking the icon as shown below

2. Export the database by first choosing the database to the left, in our case example, and then click on Export on the top navigation bar. Make sure to check the box where it says “Save on server in the directory /var/lib/jelastic/phpMyAdmin/save” and then click “Go”.

4. Now you have exported the database.

Share folder between environments

1. Find the configuration wrench on the SQL Databases source node.

2. Go to folder /var/lib/jelastic/phpMyAdmin. Click the cogwheel on the save folder as shown on the image below and choose Export

3. Make sure to choose the correct target container where your target SQL database is at.

4. Make sure to use the path /var/lib/jelastic/phpMyAdmin/upload

5. Now the target environment should have access to a folder on the source environment.

Import the database

1. Open up phpMyAdmin on the target environment.

2. In order to import the database, we need to create it beforehand as shown below.

3. Since you have mounted the source environments save folder to the target environments upload folder, you have access to the sql files there. So click on “Select from the web server upload directory /var/lib/jelastic/phpMyAdmin/upload/” and click Go to import it.

4. At this time, you should have a successful import.

Cleanup - unmount the shared folder

1. When you are done exporting and importing databases, you should remove the shared folder. Click on the wrench on the target environments database node.

2. You should see the upload folder in your Mount Points folder below to the left. Click the cogwheel and unmount, as shown in the image below

You should be all set!