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 '13 at 4:40
  • 4
    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 '13 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 '13 at 4:37
  • @Tim - Yes it's for product attributes – Gabriele Jun 11 '13 at 4:38
  • 1
    @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 '13 at 6:25

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, privacy policy and cookie policy

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