bbdataarchive
location. Bytebase does not automatically purge this backup data, so you can manually clean up the bbdataarchive
database or schema as needed.Database | Prerequisites | Prior Backup | 1-click Rollback |
---|---|---|---|
MySQL | Create a bbdataarchive database on the instance where your database is located. | ✅ | ✅ |
PostgreSQL | Create a bbdataarchive schema on the database. | ✅ | ✅ |
Oracle | Create a bbdataarchive schema on the database. | ✅ | ✅ |
SQL Server | Create a bbdataarchive database on the instance where your database is located. | ✅ | ✅ |
UPDATE
/DELETE
on the same table.UPDATE
, the changed table has primary key and primary key columns are not updated.bbdataarchive
bbdataarchive
storage location in your database instance. Follow the instructions for your specific database engine:
your_user
with the actual username that Bytebase uses to connect to your database.
your_user
with the actual username that Bytebase uses to connect to your database.
tablespace_name
with your actual tablespace name.
admin_user
with the actual username that Bytebase uses as the instance administrator.
your_user
with the actual username that Bytebase uses to connect to your database.