Regular backups protect your data against accidental deletion, corruption, and unexpected failures. The Nobregas MySQL Panel lets you create a manual backup of any database with a single click — the backup is generated on the server and available for download.
Step-by-Step: Creating a Manual Backup
- Log in at mysql.nobregas.org.
- Click Backups in the top navigation bar.
- Select the database you want to back up from the dropdown.
- Click the Create Backup button.
- The backup is generated on the server. A success notification confirms when it is complete.
- The backup appears in your backup list with the current date and time.
What the Backup Contains
A manual backup is a complete .sql dump of your database, including:
- All tables — Structure (CREATE TABLE statements) and data (INSERT statements).
- Views — Virtual table definitions.
- Stored procedures and functions — If any exist in the database.
- Triggers — Automatic actions defined on tables.
- Indexes and constraints — Primary keys, foreign keys, and unique indexes.
How Long Does It Take?
Backup time depends on your database size:
| Database Size | Approximate Time |
|---|---|
| Under 10 MB | A few seconds |
| 10–100 MB | Under a minute |
| 100 MB–1 GB | A few minutes |
| Over 1 GB | Several minutes |
The backup runs on the server side. You can stay on the page or navigate away — the backup will complete regardless.
Manual vs. Automatic Backups
| Feature | Manual Backup | Automatic Backup |
|---|---|---|
| Triggered by | You, on demand | The system, on a schedule |
| Timing | Whenever you click the button | Typically daily or weekly |
| Label | Marked as "Manual" | Marked as "Auto" |
| Content | Same — full database dump | Same — full database dump |
When to Create Manual Backups
- Before making major changes — Dropping tables, running bulk updates, or altering structure.
- Before deploying code — If your deployment includes database migrations.
- After importing data — Create a checkpoint after a successful import.
- Before deleting a database — Save a final backup in case you need the data later.
- On demand — Anytime you want a current snapshot of your data.
Backup Storage
Manual backups are stored on the server and count toward your plan's backup storage quota. You can download them to your local machine and delete old backups to free space.
