Versions are MySQL 8 and Xtrabackup 8.
We use Xtrabackup to create backups on Linux systems where lower_case_table_names is at the default value 0.
I am trying to restore such a Linux backup on a Windows machine and have run into conflicts related to lower_case_table_names settings.
I tried all three possibilities for lower_case_table_names on the Windows computer, but no luck:
2020-02-14T10:09:38.533600Z 0 [ERROR] [MY-010158] [Server] The server option ‘lower_case_table_names’ is configured to use case sensitive table names but the data directory is on a case-insensitive file system which is an unsupported combination. Please consider either using a case sensitive file system for your data directory or switching to a case-insensitive table name mode.
2020-02-14T10:18:35.080002Z 1 [ERROR] [MY-011087] [Server] Different lower_case_table_names settings for server (‘1’) and data dictionary (‘0’).
2020-02-14T10:19:38.280331Z 1 [ERROR] [MY-011087] [Server] Different lower_case_table_names settings for server (‘2’) and data dictionary (‘0’).
I am aware that this is not directly an Xtrabackup question. The same issue would occur if I would simply copy the “data” directory from Linux to Windows.
But I was hoping that one of the Percona tools allows a conversion from a case sensitive MySQL database into one that can be used on Windows.
I know that using lower_case_table_names=1 on both platforms would solve the issue. But the Linux hosts are running production systems with customer data and therefore this is not an option.
Does anybody have an idea on how to migrate MySQL “data” from Linux to Windows? Possibly an option available with Xtrabackup?