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.
thanks
-
Are you asking about products attributes only or about all EAV entities in general?– Tim BezhashvylyCommented Jun 10, 2013 at 4:40
-
5The 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 ♦Commented 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?– GabrieleCommented Jun 11, 2013 at 4:37
-
@Tim - Yes it's for product attributes– GabrieleCommented 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 ♦Commented Jun 11, 2013 at 6:25
|
Show 3 more comments
1 Answer
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.
