Backup and Restore
In case database backup and restore is required, please follow the steps below. Our team is here to assist you throughout the process.
This is available for paid tiers only. We hope to make this process self-serve soon.
1. Notify Us
Send a message to our team via Slack (if we have set up one for you) or email at support@thenile.dev and include URGENT in the title. Include the following details to expedite the recovery process:
- Database name
- Approximate time when the issue occurred
- Do you wish to restore to new schema in same database or to a different database? (if a different database, please provide its name as well).
2. Acknowledgment
Once we receive your message, we will acknowledge it within 15 minutes. If you do not receive an acknowledgment, please follow up.
3. Backup Availability
We take three backups daily to ensure your data is well-protected. Upon your request, an appropriate backup, based on the time when the data issue occurred, will be restored in a separate schema within your database or alternatively into the original schema in an empty database of your choice.
In the case of separate schema, the backup schema will have a name in the format: <original_schema_name>_bkp
.
For example, if your original schema is sales_data
, the backup schema will be named: sales_data_bkp
4. How to Restore Data
Only needed if data is restored within the same database into another schema
You can restore the data from the backup schema using SQL commands. Below is an example query to copy data back to the original schema:
Need Assistance?
If you encounter any issues during the recovery process or require additional help, please do not hesitate to contact our team. We’re here to help ensure a smooth recovery.
Was this page helpful?