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 '17 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? – Giel Berkers Aug 21 '17 at 20:16
  • Use setup:backup --db and setup:rollback --db-file="..." command-line? – Nolwennig Nov 14 '17 at 14:49

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.

protected by Community Sep 19 '17 at 8:28

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).

Would you like to answer one of these unanswered questions instead?

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