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.

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

Backing up Nextcloud with mysqldump while running? #577

Closed
Yvan-Masson opened this Issue Oct 12, 2017 · 3 comments

Comments

Projects
None yet
2 participants
@Yvan-Masson

Yvan-Masson commented Oct 12, 2017

Hi,

The documentation currently does not state if we can back up Nextcloud DB while it is running, while ensuring database consistency and ability to restore.

  1. I suppose that Nextcloud should be stopped, at least to ensure that DB and data are in a consistent state regarding each other.

  2. For sqlite3 command, I could not find anything useful in manpage.

  3. For MySQL/MariaDB, I read about --single-transaction option of mysqldump manpage and this makes me think that Nextcloud should be stopped:

While a --single-transaction dump is in process, to ensure a valid dump file (correct table contents and binary log coordinates), no other connection should use the following statements: ALTER TABLE, CREATE TABLE, DROP TABLE, RENAME TABLE, TRUNCATE TABLE. A consistent read is not isolated from those statements, so use of them on a table to be dumped can cause the SELECT that is performed by mysqldump to retrieve the table contents to obtain incorrect contents or fail.

  1. I did not look PostgreSQL.

Could you write down if Nextcloud should be stopped or in maintenance mode during backup, or not?

Best regards,
Yvan

@bakkegaard

This comment has been minimized.

Contributor

bakkegaard commented Oct 24, 2017

It seems to be a good idea to put your Nextcloud instance in maintenance mode
https://help.nextcloud.com/t/how-to-backup-nextcloud/21623

@Yvan-Masson

This comment has been minimized.

Yvan-Masson commented Oct 24, 2017

Thanks for the answer. I am cautious so this is what I do, but I think this should be written in the documentation.

@Yvan-Masson

This comment has been minimized.

Yvan-Masson commented Dec 4, 2017

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