Magento Forum

only reinstall certain segments of db on fresh install
 
idpkender
Jr. Member
 
Total Posts:  18
Joined:  2013-07-01
 

I am working in a dev environment and want to move live

I am wanting to import the following data into an existing database, without overwriting certain theme/SEO changes made in other DB fields
- Users
- Products
- Product Categories
- Order History
- CMS pages

Things I don’t want to affect are header image / alt text, title data, site meta data

 
Magento Community Magento Community
Magento Community
Magento Community
 
Sindre|ProperHost
Mentor
 
Avatar
Total Posts:  1158
Joined:  2008-04-24
 

As for products, customers, etc you could do CSV export/import. However, some of the other things I guess you would have to manually export from the database. It is not straightforward because of all the key relationships, but with a good knowledge of SQL it should be possible.

 
Magento Community Magento Community
Magento Community
Magento Community
 
GoMageTeam
Guru
 
Avatar
Total Posts:  356
Joined:  2013-01-13
Warsaw, Poland
 

Hello,

- Users
- Products
- Product Categories – can be used
- Order History
- CMS pages -You should look for the additional modules that will provide you with this opportunity or make the customization.

 
Magento Community Magento Community
Magento Community
Magento Community
 
idpkender
Jr. Member
 
Total Posts:  18
Joined:  2013-07-01
 

Thanks for the replies

I think I am going to export both SQL databases to file, and copy over the data I want to keep to the old database file, and import that one with the limited data I want to keep from the new one copied in

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top