Title: export / import – SQL files
Last modified: February 17, 2022

---

# export / import – SQL files

 *  [giraffe75](https://wordpress.org/support/users/giraffe75/)
 * (@giraffe75)
 * [4 years, 4 months ago](https://wordpress.org/support/topic/export-import-sql-files/)
 * Hello,
 * thanks for this great plugin!
 * The issue I have:
 * **Where do I find the SQL files from this plugin?**
 * I can export / import the 3 Woocommerce shipping SQL files:
 * xxx_woocommerce_shipping_zones.sql
    xxx_woocommerce_shipping_zone_locations.sql
   xxx_woocommerce_shipping_zone_methods.sql
 * But it doesn’t include any data from this plugin.
 * OR is there any other way to export and import this data?
 * I ship to 50+ countries with different shipping methods, zones and rates AND 
   I have 3 websites. So I really need a way to do postal rate updates only once,
   not 3 times.
 * Thanks,
    Gi
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fexport-import-sql-files%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

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

 *  Thread Starter [giraffe75](https://wordpress.org/support/users/giraffe75/)
 * (@giraffe75)
 * [4 years, 3 months ago](https://wordpress.org/support/topic/export-import-sql-files/#post-15382646)
 * Please, can someone help me?
 * I need to know, where the data of this plugin is being stored, either per FTP
   or SQL (phpMyAdmin).
 * I need to “copy” (ex- / import) all my entries (shipping rates, etc) from 1 website
   to 2 other websites.
 * Thankful for any reply.
 *  Thread Starter [giraffe75](https://wordpress.org/support/users/giraffe75/)
 * (@giraffe75)
 * [4 years, 3 months ago](https://wordpress.org/support/topic/export-import-sql-files/#post-15383455)
 * OK, I found the entries in table: “xxx_options” named “woocommerce_oik_weight_zone_shipping_xxx_settings”.
 * BUT when I try to filter, select and export (via the export button at the bottom
   in “Query results operations”), it says:
 *  “**Error: Token mismatch**”
 * Any ideas?
 *  Thread Starter [giraffe75](https://wordpress.org/support/users/giraffe75/)
 * (@giraffe75)
 * [4 years, 3 months ago](https://wordpress.org/support/topic/export-import-sql-files/#post-15385906)
 * I managed to export the whole “xxx_options” table now, but when I want to open
   it, it says
 * “**The data could not be loaded completely because the maximum number of characters
   per cell was exceeded.**”
 * It would really be great, if the plugin-maker(s) could offer any solution for
   exporting and importing the plugin-data. I’d also be interested in a pay-version
   of the plugin, if that would offer an export/import solution.
 * (Otherwise this would rather develop into a phpMyAdmin SQL topic here.)

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

The topic ‘export / import – SQL files’ is closed to new replies.

 * ![](https://ps.w.org/oik-weight-zone-shipping/assets/icon-256x256.jpg?rev=1468722)
 * [Weight zone shipping for WooCommerce](https://wordpress.org/plugins/oik-weight-zone-shipping/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/oik-weight-zone-shipping/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/oik-weight-zone-shipping/)
 * [Active Topics](https://wordpress.org/support/plugin/oik-weight-zone-shipping/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/oik-weight-zone-shipping/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/oik-weight-zone-shipping/reviews/)

## Tags

 * [export](https://wordpress.org/support/topic-tag/export/)
 * [files](https://wordpress.org/support/topic-tag/files/)
 * [Import](https://wordpress.org/support/topic-tag/import/)
 * [shipping](https://wordpress.org/support/topic-tag/shipping/)
 * [sql](https://wordpress.org/support/topic-tag/sql/)

 * 3 replies
 * 1 participant
 * Last reply from: [giraffe75](https://wordpress.org/support/users/giraffe75/)
 * Last activity: [4 years, 3 months ago](https://wordpress.org/support/topic/export-import-sql-files/#post-15385906)
 * Status: not resolved