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ć ?