rm -rf ~/.bytebase/data
.workspace admin
role automatically.
bbdataarchive
bbdataarchive
schema for the changing database.
Sample Project
, click Database > Databases on the left side, choose hr_test
, and then click Edit Schema.
...
and then click Create Schema. Fill it with the name bbdataarchive
and click Create.
bbdataarchive
schema in green color. Click Preview issue. Create the issue and wait till it rolls out automatically. Now the bbdataarchive
schema is created.
hr_test
and double click employee
table, and you’ll see the current data. We’ll try to change the first_name
for Georgi
.
Sample Project
and Database > Databases again, choose hr_test
, and then click Change Data.
bbdataarchive
schema, you’ll see the error message.
bbdataarchive
schema.
hr_test
. You’ll be redirected to the database page.
bbdataarchive
schema, and you can see the backup table.
employee
table in hr_test
under public
schema, input the following SQL script and click Run, and you’ll see the data is changed.
bbdataarchive
schema, and double-click the table below. You’ll see the backup data in the query result.
Georgi
is back.
bbdataarchive
schema, you should create a bbdataarchive
database instead of schema to store the backup data. Check the doc for more details.