This is the technical support forum for WPML - the multilingual WordPress plugin.

Everyone can read, but only WPML clients can post here. WPML team is replying on the forum 6 days per week, 22 hours per day.

This topic contains 1 reply, has 2 voices.

Last updated by Bigul 9 months, 1 week ago.

Assigned support staff: Bigul.

Author Posts
August 22, 2019 at 1:43 pm #4439813


How can we reduce the size of this table (which is ~7.5GB) without losing already translated strings?
We already tried to remove ghost entries, clear caches.

August 22, 2019 at 6:23 pm #4442201


Languages: English (English )

Timezone: Asia/Kolkata (GMT+05:30)


Welcome to the WPML support forum. I will do my best to help you to resolve these issues.

Please try the following troubleshooting steps after a site backup and make sure the issue is existing or not.

1) Go to WPML>>Support page

2) Click on Troubleshooting link (blue link in the middle of the page)

3) In Troubleshooting page, please click on the following options of the *Clean up* section. Wait for confirmation of processing after each one.

- Clear the cache in WPML
- Remove ghost entries from the translation tables
- Fix element_type collation
- Set language information
- Fix WPML tables collation
- Recreate ST DB cache tables



The topic ‘[Closed] Table wp_icl_strings is too big’ is closed to new replies.