1. Guides
  2. Run restore tests
  3. Restore types
  4. Databases
  5. MySQL
Website
  • Overview
  • Quickstart
  • How RestoreTrust works
  • Requirements
  • Organizations and projects
  • Project workers
  • Test schedules
    • File checks
  • Validation gates
  • Time zones and dates
  • Manual runs
  • Notifications
  • Check results
  • Execution logs
  • Reports
  • Evidence and verification
  • Team and roles
  • API keys
  • Billing and plans

MySQL

Create a MySQL restore schedule for SQL backups and validate the imported data with typed query gates.

Loading documentation…

PostgreSQL< PreviousMariaDBNext >

Powered by heyo

On this page

Available versionsConfigure the restore

A MySQL schedule imports a SQL backup into the exact MySQL version you select, then runs your validation gates.

Available versions

SeriesExact versionTier
5.55.5.62Legacy
5.65.6.51Legacy
5.75.7.44Legacy
8.08.0.46Legacy
8.18.1.0Legacy
8.28.2.0Legacy
8.38.3.0Legacy
8.48.4.11Supported
9.09.0.1Legacy
9.19.1.0Legacy
9.29.2.0Legacy
9.39.3.0Legacy
9.49.4.0Legacy
9.59.5.0Legacy
9.69.6.0Legacy
9.79.7.2Supported
26.726.7.0Supported
Use the current catalog

These are the versions currently available in RestoreTrust. The console and the database-engine catalog are authoritative if the catalog changes. Prefer a Supported version for a new schedule unless your recovery target requires an exact Legacy version.

Configure the restore

  1. 1

    Select MySQL and a version

    Choose the exact version corresponding to the system that produced the backup.

  2. 2

    Set the artifact format

    The dump format is SQL. Let RestoreTrust detect the container and compression, or enforce known values. You can use no container, tar, or ZIP and any compression offered in the console.

  3. 3

    Configure decryption

    Select ZIP password metadata for a protected ZIP, or the matching age identity/passphrase metadata for age-encrypted input. Ensure the Kubernetes Secret exists in the worker's job namespace.

  4. 4

    Set or infer the target database

    Enter an explicit target database when required. If left empty, RestoreTrust uses the first USE statement found in the dump; if none is present, it uses restoretrust_restore.

  5. 5

    Add validation gates

    Require successful import and add read-only SQL probes for important data conditions. Compare each probe result as a boolean, integer, or string. Add duration gates for download, restore, or health probes when useful.

Prefer probes that detect incomplete or stale data, such as a minimum count for a critical entity or a known schema marker. Avoid queries that expose secret or personal values in results.

Check SQL compatibility

MySQL and MariaDB are separate restore targets. Select MySQL only when it matches the backup you intend to validate; a successful restore on a different engine or version would not test the required recovery path.

After saving, run the schedule manually and review the selected backup, restore log, probe results, and evidence.