klmklm Posted January 6, 2007 Share Posted January 6, 2007 I have trying to download products from one of my sites which is using oscommerce, and re-listing them in another site as I have over 200 products. Any help is appreciated :) Link to comment Share on other sites More sharing options...
wheeloftime Posted January 7, 2007 Share Posted January 7, 2007 I have trying to download products from one of my sites which is using oscommerce, and re-listing them in another site as I have over 200 products. Any help is appreciated :) If the structure of the database for both sites is the same you could export all product related tables from the one site to an SQL file and import that file in this other site. This you can easily do through your phpMyAdmin (or similar) database maintaining tool you should have with your hosting company/companies. Link to comment Share on other sites More sharing options...
klmklm Posted January 7, 2007 Author Share Posted January 7, 2007 If the structure of the database for both sites is the same you could export all product related tables from the one site to an SQL file and import that file in this other site. This you can easily do through your phpMyAdmin (or similar) database maintaining tool you should have with your hosting company/companies. Thanks for the reply, the structure is bit different, so I will struggle to implement your suggestion. What I am doing now is using the easypopulate contribution. I am having some problems with it, but I am sure I'll get where I want soon. Thanks for that. Link to comment Share on other sites More sharing options...
klmklm Posted January 7, 2007 Author Share Posted January 7, 2007 Thanks for the reply, the structure is bit different, so I will struggle to implement your suggestion. What I am doing now is using the easypopulate contribution. I am having some problems with it, but I am sure I'll get where I want soon. Thanks for that. My problem now is when I try to backup a database from one store and export it to another an error in the new store shows the following:- 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = '641' order by r.reviews_id desc limit [TEP STOP] I have an older database saved from previous site, if I back that up it works fine. Are there any different versions of databases that may have caused such a problem Link to comment Share on other sites More sharing options...
wheeloftime Posted January 7, 2007 Share Posted January 7, 2007 My problem now is when I try to backup a database from one store and export it to another an error in the new store shows the following:-I have an older database saved from previous site, if I back that up it works fine. Are there any different versions of databases that may have caused such a problem Take a little read here A 1064 can have different causes. Hard to tell without further information but could be because there is no reviews, or no longer existing, reviews. 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.