- Some databases manage the table names in lower case (e.g., PostgreSQL).
- A backup coming from this kind of databases normally is not going to work in Liferay Experience Cloud Self-Managed (SM), and as a result of the restore you will get the behavior of a clean/empty installation of Liferay DXP in the Liferay Experience Cloud SM platform.
- If you are in this situation you can view duplicated table names, with lower case and camel case names, in the restored DXP database. For example:
- Liferay DXP 7.2
- Create an intermediate database in MySQL and rename all the DXPC table names to camel case before generating and uploading the backup of the on-premises installation.
- Attached you can find a useful script for a basic 7.2.10 installation that you can use as a base script for this operation. Please, check if you need to add or remove any other table names because each installation is going to be different depending on the installed plugins and some plugins as for example your custom plugins or other downloaded plugins from the marketplace are not considered in this basic script.
Subscriber Exclusive Content
A Liferay Enterprise Subscription provides access to over 1,500 articles that include best practices, troubleshooting, and other valuable solutions. Sign in for full access.Sign In