Bug
Restore of old store not working
Issue description
The restore from an store from the year 2019 fails with the error message 'errno: 150 "Foreign key constraint is incorrectly formed"'.
Developer comments
This is caused by changes in the datatype of foreign key columns. The initial new database is present during the restore. During the restore the SQL script drops and recreates the tables one by one. This is where the mismatch happens. Solution is to drop all tables before the restore, not like currently just temporary ones.
Might be related to the [9115, charset switch].
The charset was the problem indeed. It was necessary to replace the old charset in the backup sql script by the new one.
|
Work sessions
Start |
2021-08-03T11:06:16
|
End |
2021-08-03T13:57:18
|
Participant |
Robert Cerny
|
|
We are sorry
This page cannot be displayed in your browser. Use Firefox, Opera, Safari, or Chrome instead.