Skip Navigation

This thread is resolved. Here is a description of the problem and solution.

Problema:
El cliente desea tener un plugin que limpie la base de datos, especialmente la tabla icl_translate.
Solución:
Si está experimentando una base de datos grande debido a WPML y desea limpiarla, recomendamos seguir estos pasos:
1. Elimine las cadenas no traducidas en masa siguiendo esta guía: https://wpml.org/documentation/getting-started-guide/string-translation/#deleting-strings
2. Intente reducir aún más las entradas de la base de datos con esta guía: https://wpml.org/errata/reducing-size-of-icl_translate_job-icl_translate-and-other-wpml-tables/

Es importante no eliminar otras entradas que no sean seguras de borrar, ya que podría enfrentar problemas a futuro. Si hay una razón específica por la que desea realizar mantenimiento en estas tablas, podríamos ayudarle de otra manera.

Tenga en cuenta que la solución proporcionada podría ser irrelevante si está desactualizada o no se aplica a su caso. Si es así, le recomendamos abrir un nuevo ticket de soporte. También recomendamos encarecidamente revisar los problemas conocidos en https://wpml.org/known-issues/, verificar la versión de la solución permanente y confirmar que ha instalado las últimas versiones de temas y plugins. Si necesita asistencia adicional, por favor, póngase en contacto con nosotros en el foro de soporte de WPML.

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.

Tagged: 

This topic contains 1 reply, has 2 voices.

Last updated by Alejandro 1 year, 1 month ago.

Assisted by: Alejandro.

Author Posts
April 8, 2024 at 7:33 am #15492791

maksimsG

I would like to have a plugin which cleans up database. Specially icl_translate

April 8, 2024 at 10:30 am #15493628

Alejandro
WPML Supporter since 02/2018

Languages: English (English ) Spanish (Español ) Italian (Italiano )

Timezone: Europe/Rome (GMT+02:00)

Hello!

Our database tables handle the different connections that exist on your site, if you have a big, site you may have big tables. they should not create issues on your end since they are not iterated completely every time.

However, there are a few things you can do to maybe decrease the database tables:

- Follow this guide to delete the untranslated strings from WPML > String Translation (in bulk): https://wpml.org/documentation/getting-started-guide/string-translation/#deleting-strings

- Now follow this guide to try to reduce the entries even more: https://wpml.org/errata/reducing-size-of-icl_translate_job-icl_translate-and-other-wpml-tables/

Please know that this is the only safe way to delete what's not needed, the rest is not safe to delete and you could end up with issues down the road if you delete any other entry.

--------------

May i ask if there's a particular reason for you to want to delete entries or do "maintenance" to these tables? maybe i can try to help you in another way.