Dump Import/Export

Import and Export Dump Files to MySQL, MariaDB and Percona

Use a desktop MySQL-compatible client to connect remotely to a MySQL, MariaDB, or Percona database, import an existing dump file, or export database objects to a local directory. The source example uses MySQL Workbench.

In this article

Dump Import

1

Create a new server instance

Open a desktop client for MySQL, MariaDB, or Percona. The source guide uses MySQL Workbench. Create a new server instance.

MySQL Workbench
Create a new database server instance in MySQL Workbench.
2

Specify the remote host

Paste the database node’s public IP address into the host/address field and click Next.

Remote host public IP
Use the database public IP as the remote host.
3

Enter connection credentials

Set the database connection values:

  • IP address
  • Port number
  • Username
  • Password

The platform sends the database credentials by email when the environment is created.

Database connection credentials
Enter the remote database host, port, username, and password.
4

Test the connection

Allow MySQL Workbench to test the database connection. The test can take a couple of minutes.

Testing database connection
Wait while the desktop client verifies the remote database connection.
5

Select the remote management type

Choose the required remote-management option for the server instance.

Remote management type
Select the remote-management type for the database server instance.
6

Name the server instance

Enter a convenient name for the new server instance.

Server instance name
Assign a name to the newly created remote database instance.

After setup completes, the server instance appears in MySQL Workbench.

Database connection established
The remote database server instance is successfully created.
7

Open Data Import/Restore

Open the server instance, select Data Import/Restore, and choose the dump file to import.

Data Import Restore
Select the dump file from the Data Import/Restore section.

Start the import. Depending on the amount of data, the import process can take several minutes.

Start dump import
Start the database dump import and wait for completion.
8

Verify the imported dump

Return to the platform dashboard and open MySQL or MariaDB in a browser. Sign in to the administration page with the credentials sent by the platform. In the source example, select test and then example to verify the imported data.

phpMyAdmin imported dump
Verify the imported database content in the database administration panel.

Dump Export

1

Open Data Export

Open the server instance created earlier and select Data Export. Choose the database objects to export and specify the local directory where the dump should be saved.

Data Export
Select the database objects and local export directory.
2

Start the export

Start the export operation. The process can take several minutes depending on the amount of exported data.

Start database export
Start the export and wait while the dump file is generated.

The resulting dump file is saved in the local directory specified during export.

Expected Result

A remote MySQL-compatible desktop client connects to the database through its public IP. Existing dump files can be imported into the database and verified through the administration panel, while selected database objects can be exported to a local directory as dump files.

Important Notes

  • The source example uses MySQL Workbench, but the workflow is applicable to MySQL, MariaDB, and Percona.
  • Remote access requires connection details for the database node, including its public IP.
  • The platform provides database credentials when the environment is created.
  • Import and export operations can take several minutes depending on the amount of data.
  • Always verify imported content after the operation completes.
  • The exported dump is stored in the local directory selected in the desktop client.

What’s Next?

  • Java Connection to MySQL/MariaDB
  • PHP Connection to MySQL/MariaDB
  • Remote Access to MySQL/MariaDB