What are the tables I need to dump to be able to import them in a new installation?
I need this to avoid reinserting all the custom attributes for every new Magento installation.

  • Are you asking about products attributes only or about all EAV entities in general?
    – user487772
    Jun 10, 2013 at 4:40
  • 5
    The most elegant way to solve this is to have your attributes scripted. You should create an extension with an install file where you can add all the attributes. This way you make sure the attributes are added to your magento instance when installing the extension. You also have the possibility to version that install script and make it easier to migrate the data.
    – Marius
    Jun 10, 2013 at 6:44
  • @Marius - I like the idea of having a script to manage the products attributes but I am not a programmer. Can I hire u?
    – Gabriele
    Jun 11, 2013 at 4:37
  • @Tim - Yes it's for product attributes
    – Gabriele
    Jun 11, 2013 at 4:38
  • 2
    @GabrieleCripezzi: I already have a job. I can recommend you this 'gist' that shows you how to add an attribute by code: gist.github.com/mikewhitby/1234721
    – Marius
    Jun 11, 2013 at 6:25

1 Answer 1


To expand on Marius's comment above, the best solution would be an extension which contains setup scripts which insert each of these attributes. n98-magerun.phar can be handy here. n98-magerun.phar dev:module:create can create the basic module structure for you. Then you can use n98-magerun.phar dev:setup:script:attribute to create setup scripts based on existing attributes. There may be some work required to add a setup resource to your module to make the setup scripts run and to test it all, which will require some programming expertise, but that's where I'd start.

You can find n98-magerun on github.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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