Liferay starts up creating tables and populating them with default data after restoring an upgraded database

Issue

• You might encounter the behavior where you successfully back up your current data and performed a successful upgrade in your local MySQL server. However, when restoring the upgraded data, Liferay does not start with it but instead begins creating tables and populates them with default data

Environment

• Liferay DXP 7.2
• Liferay DXP 7.3
• Liferay DXP 7.3

Resolution

• Make sure to check whether your local MySQL is using lower-case or upper-case
• If it is lower case, then you might want to set the following variable:
  

  LCP_GCP_DATABASE_FLAG_LOWER_CASE_TABLE_NAMES=1

  This variable will make table and database names case-insensitive.
• Or rerun the upgrade process in a local MySQL which is using upper-case

Additional Information

• Configure database flags — search for lower_case_table_names