Liferay starts up creating tables and populating them with default data after restoring an upgraded database
Dávid Hegedüs
更新
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
