Ruk-Com PaaS Documentation

Build, deploy and operate applications on the platform.

RUK-COM PAAS / DATABASES

Dump Import/Export

This guide is maintained for Ruk-Com PaaS. Screens and options may vary by platform version and account permissions.

Confirm the environment, region and account permissions, and back up current settings before changing a production system.

Dump Import

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

Image 40: MySQL workbench 2. Specify your host machine (just paste your public IP into the address field) and click Next.

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

Image 42: database connection credentials 4. Then your database connection will be tested for a couple of minutes.

Image 43: testing database connection 5. Set the type of remote management you want to use.

Image 44: do not use remote management 6. Enter the name for your server instance.

Image 45: server instance name 7. You can see that your server instance is successfully created.

Image 46: database connection established 8. Open your instance and pick Data Import/Restore and choose the dump you want to import.

Image 47: data import/restore The import process can take several minutes.

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

Image 49: phpMyAdmin imported dump

Dump Export

  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.

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

Image 52: start export Your dump file will be in the directory, the path to which you have specified.