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 to mysql Снимок4

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

port number

  • 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). port number mysql

  • 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 to mysql Снимок8

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

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

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

The import process can take several minutes. dump import export to mysql Снимок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 to mysql Снимок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 to mysql Снимок14

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

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

What’s next?