-
Type:
Bug
-
Resolution: Fixed
-
Priority:
Normal
-
Affects Version/s: None
-
Component/s: Admin
-
None
The table `instrument_annotation`, which is a derived one, has been added into @group_core in admin/ExportAllTables.
Now that the instrument_annotation is packed into mbdump.tar.bz2, whereas the table `annotation` is not, on restoring a dump file into a new server, this breaks the foreign key constraint on `instrument_annotation` as nothing exists in `annotation` (CreateFKConstraints.sql), and fails the InitDb.pl.
diff --git a/admin/ExportAllTables b/admin/ExportAllTables
index 9c056b7..f036c2c 100755
--- a/admin/ExportAllTables
+++ b/admin/ExportAllTables
@@ -76,7 +76,6 @@ my @group_core = qw(
instrument
instrument_alias
instrument_alias_type
- instrument_annotation
instrument_gid_redirect
instrument_type
isrc
@@ -239,6 +238,7 @@ my @group_derived = qw(
event_meta
event_tag
instrument_tag
+ instrument_annotation
label_annotation
label_meta
label_tag