search

StarRocks / starrocks

StarRocks, a Linux Foundation project, is a next-generation sub-second MPP OLAP database for full analytics scenarios, including multi-dimensional analytics, real-time analytics, and ad-hoc queries.
https://starrocks.io
Apache License 2.0
8.55k stars 1.73k forks source link

backup enhancement #38533

Closed dengjoy2000 closed 1 month ago

dengjoy2000 commented 7 months ago

If a view is created in the database, an error occurs during the full-database backup: ERROR 1064 (HY000): Unexpected exception: Table 'view_name' is not a OLAP table, so it cannot be backed up. Since the view does not contain actual data, it is recommended to back up the 'SHOW CREATE TABLE' statement of the view, or simply ignore the backup of the view, so as not to affect the backup of other data tables in the database.

Now， backing up a database that contains views, it is necessary to specify the specific table names using ON in the backup. This is inconvenient when there are many tables, and it is also troublesome to restore them one by one.

wwa132 commented 7 months ago

Just searched all backup issues raised by the community, just for reference if anyone is interested: https://starrocks.snowshoe.dev/search?q=backup+

github-actions[bot] commented 1 month ago

We have marked this issue as stale because it has been inactive for 6 months. If this issue is still relevant, removing the stale label or adding a comment will keep it active. Otherwise, we'll close it in 10 days to keep the issue queue tidy. Thank you for your contribution to StarRocks!