Przy backupie napotkałem taki błąd bazy danych MySql
Napotkano błędy w bazie danych!
Zapytanie: DELETE FROM location_boroughs
Błąd: Cannot add or update a child row: a foreign key constraint fails
(`lms`.`netdevices`, CONSTRAINT `netdevices_ibfk_4` FOREIGN KEY
(`location_city`) REFERENCES `location_cities` (`id`) ON DELETE SET
NULL ON UPDATE CASCADE)
Zapytanie: DELETE FROM location_cities
Błąd: Cannot add or update a child row: a foreign key constraint fails
(`lms`.`netdevices`, CONSTRAINT `netdevices_ibfk_4` FOREIGN KEY
(`location_city`) REFERENCES `location_cities` (`id`) ON DELETE SET
NULL ON UPDATE CASCADE)
Zapytanie: DELETE FROM location_districts
Błąd: Cannot add or update a child row: a foreign key constraint fails
(`lms`.`netdevices`, CONSTRAINT `netdevices_ibfk_4` FOREIGN KEY
(`location_city`) REFERENCES `location_cities` (`id`) ON DELETE SET
NULL ON UPDATE CASCADE)
Zapytanie: DELETE FROM location_states
Błąd: Cannot add or update a child row: a foreign key constraint fails
(`lms`.`netdevices`, CONSTRAINT `netdevices_ibfk_4` FOREIGN KEY
(`location_city`) REFERENCES `location_cities` (`id`) ON DELETE SET
NULL ON UPDATE CASCADE)
jest tego dużo więcej, ma ktoś pomysł jak to naprawić ?