Rename an Unlimited Storage Database
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.
To rename an unlimited storage database, run DETACH DATABASE followed by ATTACH DATABASE.
-- create dbCREATE DATABASE bottomless_db ON S3 "mydata/bottomless_db/"CONFIG '{"region": "us-east-1"}'CREDENTIALS '{"aws_access_key_id": "","aws_secret_access_key": "","aws_session_token": ""}';-- detach dbDETACH DATABASE bottomless_db;-- attach db using a new db nameATTACH DATABASE bottomless_db2 ON S3 "mydata/bottomless_db/"CONFIG '{"region": "us-east-1"}'CREDENTIALS '{"aws_access_key_id": "","aws_secret_access_key": "","aws_session_token": ""}';USE bottomless_db2;
Last modified: August 4, 2023