News for hackers. Stuff that matters.

A comment on Continuous MySQL backup validation: Restoring backups. Parent comment

Re:Continuous MySQL backup validation: Restoring backups by eloff on Friday October 28, 2016 @06:14PM (#12821220)
I understood it to mean that if you restore table A and table B in parallel, if there is a foreign key between them, then referential integrity checks would cause one of the loading operations to fail. How do you deal with that?
[ Parent | on HN ]
Re:Continuous MySQL backup validation: Restoring backups by danudey on Friday October 28, 2016 @06:17PM (#12821243)
It's likely that foreign key checks aren't handled at the RDBMS level, but rather at the application level.
[ Parent | on HN ]