Page MenuHomePhabricator

Documented backup strategy broken
Closed, ResolvedPublic

Description

Perhaps the Wikibase Docker documentation should instruct to use mysqldump, mydumper or similar?

Using volume-backup for the database didn't work for me and I'm not sure if backing up and restoring by copying the files is even supposed to work with InnoDB tables. "But note that table file copying methods do not work if your database contains InnoDB tables." https://dev.mysql.com/doc/refman/8.0/en/backup-methods.html

(The symptom I got was an error telling me to run update.php when actually MySQL was rejecting all the tables in the my_wiki database and MySQL logs said I should run mysql_upgrade. I reverted to the previous version of the MariaDB docker image and it went to a restart loop logging some assertion errors.)

Event Timeline

TuukkaH created this task.Jan 29 2019, 7:23 PM
Restricted Application added a project: Wikidata. · View Herald TranscriptJan 29 2019, 7:23 PM
Restricted Application added a subscriber: Aklapper. · View Herald Transcript
Addshore triaged this task as Low priority.Feb 6 2019, 12:09 PM
Addshore moved this task from Incoming to Ready to estimate on the Wikidata-Campsite board.
Addshore moved this task from Backlog to Misc on the Wikibase-Containers board.
Addshore moved this task from incoming to ready to go on the Wikidata board.Feb 7 2019, 3:54 PM