rockpretty Posted November 9, 2008 Share Posted November 9, 2008 Can I import or export JUST the customer and product info from my database? If so how do I do this? Can I upload a 2nd shopping cart/website to my existing site? The reason I ask is I want continue to ''play'' around with my shop with design and contributions but I'm tired of messing up my existing live store and having to delete and start over causing down time online. And if I can upload a 2nd store (in a buried folder) can I use my existing database or is it safer/better to create a new one? Thanks Link to comment Share on other sites More sharing options...
ozEworks Posted November 9, 2008 Share Posted November 9, 2008 Teh Customer entity is defined by several customer tables + the address table. Products are also defined by several tables. So yes you can export them but you need to export all tables related to the entity. Provided your databsae schema is the same you can import the contents of a different osCommerce database. But why not just backup the database before you make changes? Link to comment Share on other sites More sharing options...
rockpretty Posted November 11, 2008 Author Share Posted November 11, 2008 Teh Customer entity is defined by several customer tables + the address table. Products are also defined by several tables. So yes you can export them but you need to export all tables related to the entity. Provided your databsae schema is the same you can import the contents of a different osCommerce database. But why not just backup the database before you make changes? I thought I had a bug or messed something up in my database. I was just curious if I started with a fresh DB if I could still import in the customer list. Luckily it turns out the DB is ok Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.