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 2 replies, has 2 voices.

Last updated by otavioB-3 2 months, 3 weeks ago.

Assigned support staff: Lauren.

Author Posts
April 20, 2019 at 3:43 pm #3650481

otavioB-3

Hi there,

I received a message from my provider saying our database is getting too large. So I ran a query to know exactly which table is the problem, and I discovered that wpmv_icl_string_pages is 531mb. How can I shrink it and why is it so big? I need to solve it ASAP, because our limit size is 1gb, and we are over it.

Thanks in advance

April 22, 2019 at 4:16 pm #3656939

Lauren
Supporter

Languages: English (English )

Timezone: America/New_York (GMT-04:00)

Thank you for contacting WPML support. I'll be happy to help you with this.

Please make sure you have a full backup of your site. Then, access your database and run the following sql commands to try reducing the size of the table.

TRUNCATE TABLE wp_icl_string_pages;
DELETE FROM `wp_icl_strings` WHERE status = 0;

After this, please let me know if this reduces the table size and resolves the issue.

April 22, 2019 at 8:02 pm #3658087

otavioB-3

My issue is resolved now. Thank you!