Translatepress’s wp_trp_* tables not saved /exported

What is the wpdb prefix of the site?
The tables will not be included if they are not prefixed correctly with the prefix defined in wp-config.php

Hello and thank you for your input ;
The prefix for this website is the default “wp_” for all the tables.
The concerned one is “wp_trp_dictionary_fr_fr_en_us”…

Note that AIO migration correctly exported all the other tables :
wp-options
wp-links
wp-postmeta
wp-posts
etc…

If the prefix is “wp_” and the table is prefixed with “wp_” it would have been included.
I see that you wrote wp-options wp-links with a dash and not underscore – is it a typo or these are the actual table names?

You could extract the archive with https://traktor.wp-migration.com and see in database.sql if the table is included. Search for trp_dictionary

Sorry it was a typo…
All the table are correctly prefixed with “wp_”

Note : I just tried with Blogvault and the plugin can sync correctly all the tables even “wp_trp_dictionary_fr_fr_en_us”.

For Traktor: I installed it, extracted de .sql file but for now I cannot open the 48MB file in Sequel Pro (mac). (Sequel is crashing all time).

You can open it with any editor like Visual Studio Code or Atom

Yes, it’s in the .SQL file:

DROP TABLE IF EXISTS SERVMASK_PREFIX_trp_dictionary_fr_fr_en_us;
CREATE TABLE SERVMASK_PREFIX_trp_dictionary_fr_fr_en_us (
id bigint(20) NOT NULL AUTO_INCREMENT,
original longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
translated longtext COLLATE utf8mb4_unicode_520_ci,
status int(20) DEFAULT ‘0’,
block_type int(20) DEFAULT ‘0’,
original_id bigint(20) DEFAULT NULL,
PRIMARY KEY (id),
UNIQUE KEY id (id),
KEY index_name (original(100)),
FULLTEXT KEY original_fulltext (original)
) ENGINE=InnoDB AUTO_INCREMENT=4289 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

START TRANSACTION;
INSERT INTO SERVMASK_PREFIX_trp_dictionary_fr_fr_en_us VALUES (1,’EN   ES   FR’,”,0,0,1);
INSERT INTO SERVMASK_PREFIX_trp_dictionary_fr_fr_en_us VALUES (2,’MENU’,”,0,0,2);
INSERT INTO SERVMASK_PREFIX_trp_dictionary_fr_fr_en_us VALUES (3,’Accueil’,’Homepage’,2,0,3);
INSERT INTO SERVMASK_PREFIX_trp_dictionary_fr_fr_en_us VALUES (4,’Le’,”,0,0,4);
…

• This reply was modified 4 years, 7 months ago by LauGau.
• This reply was modified 4 years, 7 months ago by LauGau.

OK, so this means that the table is exported. Are you certain that it is missing on import? You can check with phpmyadmin or a similar tool that lets you browse the tables.

Yes I checked with Sequel Pro (via Local by Flywheel).
It make me think that I should try with an online hosting… :-/