I am opening this ticket to address two critical issues following our recent migration to a new VPS. These issues are severely impacting our daily operations and sales, and we need your assistance to resolve them urgently.
1. Critical Data Loss & Missing Credits We recently migrated our website to a new VPS. Despite following your documentation’s import guidelines strictly, we have lost the majority of our existing translations.
We have been trying to recover this data for several months without success.
Crucial: We have exhausted our automatic translation credits. Since this loss occurred during a migration (and not due to user error), we are unable to re-translate from scratch without a credit restoration or a technical fix to recover the old data.
2. Severe Database Bloat & Performance Degradation We moved to a VPS specifically to improve speed. Initially, after cleaning the site during migration, performance improved. However, the site has quickly degraded again, and our diagnostics point to WPML database bloat as the primary cause.
We need guidance on how to permanently clean the WPML-related bloat to stop this recurring sluggishness.
Our Goal: We need to restore our lost translations (or have credits restored to re-do them) and stabilize the site's performance. We are currently losing sales and development time on these recurring issues.
Please let us know the next technical steps to troubleshoot the missing data and clean the database effectively.
Thank you.
NB : We still have access to the backup website which is a clone of the previous version of the website.
Hello Lauren, I don't think that would be possible as many things have changed since the migration and importing again may cause issues by replacing existing content, we also have many export files not one so that would be even trickier...
If you are not able to import the old files, and the translations are not in the database, then the only other option is to retranslate them. If you have not changed the content that was translated, and the WPML account information has not changed in the migration, then it's possible the translations are stored in Translation Memory. I suggest testing one page that was previously translated to see if it can be recovered. Please let me know the results.
Hello, I tried to import the translations tables from the database into a staging but it didn't work, WPML says there is a critical error or product_type is incorrectly defined. We also can't see and can't proceed into translation of the actual content even manually. Something is wrong with our setup and I couldn't locate the problem. Would you please advise on how to correctly import the translations from the database backup, and also how to fix the rest api disabled issue, because we tried many things both in the website and the server and nothing seems to work.
We can provide an access to the staging website as well as to the backup with the translations, you can reproduce the issue and tell us what to do, or we can simply replicate the fix. This come and go is taking so much time...
I also think that there might be something related to the fact that we have several subdomains with the same WPML account, 2 subdomains are backup/staging and the main domain is the production website.
Please provide me access to the original site where you tried to export the content from, as well as the staging site where you would like me to try to import the translations to. I have marked the next reply as private, please use the private fields to securely share credentials. Thanks!
