¶ Manual Database Restoration Guide
In this section, we walk you through the entire process on how to restore your databases manually, if needed.
¶ Key Icon and Encryption Key
¶ Restoring from Backup
In the event that the server is deleted from Upback or if the original server is unavailable, you may copy the backup file from the object storage and manually extract the database using the following commands:
¶ For MySQL/MariaDB
openssl aes-256-cbc -d -a $(openssl version | awk '$2 !~ /(^0.)|(^1.(0.|1.0))/ {print "-pbkdf2"}') -in "backup_file" -k "backup_private_key" | zstd -d | xbstream -x
¶ For PostgreSQL
openssl aes-256-cbc -d -a $(openssl version | awk '$2 !~ /(^0.)|(^1.(0.|1.0))/ {print "-pbkdf2"}') -in "backup_file" -k "backup_private_key" | zstd -d -o backup_restore_file
Please note:
- backup_file → name of the file downloaded from the object storage
- backup_private_key → name of the file containing the previously copied key
For comprehensive guides, in-depth articles, and community discussions, be sure to visit our blog section. Additionally, our FAQ section is available to answer common questions and provide further assistance.