{question}
How do you perform a SingleStore database backup to Digital Ocean Spaces [S3 Compatible Storage] using the sdb-admin create-backup command?
{question}
{answer}
Spaces is a S3 Compatible object storage service that lets you store and serve large amounts of data. Each Space is a bucket for you to store and serve files.
Example:
Let's take the backup of the database testDB
to the Digital Ocean Spaces [S3 Compatible Storage] with the sdb-admin create-backup command.
Required Connection String details:
Path: s3testbackup
Aws_access_key_id: H5dnU2pSM6
Aws_secret_access_key: abcdefghi
Endpoint_url: sfo3.digitaloceanspaces.com
Region: sfo3
These are the 3 commands you need to follow to create a backup on Digital Ocean Space:
export aws_access_key_id=H5dnU2pSM6
export aws_secret_access_key=abcdefghi
sdb-admin create-backup -r s3://s3testbackup/ endpoint_url=sfo3.digitaloceanspaces.com®ion=sfo3 testDB
Important Note:
- Ensure the Digital Ocean Space has the Enable File Listing permission selected.
- Generate the access keys for spaces using the API from the control panel of the digital ocean.
- Copy the correct endpoint_url from the settings tab of the spaces.
Reference Links:
{answer}