Sometimes you need to remove a database that is no longer needed. The Nobregas MySQL Panel lets you drop a database with a few clicks, but because this action is permanent and irreversible, you should understand exactly what happens before proceeding.
What Does Dropping a Database Mean?
Dropping a database permanently deletes:
- All tables inside the database.
- All data (rows, records) in those tables.
- All indexes, views, and routines associated with the database.
- All user grants linked specifically to that database.
This action cannot be undone. There is no recycle bin or undo button. Make sure you have a backup before proceeding.
Step-by-Step: How to Drop a Database
- Log in at mysql.nobregas.org.
- Click Databases in the top navigation bar.
- Find the database you want to delete in the list.
- Click the Drop button (red, with a trash icon) on the right side of that database row.
- A confirmation dialog will appear asking you to confirm the deletion.
- Read the warning carefully, then click Drop to confirm.
The database is immediately removed from your MySQL node and your account.
Before You Drop: Create a Backup
It is strongly recommended to create a backup before dropping any database:
- Go to the Backups page in the top navigation bar.
- Select the database from the dropdown.
- Click Create Backup.
- Wait for the backup to complete.
- Optionally, download the backup file for safekeeping.
Now you can safely drop the database knowing your data is preserved.
What Happens After Dropping
- The database disappears from your database list.
- Your database count decreases, freeing up a slot for a new database.
- Your storage quota is updated to reflect the freed space.
- Any database users that were granted access to this database will lose those grants automatically.
Common Questions
Can I recover a dropped database? Only if you created a backup before dropping it. Use the Restore function on the Backups page.
Will dropping a database affect other databases? No. Each database is completely independent.
Does it delete database users too? No. The users remain but their grants to the dropped database are removed.
