Error: Import SQL Data Dump to fresh installation
virse opened this issue · 1 comments
Hey there,
I try to import a sql data dump to a fresh installation and receive the following message when I do a mysql -uroot -p ghost < data.sql
ERROR 1822 (HY000) at line 87: Failed to add the foreign key constraint. Missing index for constraint 'products_benefits_benefit_id_foreign' in the referenced table 'benefits'
When I open the sqlite3-db I cant find such a table.
The origin of the the dump is a sqlite3-db which I converted with https://www.rebasedata.com.
After a docker container update (installation with sqlite3 version 4.48) I am not able to access my old installation to do a backup or anything else. So I try to use the original db, convert it and do a fresh installation.
Any hint son the error message above.
Thx in advance for help.
virse
Seems to be an issue with the sql syntax. You could try seeing if any of these other issues with that error are of any use https://www.google.com/search?q=%22Failed+to+add+the+foreign+key+constraint.+Missing+index+for+constraint
You could also try asking over at the Docker Community Forums, Docker Community Slack, or Stack Overflow. Since these repos aren't really a user-help forum