Hi All,
I try to export and import the MariaDB to a other server. This because I want test this before my HA maybe will crash in future. But its impossible to import a 480MB database into MariaDB on a different server. Both same version.
Tried to do it with phpMyAdmin and the command line. But both get errors something with
use phpmyadmin:
#1452 - Cannot add or update a child row: a foreign key constraint fails (`homeassistant`.`#sql-alter-1-5c7`, CONSTRAINT `states_ibfk_1` FOREIGN KEY (`event_id`) REFERENCES `events` (`event_id`) ON DELETE CASCADE)
use command line:
ERROR 1452 (23000) at line 1838968: Cannot add or update a child row: a foreign key constraint fails (`homeassistant`.`#sql-alter-1-5ea`, CONSTRAINT `states_ibfk_1` FOREIGN KEY (`event_id`) REFERENCES `events` (`event_id`) ON DELETE CASCADE)