Search code examples
mysqlwordpresspolylang

How to export Wordpress posts database tables with polylang?

My current site is outdated (not updated for a long time), so created WordPress with all updated plugins, etc. I am using Polylang on my website for the language switching (English = Arabic), and I need to export all my posts in English and Arabic to my newly created WordPress website.

I tried to export/import with the default that comes with WordPress, but they don't map the language posts and I don’t want to remap the English to Arabic pages/posts as they are around 2500+ items.

If I can do the export /import from the database side, which all tables to be exported so I don't miss out on the Polylang translation strings and mappings.

Thanks

Solution

  • I found a few tables that seem to be used by Polylang plugin

    wp_terms (contains pll_) wp_term_taxonomy (contains post_translations)