Import and Export Dump Files to MySQL

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



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

    3. port number

    4. 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).

    5. port number mysql

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

    7. phpmyadmin port number

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



    9. Enter the name for your server instance.



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



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



    12. The import process can take several minutes.



    13. 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.


  2. Dump export from MySQL
    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.



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



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