I'd like to import and export using two Magento 2, among two environments. I know that I can't do it natively, so how can I do using MySQL or some free tool?

  • 1
    Magento does not provide such functionality. You can develop it by yourself or buy an extension.
    – KAndy
    Feb 3, 2017 at 15:49
  • In response to @leo s' answer: is it a migration to an identical setup? (like from staging to production or vice versa?) Or are it two different Magento 2 sites? Aug 21, 2017 at 20:16
  • Use setup:backup --db and setup:rollback --db-file="..." command-line?
    – Nolwennig
    Nov 14, 2017 at 14:49

1 Answer 1


If you are importing/exporting categories on the same Magento, which means both Magento has same EAV category attributes, you can use the native way to export SQL to the destination. enter image description here

enter image description here

Using HeiSQL, use export database then tick all table with catalog_category prefix and export to your server database directly.

Not the answer you're looking for? Browse other questions tagged or ask your own question.