Loading...
 
Skip to main content

TRIM make backup and php console.php database:backup -> Community recipe for protection against data inconsistency in backups (especially for large projects)

Status
Closed
Subject
TRIM make backup and php console.php database:backup -> Community recipe for protection against data inconsistency in backups (especially for large projects)
Version
17.x
Category
  • Community projects
  • Dogfood on a *.tiki.org site
  • Feature request
Feature
Infrastructure
Logs (system & action)
~Backup
Resolution status
Fixed or Solved
Submitted by
Marc Laporte
Lastmod by
Marc Laporte
Rating
(0)
Description

There are two mysqldump commands in the Tiki ecosystem:
https://sourceforge.net/p/tikiwiki/code/HEAD/tree/trim/scripts/tiki/backup_database.php
https://sourceforge.net/p/tikiwiki/code/HEAD/tree/trunk/lib/core/Tiki/Command/BackupDBCommand.php

On a very large site, it can take quite some time from the start of the backup to the end. What happens if some data changes during this time? Could there be data inconsistency? Should we do anything to improve what we have?

Importance
8
Easy to solve?
2
Priority
16
Demonstrate Bug on Tiki 19+
Demonstrate Bug (older Tiki versions)
Ticket ID
6306
Created
Monday 27 March, 2017 21:48:54 UTC
by Marc Laporte
LastModif
Sunday 02 July, 2017 17:12:19 UTC


Show PHP error messages