Corrupted table_prefix: after import all characters converted to lowercase

[mulli]

Bug Summary

Corrupted table_prefix: after import all characters converted to lowercase

In wp_config.php definition: $table_prefix = ‘oWlPrWzy_’;
In exported MySQL DB table prefix is ‘oWlPrWzy_’
Also checked the content of the file to have ‘oWlPrWzy_’ prefix
But AdminerEvo show lower case for table prefix - after successful import
Website is running but tables are NOT recognized and recreated by (Elementor) plugin…

Changing $table_prefix to lower case in wp_config.php - will not work
Result: you do not have permissions…
So it MUST be as the orinial db backup although AdminerEvo shows all lower case

Steps to reproduce

1. Drop all tables.
2. Import using AdminerEvo an exported .sql file
3. As option try cli: mysql -u root -proot local < dbfile.sql - yield the same problem

As precisely as you can, list the steps it takes to reliably reproduce the issue.

Environment Info

Local version 9.0.3+6684
Win 10 Pro
Nginx, PHP 7.4.30, MySQL 8.0.16
Describe your environment.

Supporting info

Please provide your Local Log. See this Community Forum post for instructions on how to do so:

{"class":"Process","level":"warn","message":"2024-07-11T07:14:14.315882Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.","process":"mysql","thread":"main","timestamp":"2024-07-11T07:14:14.372Z"}
{"class":"Process","level":"warn","message":"2024-07-11T07:14:14.367935Z 0 [System] [MY-010931] [Server] %%userDataPath%%\\lightning-services\\mysql-8.0.16+6\\bin\\win64\\bin\\mysqld.exe: ready for connections. Version: '8.0.16'  socket: ''  port: 10305  MySQL Community Server - GPL.","process":"mysql","thread":"main","timestamp":"2024-07-11T07:14:14.373Z"}
{"class":"Process","level":"warn","message":"2024-07-11T07:19:39.741057Z 0 [System] [MY-010116] [Server] %%userDataPath%%\\lightning-services\\mysql-8.0.16+6\\bin\\win64\\bin\\mysqld.exe (mysqld 8.0.16) starting as process 21656","process":"mysql","thread":"main","timestamp":"2024-07-11T07:19:41.905Z"}
{"class":"Process","level":"warn","message":"2024-07-11T07:19:39.743516Z 0 [Warning] [MY-013243] [Server] --character-set-server: The character set UTF8MB3 is deprecated and will be removed in a future release. Please consider using UTF8MB4 instead.","process":"mysql","thread":"main","timestamp":"2024-07-11T07:19:41.906Z"}
{"class":"Process","level":"warn","message":"2024-07-11T07:19:40.747517Z 0 [System] [MY-010229] [Server] Starting crash recovery...","process":"mysql","thread":"main","timestamp":"2024-07-11T07:19:41.906Z"}
{"class":"Process","level":"warn","message":"2024-07-11T07:19:40.754411Z 0 [System] [MY-010232] [Server] Crash recovery finished.","process":"mysql","thread":"main","timestamp":"2024-07-11T07:19:41.907Z"}
{"class":"Process","level":"warn","message":"2024-07-11T07:19:41.863781Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.","process":"mysql","thread":"main","timestamp":"2024-07-11T07:19:41.908Z"}
{"class":"Process","level":"warn","message":"2024-07-11T07:19:41.906782Z 0 [System] [MY-010931] [Server] %%userDataPath%%\\lightning-services\\mysql-8.0.16+6\\bin\\win64\\bin\\mysqld.exe: ready for connections. Version: '8.0.16'  socket: ''  port: 10305  MySQL Community Server - GPL.","process":"mysql","thread":"main","timestamp":"2024-07-11T07:19:41.909Z"}
{"class":"Process","level":"warn","message":"2024-07-11T07:22:25.227237Z 0 [System] [MY-010116] [Server] %%userDataPath%%\\lightning-services\\mysql-8.0.16+6\\bin\\win64\\bin\\mysqld.exe (mysqld 8.0.16) starting as process 2120","process":"mysql","thread":"main","timestamp":"2024-07-11T07:22:27.760Z"}
{"class":"Process","level":"warn","message":"2024-07-11T07:22:25.229883Z 0 [Warning] [MY-013243] [Server] --character-set-server: The character set UTF8MB3 is deprecated and will be removed in a future release. Please consider using UTF8MB4 instead.","process":"mysql","thread":"main","timestamp":"2024-07-11T07:22:27.761Z"}
{"class":"Process","level":"warn","message":"2024-07-11T07:22:26.585470Z 0 [System] [MY-010229] [Server] Starting crash recovery...","process":"mysql","thread":"main","timestamp":"2024-07-11T07:22:27.761Z"}
{"class":"Process","level":"warn","message":"2024-07-11T07:22:26.595271Z 0 [System] [MY-010232] [Server] Crash recovery finished.","process":"mysql","thread":"main","timestamp":"2024-07-11T07:22:27.761Z"}
{"class":"Process","level":"warn","message":"2024-07-11T07:22:27.723354Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.","process":"mysql","thread":"main","timestamp":"2024-07-11T07:22:27.762Z"}
{"class":"Process","level":"warn","message":"2024-07-11T07:22:27.761073Z 0 [System] [MY-010931] [Server] %%userDataPath%%\\lightning-services\\mysql-8.0.16+6\\bin\\win64\\bin\\mysqld.exe: ready for connections. Version: '8.0.16'  socket: ''  port: 10305  MySQL Community Server - GPL.","process":"mysql","thread":"main","timestamp":"2024-07-11T07:22:27.764Z"}
{"class":"Process","level":"warn","message":"2024-07-11T20:28:54.089100Z 0 [System] [MY-010116] [Server] %%userDataPath%%\\lightning-services\\mysql-8.0.16+6\\bin\\win64\\bin\\mysqld.exe (mysqld 8.0.16) starting as process 15780","process":"mysql","thread":"main","timestamp":"2024-07-11T20:28:56.740Z"}
{"class":"Process","level":"warn","message":"2024-07-11T20:28:54.101496Z 0 [Warning] [MY-013243] [Server] --character-set-server: The character set UTF8MB3 is deprecated and will be removed in a future release. Please consider using UTF8MB4 instead.","process":"mysql","thread":"main","timestamp":"2024-07-11T20:28:56.741Z"}
{"class":"Process","level":"warn","message":"2024-07-11T20:28:55.541827Z 0 [System] [MY-010229] [Server] Starting crash recovery...","process":"mysql","thread":"main","timestamp":"2024-07-11T20:28:56.741Z"}
{"class":"Process","level":"warn","message":"2024-07-11T20:28:55.551526Z 0 [System] [MY-010232] [Server] Crash recovery finished.","process":"mysql","thread":"main","timestamp":"2024-07-11T20:28:56.742Z"}
{"class":"Process","level":"warn","message":"2024-07-11T20:28:56.687791Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.","process":"mysql","thread":"main","timestamp":"2024-07-11T20:28:56.743Z"}
{"class":"Process","level":"warn","message":"2024-07-11T20:28:56.740968Z 0 [System] [MY-010931] [Server] %%userDataPath%%\\lightning-services\\mysql-8.0.16+6\\bin\\win64\\bin\\mysqld.exe: ready for connections. Version: '8.0.16'  socket: ''  port: 10305  MySQL Community Server - GPL.","process":"mysql","thread":"main","timestamp":"2024-07-11T20:28:56.743Z"}
{"class":"Process","level":"warn","message":"2024-07-12T00:30:53.831564Z 0 [System] [MY-010116] [Server] %%userDataPath%%\\lightning-services\\mysql-8.0.16+6\\bin\\win64\\bin\\mysqld.exe (mysqld 8.0.16) starting as process 13096","process":"mysql","thread":"main","timestamp":"2024-07-12T00:30:56.200Z"}
{"class":"Process","level":"warn","message":"2024-07-12T00:30:53.836178Z 0 [Warning] [MY-013243] [Server] --character-set-server: The character set UTF8MB3 is deprecated and will be removed in a future release. Please consider using UTF8MB4 instead.","process":"mysql","thread":"main","timestamp":"2024-07-12T00:30:56.201Z"}
{"class":"Process","level":"warn","message":"2024-07-12T00:30:55.059405Z 0 [System] [MY-010229] [Server] Starting crash recovery...","process":"mysql","thread":"main","timestamp":"2024-07-12T00:30:56.201Z"}
{"class":"Process","level":"warn","message":"2024-07-12T00:30:55.066057Z 0 [System] [MY-010232] [Server] Crash recovery finished.","process":"mysql","thread":"main","timestamp":"2024-07-12T00:30:56.201Z"}
{"class":"Process","level":"warn","message":"2024-07-12T00:30:56.166544Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.","process":"mysql","thread":"main","timestamp":"2024-07-12T00:30:56.202Z"}
{"class":"Process","level":"warn","message":"2024-07-12T00:30:56.200778Z 0 [System] [MY-010931] [Server] %%userDataPath%%\\lightning-services\\mysql-8.0.16+6\\bin\\win64\\bin\\mysqld.exe: ready for connections. Version: '8.0.16'  socket: ''  port: 10305  MySQL Community Server - GPL.","process":"mysql","thread":"main","timestamp":"2024-07-12T00:30:56.202Z"}
{"class":"Process","level":"warn","message":"2024-07-12T00:31:06.629891Z 0 [System] [MY-010116] [Server] %%userDataPath%%\\lightning-services\\mysql-8.0.16+6\\bin\\win64\\bin\\mysqld.exe (mysqld 8.0.16) starting as process 17496","process":"mysql","thread":"main","timestamp":"2024-07-12T00:31:08.923Z"}
{"class":"Process","level":"warn","message":"2024-07-12T00:31:06.632526Z 0 [Warning] [MY-013243] [Server] --character-set-server: The character set UTF8MB3 is deprecated and will be removed in a future release. Please consider using UTF8MB4 instead.","process":"mysql","thread":"main","timestamp":"2024-07-12T00:31:08.923Z"}
{"class":"Process","level":"warn","message":"2024-07-12T00:31:07.796260Z 0 [System] [MY-010229] [Server] Starting crash recovery...","process":"mysql","thread":"main","timestamp":"2024-07-12T00:31:08.926Z"}
{"class":"Process","level":"warn","message":"2024-07-12T00:31:07.803085Z 0 [System] [MY-010232] [Server] Crash recovery finished.","process":"mysql","thread":"main","timestamp":"2024-07-12T00:31:08.926Z"}
{"class":"Process","level":"warn","message":"2024-07-12T00:31:08.886499Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.","process":"mysql","thread":"main","timestamp":"2024-07-12T00:31:08.926Z"}
{"class":"Process","level":"warn","message":"2024-07-12T00:31:08.923159Z 0 [System] [MY-010931] [Server] %%userDataPath%%\\lightning-services\\mysql-8.0.16+6\\bin\\win64\\bin\\mysqld.exe: ready for connections. Version: '8.0.16'  socket: ''  port: 10305  MySQL Community Server - GPL.","process":"mysql","thread":"main","timestamp":"2024-07-12T00:31:08.927Z"}

Include any screenshots or video recordings of the issue to help others reproduce.

[Nick-B]

Hi @mulli

I believe what you’re running into here is a known issue with Windows having case insensitivity. More details here:

Database tables case issue

I’ve been taking a closer look at things and I think I have more information to help out with this issue. Thanks for you patience with this, and sorry for the delay – it’s been a tricky thing to zero in on. It looks like the general issue has to do with the fact that Windows’ file system is case-insensitive, while the remote, UNIX-y file system is case sensitive. Because Windows is case-insensitive, this can cause problems with MySQL when changing environments. The MySQL documentation goes int…