6

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
2

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.

| improve this answer | |

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