Moving data

Backups

Save a database's structure and data to a file on your computer, restore it wherever you want and schedule automatic backups.

#Make a backup

Right-click a database or a schema → “Back up…” (or “Back up” in the toolbar).

• Objects to save: all of that database or schema.
• Include the tables' data: unchecked, only the structure.
• Folder and File name: where it goes on your computer.

The backup runs in the background, with its progress, and can be cancelled without leaving a half-written file.

#See your backups

Right-click the connection → “Show backups”, or the “Backups” tab. The list shows each file's date, source, database, contents (rows and objects, or “structure only”) and size. “Show in folder” and “Open folder” open them in your file manager.

A damaged or incomplete file is marked so you don't rely on it.

#Restore

1. In the list, pick the backup and click “Restore…”.
2. In the tree, pick the database or schema to restore it into (it can be another server of the same engine).
3. Paste with Ctrl+V or the paste button.

It works like pasting objects: you choose whether to restore the data too and what to do with what already exists (skip, append or replace). Each table is restored in a transaction.

#Scheduled backups

In the backup dialog, check “Repeat this backup”:

• Every day at a time, or Every so many hours.
• Keep the last N files: past that number the oldest of that schedule are deleted, never other files. Empty keeps them all.
• Make the first one now, if you want one right away.

Each file has the date and “(programado)” in its name. Under “Scheduled” you see when the next one is due and how the last one went, and you can run it now, pause, resume or delete it; the files it already made stay.

Something missing or unclear? Write to support@qrulla.com.