Guest Posted June 14, 2004 Share Posted June 14, 2004 I need to move products w/descriptions,images and all between stores. The store i'm moving it to already has prods. in it that I do not want to overwrite. Downloaded the database I want to move, but it seems to contain more than I want to move. Is this doable, how? Thanks Rolf Link to comment Share on other sites More sharing options...
vasttech Posted June 14, 2004 Share Posted June 14, 2004 If you go into phpmyadmin and go to the export tab you can export just the tables you need. Backup the database you are importing into before you do anything, just in case... Just export the table to a sql file and then run the sql file against your new db. Everything will be brought in. You may have to check the setting on the export to not include the auto_increment fields depending on the table. osCommerce Knowledge Base osCommerce Documentation Contributions Link to comment Share on other sites More sharing options...
Guest Posted June 14, 2004 Share Posted June 14, 2004 Backup the database you are importing into before you do anything, just in case... Already lost a store because the backup failed :o export just the tables you need.If I only Knew. Just export the table to a sql file Did that. (I think) and then run the sql file against your new db. :unsure: How? Thanks Rolf Link to comment Share on other sites More sharing options...
portalplanet Posted June 14, 2004 Share Posted June 14, 2004 Rolf, Hi. In phpMyAdmin there is a "SQL" tab. Click that and use the browse to upload the SQL file you just exported. It may take a while depending upon your database. Justin Link to comment Share on other sites More sharing options...
vasttech Posted June 14, 2004 Share Posted June 14, 2004 export just the tables you need. If I only Knew. If you are just looking for tables that deal with products then it would be all the products tables. There are like 6-7 of them I believe. They all have products in their name though. osCommerce Knowledge Base osCommerce Documentation Contributions Link to comment Share on other sites More sharing options...
Guest Posted June 14, 2004 Share Posted June 14, 2004 Thanks! Rolf 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.