Import and Export Dump Files to MySQL/MariaDB

Dump Import to MySQL

1. Create a new server instance using any desktop client for MySQL/MariaDB (we use MySQL Workbench as an example).

MySQL workbench

2. Specify your host machine (just paste your public IP into the address field) and click Next.

remote host public IP

3. Set the database connection values: IP address, port number, username and password (when you created the environment, Jelastic sent you an email with credentials to the database).

database connection credentials

4. Then your database connection will be tested for a couple of minutes.

testing database connection

5. Set the type of remote management you want to use.

do not use remote management

6. Enter the name for your server instance.

server instance name

7. You can see that your server instance is successfully created.

database connection established

8. Open your instance and pick Data Import/Restore and choose the dump you want to import.

data import/restore

The import process can take several minutes.

start import

9. Go back to Jelastic dashboard and open MySQL (MariaDB) in a browser. Using the credentials, which Jelastic sent you, sign in into admin page. Select test, click on example and you’ll see your imported dump.

phpMyAdmin imported dump

Dump Export from MySQL/MariaDB

1. Open the server instance you have created earlier in your desktop client and pick Data Export and select database objects to export. Specify the path to the directory, in which you want to export the dump.

data export

2. The export process can take several minutes, depending on the size of exported data.

start export

Your dump file will be in the directory, the path to which you have specified.

What’s next?