Copying Transportable Tablespaces for Non-partitioned Tables cannot be completed when importing a table from Linux server to Windows Server:
On Linux Server:
Step 0: ALTER TABLE t1 FORCE successful
Step 1: FLUSH TABLES t1 FOR EXPORT successful
Step 2: store result of SHOW CREATE TABLE t1
Step 3: copying t1.ibd (and t1.cfg) to saved-tablespaces-directoy successful
Step 4: UNLOCK TABLES successfull
On Windows Server (after transfer of t1.*-files)
Step 5: DROP TABLE t1 sucsessful
Step 6: CREATE TABLE t1 as stored in step 2 successful
Step 7: ALTER TABLE t1 DISCARD TABLESPACE successful
Step 8: move t1.ibd and t1.cfg to datadir (successful)
Step 9: ALTER TABLE t1 IMPORT TABLESPACE (fails)
Error Message is "IMPORT TABLESPACE: SQLSTATE[HY000]: General error: 1810 IO Read error: (1916247584, (null)) "
Due to this error, the data are not importetd into the table.
The storage formats for temporal columns and the ROW_FORMAT-values are identical.
Data-at-Rest Encryption is activated on the Linux server and on the Windows server. The keys are identical on both servers.
This procedure works fine when transferring tables between two windows servers, between two Linux servers, and from a Windows Server to a Linux server. Only the transfer from a Linux server to a Windows server fails.