Skip to main content

Using the Data Package Storage

If you need to apply the same SQL dump to dev, staging, and prod in turn, or just want to park an external dump in KIOPS for later, use the Data Package storage. Think of upload as putting a USB stick on a shelf, apply as carrying that USB to another computer and copying it out, and download as taking the USB back off the shelf.

This guide walks through three concrete scenarios you can follow in order.

Before You Start: Terms to Know​

  • Data package: A SQL dump bundle stored inside KIOPS together with upload time, application history, and DB type.
  • import kind: A package created by uploading a SQL dump file you have.
  • export kind: A package KIOPS itself produced by dumping a source DB (when the feature is enabled).
  • Status tags: The current state of a package - one of ready / applying / applied / failed / deleted.
  • PackageApplyModal: The modal that opens when you replay a stored package against a target DB.
  • 5GB quota / 30-day auto-clean: The operational limits applied to data packages (details in the Prerequisites section).

Prerequisites​

Permissions and registration must be in place
  • The Data Package tab requires the Database Management permission.
  • To apply a package, the target DB must be registered under DB Connections and you must know the target / SSH / Jump passwords up front.
  • At upload time, your organization storage must be within the 5GB quota. Uploads and auto-saving are rejected once the quota is exceeded.

Location and layout of the Data Package tab​

Open it by selecting the Data Package tab among the tabs at the top of the [Database Management] page.

The tab position varies by permission

The tabs on the [Database Management] page are listed as DB Connections, Sync Jobs, Migration, Backup Management, Data Package, and Execution History, but the Sync Jobs and Migration tabs may be hidden depending on permissions. So do not look for a "Nth tab" - find the Data Package label directly.

The list table has these columns.

ColumnDescription
NameDisplay name (falls back to the file name when no name is set at upload) + file name
Kindimport (uploaded dump) / export (dumped by KIOPS itself)
DB typePostgreSQL / MySQL / MariaDB
SizeFile size
Statusready / applying / applied / failed / deleted
CreatedRegistration timestamp
ActionsApply / Download / Delete action buttons

The status tag uses these colors.

  • ready (blue) - Ready to apply
  • applying (orange) - Currently being applied to some target DB
  • applied (green) - Successfully applied
  • failed (red) - Errored during application
  • deleted (gray) - Marked as deleted

The top right of the tab has 2 buttons.

  1. Upload SQL File: Saves a dump file you have into the storage only (no immediate apply).
  2. Refresh: Reloads the list to the latest state.

Each package row's Actions column has 3 action buttons: Apply / Download / Delete.

Quota and auto-cleanup
  • 5GB quota per organization: Total storage per organization is capped at 5GB. Uploads are rejected once the cap is hit.
  • 30-day auto-clean: The auto-clean targets packages that are in the applied status and of import kind. They are cleaned up - file and list entry - 30 days after they were applied. Packages merely kept in ready status are not subject to auto-clean. For long-term retention, download them locally.

Scenario 1. Park an externally received dump for later​

Use this flow when you have a dump you may need later but do not want to apply right now.

Step 1. Enter the Package tab​

  1. Go to [Database Management] > Data Package tab.
  2. Click the Upload SQL File button (upload icon) in the upper right.

Step 2. Pick a file and upload​

  1. Select a .sql or .sql.gz file (1GB limit).
  2. When the upload finishes, a new row appears at the top of the list with state ready.
  3. Kind is auto-classified as import, and the display name defaults to the uploaded file name.

At this point the package is "just stored" - it is not applied to any target DB. Continue to Scenario 2 when you need to apply it.

Scenario 2. Apply the same dump to multiple environments​

Use this flow when a single registered package must be rolled through dev → staging → prod. You no longer have to re-upload the file each time.

Step 1. Open the apply modal​

  1. On the Data Package tab, locate the package row to apply.
  2. Click the Apply button (lightning icon) in the Actions column.
  3. The PackageApplyModal opens.
Common mistake: clicking Apply on an applying or deleted row

applying means another job is already running. Wait for it to finish. Progress is tracked via the status tag on the same row, and the list auto-refreshes while a package is being applied. The Apply button is disabled in both applying and deleted states, and deleted rows also cannot be downloaded.

Step 2. Choose target DB and import mode​

  1. Target DB: Pick the DB connection for the environment you are rolling out to (dev / staging / prod).
  2. Import mode:
    • Append (new import) (default): Adds on top of existing data.
    • Replace (wipe and refill): Drops all tables/data in the target and refills it. Because this is dangerous, the user must select it explicitly; when chosen, the pre-apply backup option is automatically turned on and locked, and applying triggers a double confirmation (checkbox + "Apply at my own risk") acknowledging the data-loss risk.

Step 3. Enter passwords and start​

  1. Enter target DB / SSH / Jump passwords.
  2. Click Start Apply. The modal closes and the background job begins.
  3. The package row's status moves to applying (orange) and ends as applied (green) or failed (red).

Step 4. Roll into the next environment​

A package in applied state can be re-applied. Click Apply on the same row again to roll out staging → prod, and so on.

Common mistake: replace failing mid-way on production

A failed replace on production can leave you with empty tables. Always take a backup from the [Database Management] > Backup Management tab before applying to production, and rehearse the same package on staging one more time when possible.

Scenario 3. Carry a package out of KIOPS (download)​

Use this flow when you need to ship a stored dump out of KIOPS to an external server, another KIOPS instance, or a backup disk.

Step 1. Click Download​

  1. On the Data Package tab, locate the package row to take out.
  2. Click the Download button (download icon) in the Actions column.
  3. The browser starts downloading the stored .sql file. Files uploaded as .sql.gz are decompressed and kept as .sql by KIOPS, so the download is always a plain .sql.

Step 2. External storage or transfer​

  • The downloaded file can be handed to an external backup system, another KIOPS instance, or a partner as-is.
  • On a different KIOPS instance, re-upload it from the Data Package tab to replay the same dump there.
Common mistake: panicking when a package disappears due to auto-cleanup

import packages in applied status are auto-cleaned 30 days after they were applied. To keep an already-applied dump for the long term, download it before the cleanup. Re-uploading the same file registers it as a new package.

Cleaning Up Packages​

When a package is no longer needed you can remove it directly.

  1. Click the Delete button (delete icon) on the row to remove.
  2. Approve the confirmation popup.
  3. The status moves to deleted and apply / download actions become disabled.

Since auto-cleanup only targets import packages in applied status, delete ready-only stored packages or packages you no longer need yourself to keep your organization's 5GB quota usable.

What to Do Next​