Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

PLEASE HELP
 
crichardw
Jr. Member
 
Total Posts:  4
Joined:  2009-05-01
 

I need to import catagories and products from one mysql database to another. Which files in the database do I move over?

Thanks

 
Magento Community Magento Community
Magento Community
Magento Community
 
Adjustware
Guru
 
Avatar
Total Posts:  654
Joined:  2009-05-11
 

You can use built in import/export.  There ara too many tables involved.

 
Magento Community Magento Community
Magento Community
Magento Community
 
crichardw
Jr. Member
 
Total Posts:  4
Joined:  2009-05-01
 

I know that. I need to know what files to move for products and catagories?

 
Magento Community Magento Community
Magento Community
Magento Community
 
Adjustware
Guru
 
Avatar
Total Posts:  654
Joined:  2009-05-11
 

Sorry, what do you mean by “FILES in the DATABASE”?  Do you mean sytem mysql files like *.MYI ?

 
Magento Community Magento Community
Magento Community
Magento Community
 
crichardw
Jr. Member
 
Total Posts:  4
Joined:  2009-05-01
 

What I want to do is move all catagores and products from one mysql database to another one. Not sure what sql files to move?

 
Magento Community Magento Community
Magento Community
Magento Community
 
Adjustware
Guru
 
Avatar
Total Posts:  654
Joined:  2009-05-11
 

There ara no files in the database. There ara tables in the database. Try to move all catalog_* tables, eav_*, product_*, sales_*, wishlist_* tables.  You also might find useful this thread http://www.magentocommerce.com/boards/viewthread/7359/

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