Problem: WordPress shows Installation page after migration of MySQL database from
Windows to Linux Server
Cause: After migrating a MySQL WordPress database from Windows server to Linux server,
case-sensitivity of MySQL table names was encountered.
Do note the uppercase letters in the illustration below.
Let the table prefix in wp-config.php file be:
$table_prefix = 'a5hGtMn5u_';
Unix server is case-sensitive, whereas Windows server isn’t, and all tables will be created with
lowercase letters by default. So when the database was imported to Linux, it automatically created
all tables with names in lowercases.As a result, the website showed the WordPress installation page,
as it was unable to find tables with a5hGtMn5u_ (Uppercase) prefix in it.
Solution 1.
A quick solution is to change the value of $table_prefix defined in wp-config.php to lowercases, thus matching the table names in MySQL database.
Solution 2.
Second solution is to set the lower_case_table_names mysql variable, as detailed in the following steps.
Note that this requires a MySQL server restart.
Use lower_case_table_names=1 on both servers.
Note: When you use SHOW TABLES or SHOW DATABASES, you can’t see the names in their original lettercase.
OR
Use lower_case_table_names=0 on Unix and lower_case_table_names=2 on Windows to preserve the lettercase of database and table names.
Note: Ensure that SQL statements always refer to database and table names with the correct letter case
on Windows. Accessing MyISAM table names using different cases for letters can result in Index
corruption; besides, those SQL statements won’t function in Unix, as Unix is case-sensitive.
Note: If you are using InnoDB tables, you require to set lower_case_table_names to 1 on all platforms to force names to get converted to lowercases.

Get new insights right to your inbox

How can our experts help you?

Schedule your consultation

You may also like

  • By admin
  • in DevOps

DevOps as a Service: All You Should Know

  • Aug 9, 2022 .
  • 9 min min
Read More
  • By admin
  • in Containerization

Containerization VS Virtualization: Understanding the Differences

  • Aug 4, 2022 .
  • 8 min min
Read More
  • By admin
  • in DevOps

Best DevOps Tools You Must Try in 2022

  • Jul 26, 2022 .
  • 12 min min
Read More

Be in the know

Techno tips served hot! Subscribe now and stay atop.