How to Restore an S3 Backup Locally and Vice Versa
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
1.
2..
after the databasename_.
and BACKUP_
.
So snapshot filenames go from testing_
to testing_
And columnar blobs go from testing_
to testing_
.
Change directory into the backup folder, execute the following two commands to change the file names.
for file in *[0-9]; do mv "$file" "$(basename "$file").backup"; done;
Command 2:
find . ! -name '*.backup' ! -name '*.manifest' ! -name 'BACKUP_COMPLETE' ! -name '*.' -exec bash -c 'mv $0 $0.backup' {} \;
The folder name is irrelevant for local backups.
3.
For example:
mysql> RESTORE DATABASE testing FROM "/ebs/memsql/s3_test_backup/testing.backup";
Ensure permissions are given to access the files and folders.
If you want to convert a local backup to S3 you would reverse this process with an additional step of ensuring the containing folder/subobject/object prefix is databasename.
Last modified: May 5, 2023