How to export Shipping data using the database entries (SQL) to another installation

[hotlimbo]

Hi,

I hope somebody can help!

My shipping rates for multiple carriers is a huge amount of data. (3 days of typing and checking using the manual method via the back-office). Since I want to use another installation of Prestashop already installed for testing purposes I do not want to re-enter manually all the shipping and carrier data.

Which tables of the Prestashop database hold that data?

NOTE: I do not want to export the entire database to the test version the test version has updates and stuff I do no want to overwrite. All I need is the shipping and carriers to change.

My version of PrestaShop is 1.6.1.24

 

TIA

Edited June 19, 2020 by hotlimbo (see edit history)