export and import phrases - How-To and Troubleshooting

RE: export and import phrases

Astghik — Thu, 18 Apr 2019 13:47:35 +0000

Hi @itlr,

I'm sorry, but I don't have any ETA yet. We do all our best to update the plugin asap.

RE: export and import phrases

itlr — Thu, 18 Apr 2019 02:23:44 +0000

Do you have an ETA for phrase export/import to become available?

RE: export and import phrases

Astghik — Mon, 04 Mar 2019 14:41:24 +0000

yes @theplacetobe you need to export DB _wc_phrases table and import to new websites DB.

I'm leaving articles that should be useful below.

How to backup or export a database or table: https://help.dreamhost.com/hc/en-us/articles/214395738-phpMyAdmin-How-to-backup-or-export-a-database-or-table

How to import and export a MySQL database: https://mediatemple.net/community/products/dv/204403864/export-and-import-mysql-databases

RE: export and import phrases

theplacetobe — Mon, 04 Mar 2019 14:05:30 +0000

OK fine, any short term solution by digging in the database?

If you tell me where the data is, I can get it done on my own.

I have almost 100 sites to update, so I don't want to edit them 1 by 1...

It looks like all the phrases are in the table wp_N_wc_phrases, where N is the site id of the site in the multisite install.

So export this table and import it in another site would do the trick?

RE: export and import phrases

Astghik — Mon, 04 Mar 2019 13:28:24 +0000

Hi @theplacetobe,

I'm sorry, but wpDiscuz allows export/import all option, but not phrases yet. We've already added it in our to-do list. We'll add it in next version releases.

export and import phrases

theplacetobe — Mon, 04 Mar 2019 11:43:10 +0000

I have customized the phrases used by WPDiscuz for notification emails.

Now I would like to use my phrases on all the sites I have on my multisite install?

How can I do that. Do you have an export/import function, or can I do it "manually" by digging in the database with PHPMyAdmin?

Thanks for feedback, I hope a solution exists, it would save me a lot of time.