2018-11-18, 18:51
Hi,
I have been runnig Kodi on 2 Intel NOC connected to a MySQL server on my main computer. It have been working great acouple of years even after several reinstallations.
I was forced to reinstall Windows 10 on the main computer. To be sure that no data was lost I did 2 kind of exports with the MySQL Workbench 8, one selfcontained and one folder backup.
After reinstallation of Windows and MySQL server (including workbench) I do not get the import to work, I get the following error
17:40:56 Restoring I:\Reinstall 20181118\Kodi\MySQL backup\Dump20181118.sql
Running: mysql.exe --defaults-file="c:\users\jimmy\appdata\local\temp\tmpr3pqm2.cnf" --protocol=tcp --host=127.0.0.1 --user=root --port=3306 --default-character-set=utf8 --comments --database=mysql < "I:\\Reinstall 20181118\\Kodi\\MySQL backup\\Dump20181118.sql"
ERROR 3734 (HY000) at line 1951: Failed to add the foreign key constraint. Missing column 'country_id' for constraint 'fk_city_country' in the referenced table 'country'
Operation failed with exitcode 1
17:41:39 Import of I:\Reinstall 20181118\Kodi\MySQL backup\Dump20181118.sql has finished with 1 errors
When running the folder import I get over 300 errors.
No datatables are created and the only already existing item is a sys database.
Could someone help me out here?
BestRegards
I have been runnig Kodi on 2 Intel NOC connected to a MySQL server on my main computer. It have been working great acouple of years even after several reinstallations.
I was forced to reinstall Windows 10 on the main computer. To be sure that no data was lost I did 2 kind of exports with the MySQL Workbench 8, one selfcontained and one folder backup.
After reinstallation of Windows and MySQL server (including workbench) I do not get the import to work, I get the following error
17:40:56 Restoring I:\Reinstall 20181118\Kodi\MySQL backup\Dump20181118.sql
Running: mysql.exe --defaults-file="c:\users\jimmy\appdata\local\temp\tmpr3pqm2.cnf" --protocol=tcp --host=127.0.0.1 --user=root --port=3306 --default-character-set=utf8 --comments --database=mysql < "I:\\Reinstall 20181118\\Kodi\\MySQL backup\\Dump20181118.sql"
ERROR 3734 (HY000) at line 1951: Failed to add the foreign key constraint. Missing column 'country_id' for constraint 'fk_city_country' in the referenced table 'country'
Operation failed with exitcode 1
17:41:39 Import of I:\Reinstall 20181118\Kodi\MySQL backup\Dump20181118.sql has finished with 1 errors
When running the folder import I get over 300 errors.
No datatables are created and the only already existing item is a sys database.
Could someone help me out here?
BestRegards