Import and Export Dump Files to MySQL

A. Dump import to MySQL

  • Create a new server instance using any desktop client for MySQL (we use MySQL Workbench as an example). dump import export mariadb Снимок4

  • Specify your host machine (just paste your Public IP into the address field) and click Next. dump import export mariadb specify most machine

  • 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). dump import export mariadb set db connection

  • Then your database connection will be tested for a couple of minutes. phpmyadmin port number

  • Set the type of remote management you want to use. dump import export mariadb Снимок8

  • Enter the name for your server instance. dump import export mariadb Снимок9

  • You can see that your server instance is successfully created. dump import export mariadb Снимок10

  • Open your instance and pick Data Import/Restore and choose the dump you want to import. dump import export mariadb Снимок11

The import process can take several minutes. dump import export mariadb Снимок12

  • Go back to Jelastic dashboard and open MySQL 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. dump import export mariadb Снимок13

B. Dump export from MySQL

  • 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. dump import export mariadb Снимок14

  • The export process can take several minutes, depending on the size of exported data. dump import export mariadb Снимок15

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

What’s next?