AWS S3, MinIO, and IBM Cloud Object Storage backup and restore command examples
Deployment options: IBM Netezza Appliance
IBM Netezza Appliance
Learn about the commands that are used for backup and restore to AWS S3, MinIO, and IBM Cloud Object Storage.
AWS S3
- Backup to AWS S3
-
nzbackup -db src_db -connector s3 -connectorArgs UNIQUE_ID=SAMPLEBKUP:ACCESS_KEY_ID=xxxxx:SECRET_ACCESS_KEY=xxxxx:DEFAULT_REGION=us-west-1:BUCKET_URL=my.backup.bucket - Restore from AWS S3
-
nzrestore -db target_db -sourcedb src_db -connector s3 -connectorArgs UNIQUE_ID=SAMPLEBKUP:ACCESS_KEY_ID=xxxxx:SECRET_ACCESS_KEY=xxxxx:DEFAULT_REGION=us-west-1:BUCKET_URL=my.backup.bucket
Note: ENDPOINT and MULTIPART_SIZE_MB are not
mandatory.
MinIO
- Backup to MinIO
-
nzbackup -db src_db -connector minio -connectorArgs UNIQUE_ID=SAMPLEBKUP:ACCESS_KEY_ID=xxxxxx:SECRET_ACCESS_KEY=xxxxxx: DEFAULT_REGION=us-east-1:BUCKET_URL=my.backup.bucket: ENDPOINT=hostname - Restore to MinIO
-
nzrestore -db target_db -sourcedb src_db -connector minio -connectorArgs UNIQUE_ID=SAMPLEBKUP:ACCESS_KEY_ID=xxxxxx:SECRET_ACCESS_KEY=xxxxxx: DEFAULT_REGION=us-east-1:BUCKET_URL=my.backup.bucket: ENDPOINT=hostname
Note: ENDPOINT is mandatory.
IBM Cloud Object Storage
- Backup to IBM COS
-
$ nzbackup -db src_db -connector ibmcos -connectorArgs UNIQUE_ID=SAMPLEBKUP:ACCESS_KEY_ID=xxxxxx:SECRET_ACCESS_KEY=xxxxx:DEFAULT_REGION=us_geo:BUCKET_URL=my.backup.bucket:ENDPOINT=s3.us-east.cloud-object-storage.appdomain.cloud - Restore from IBM COS
-
$ nzrestore -db target_db -sourcedb src_db -connector ibmcos -connectorArgs UNIQUE_ID=SAMPLEBKUP:ACCESS_KEY_ID=xxxxxx:SECRET_ACCESS_KEY=xxxxx:DEFAULT_REGION=us_geo:BUCKET_URL=my.backup.bucket:ENDPOINT=s3.us-east.cloud-object-storage.appdomain.cloud
Note: ENDPOINT is mandatory.