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

lealone数据库的备份和恢复，大神能否出个详细文档步骤 #232

Open

tangzhongshan opened this issue Jul 3, 2024 · 1 comment

tangzhongshan commented Jul 3, 2024

lealone数据库的备份和恢复，大神能否出个详细文档步骤

是为了防止万一所在虚拟机的硬盘数据盘损害，定期通过脚本备份到别的服务器，到时候万一出现硬盘数据故障，可以通过另外1台服务器的备份来恢复lealone数据库

Member

codefollower commented Jul 3, 2024 •

edited

Loading

在 lealone 的客户端用 root 用户连接到想备份的数据库
执行以下命令做全量备份
BACKUP TO 'mydb.zip'

执行以下命令做增量备份
BACKUP TO 'mydb_0704.zip' LAST DATE '2024-07-03'

LAST DATE 指定上一次的备份日期时间，只会把大于 LAST DATE 的数据做增量备份

恢复数据，直接把 'mydb.zip' 解压到 lealone 安装目录下的 data 子目录即可。

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment