Title: <abbr title="Not Safe For Work / Mature content">[NSFW]</abbr> translation data in sql database
Last modified: October 5, 2021

---

# [NSFW] translation data in sql database

 *  Resolved [sstrosar](https://wordpress.org/support/users/sstrosar/)
 * (@sstrosar)
 * [4 years, 8 months ago](https://wordpress.org/support/topic/translation-data-in-sql-database/)
 * Hi, I am using wpglobus plugin for several languages at my site. Nature of the
   site requires that I do manual import of pages trough wp export import plugin
   which works just fine.
 * I have exported one of the pages with 2 language translation and it seems fine
   on export since title is marked accordingly to wp globus fields
    {En}title{en}
   etc ( i know this is not right, I am just making a point here for you to see 
   that I know what I am talking about)
 * Let me just hop to the question
 * This specific post also has yoast seo title and description translated but I 
   cannot find that data in my export. I only get english ( default languahe) in
   that field.
    Is this data stored somewhere where the actuall wp export plugin
   cannot reach it or what is happening? Or should yoast data look like the title
   with {en} markers?

Viewing 5 replies - 1 through 5 (of 5 total)

 *  Plugin Support [Alex Gor](https://wordpress.org/support/users/alexgff/)
 * (@alexgff)
 * [4 years, 8 months ago](https://wordpress.org/support/topic/translation-data-in-sql-database/#post-14941731)
 * You can find the multilingual Yoast SEO title, description (with language marks
   inside) in the `postmeta` table. This also applies to others meta, that can be
   found by `_yoast_wpseo` mask.
 *  Thread Starter [sstrosar](https://wordpress.org/support/users/sstrosar/)
 * (@sstrosar)
 * [4 years, 8 months ago](https://wordpress.org/support/topic/translation-data-in-sql-database/#post-14942061)
 * Thank you for your answer!
 * So in theory if I did an impprt of all data marked like it should be marked this
   should work. So all of the data is stored in one line in database. What I want
   to say is that database is not using different lines for different languages?
 *  Plugin Support [Alex Gor](https://wordpress.org/support/users/alexgff/)
 * (@alexgff)
 * [4 years, 8 months ago](https://wordpress.org/support/topic/translation-data-in-sql-database/#post-14942593)
 * WPGlobus stores all translations in one line.
    BTW you should export/import Yoast
   DB tables too. Table names is yoast_indexable, yoast_indexable_hierarchy and 
   so on.
 *  Thread Starter [sstrosar](https://wordpress.org/support/users/sstrosar/)
 * (@sstrosar)
 * [4 years, 8 months ago](https://wordpress.org/support/topic/translation-data-in-sql-database/#post-14949425)
 * Yes, importer does it by selecting the respective fields that are relevant to
   post. I wasn’t sure if wpglobus had any fields that were outside of standard 
   post. Now when I know that every translation is stored in respective field of
   data, it makes import so much easier.
 * Ps. What I have noticed is:
    When export is done, there is a field called something
   like wpglobus language and in that field is stored language code (en) for the
   language of post translation that was active when save button was pressed. For
   example if I was editing german last, it would store “ge” in the field. What 
   if I did an input of all the language codes in there like: en,ge,es etc?
 * On top of that when last active language was set, data in yoast column in the
   list of posts is in that language. – reffering to admin backend posts list.
 *  Plugin Support [Alex Gor](https://wordpress.org/support/users/alexgff/)
 * (@alexgff)
 * [4 years, 8 months ago](https://wordpress.org/support/topic/translation-data-in-sql-database/#post-14949716)
 * Sure. You can edit `wpglobus_language` meta. But it is unuseful in your case.

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘[NSFW] translation data in sql database’ is closed to new replies.

 * ![](https://ps.w.org/wpglobus/assets/icon-256x256.png?rev=1069705)
 * [WPGlobus](https://wordpress.org/plugins/wpglobus/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wpglobus/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wpglobus/)
 * [Active Topics](https://wordpress.org/support/plugin/wpglobus/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wpglobus/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wpglobus/reviews/)

 * 5 replies
 * 2 participants
 * Last reply from: [Alex Gor](https://wordpress.org/support/users/alexgff/)
 * Last activity: [4 years, 8 months ago](https://wordpress.org/support/topic/translation-data-in-sql-database/#post-14949716)
 * Status: resolved