Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

BACKUP ALL DATABASES #58143

Closed
VladislavePolyakov opened this issue Dec 22, 2023 · 1 comment · Fixed by #64150
Closed

BACKUP ALL DATABASES #58143

VladislavePolyakov opened this issue Dec 22, 2023 · 1 comment · Fixed by #64150
Labels
question Question?

Comments

@VladislavePolyakov
Copy link

As described in Docs from version 23.4 ALL posible for BACKUP

When run command BACKUP ALL DATABASES TO Disk('backups', 'all_dbs.zip') got error:

Syntax error: failed at position 12 ('DATABASES'):
 
BACKUP ALL DATABASES TO Disk('backups', 'all_dbs.zip')

Could some one comment about this functional and how to do backup all databases at once.
@VladislavePolyakov VladislavePolyakov added the question Question? label Dec 22, 2023
@y-serg
Copy link

y-serg commented Feb 8, 2024

I was able to run backup of all databases by omitting the word DATABASE. This should work:

BACKUP ALL TO Disk('backups', 'all_dbs.zip')

it looks like there is an inaccuracy in the documentation.

@realyota realyota mentioned this issue May 20, 2024
Merged
31 tasks
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
question Question?
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Fix backup all documentation realyota/ClickHouse
2 participants
@VladislavePolyakov @y-serg