Skip to main content

How to restore a backup

A MariaDB archive is restored from the Backups tab of the cluster page, in the Hikube console, or from Infrastructure > Backups > Archives. See Restore a PostgreSQL or MariaDB database.

The restore writes either onto the original cluster, or onto another existing MariaDB cluster in the project. The archive is replayed into the target: each table it contains replaces the table of the same name; tables and databases it does not contain are kept.

Restoring a logical export​

If you have an export made with mysqldump, restore it yourself into an existing database. The user must have the Administrator (Admin) right on the target database:

mysql -h <host> -P 3306 -u app-user -p myapp < myapp-2026-06-15.sql

Verification​

-- Check the row count of the restored tables
SELECT table_name, table_rows
FROM information_schema.tables
WHERE table_schema = 'myapp'
ORDER BY table_rows DESC;

Going further​