MrsZippy Posted February 25, 2009 Share Posted February 25, 2009 Id like to rebuild our shop. Its 2 years old, was the first one I did and now its looking a bit outdated and beginnerish. Im now pretty comfortable with OSC having done 2 shops in the past year and each one is better than the last. I would like to be able to install a newer version of the shop in a new location, add all the contributions i require and then turn the shop live. Im pretty sure I can get our host to arrange a wildcard redirect to the new store location. The bit im confused about is the database. Because its a live shop we have customers, products, orders etc within the shop and I wouldn't want to lose all this data. Is it possible to copy the data from one DB to another. I can use MySQL thro phpmyadmin but i dont really understand it fully. By copying the data am I likely to lose all the cutomers passwords? Would data import after changes had been made to a new DB with the new contributions or would it be better to use a copied version of my existing DB from the start and then make changes to that rather than import data afterwards? Any help or advice anyone can offer will be very much appreciated. Our existing store does need a new look and redesign and the easiest way to do this does look to be a complete Re-Build. thanking You in advance Jo Smile: A curve that can make a million things straight Link to comment Share on other sites More sharing options...
fbrace Posted February 25, 2009 Share Posted February 25, 2009 Id like to rebuild our shop. Its 2 years old, was the first one I did and now its looking a bit outdated and beginnerish. Im now pretty comfortable with OSC having done 2 shops in the past year and each one is better than the last. I would like to be able to install a newer version of the shop in a new location, add all the contributions i require and then turn the shop live. Im pretty sure I can get our host to arrange a wildcard redirect to the new store location. The bit im confused about is the database. Because its a live shop we have customers, products, orders etc within the shop and I wouldn't want to lose all this data. Is it possible to copy the data from one DB to another. I can use MySQL thro phpmyadmin but i dont really understand it fully. By copying the data am I likely to lose all the cutomers passwords? Would data import after changes had been made to a new DB with the new contributions or would it be better to use a copied version of my existing DB from the start and then make changes to that rather than import data afterwards? Any help or advice anyone can offer will be very much appreciated. Our existing store does need a new look and redesign and the easiest way to do this does look to be a complete Re-Build. thanking You in advance Jo Using Phpadmin you can export your entire database as one file then upload to new server and install to new database using the runsql commands. That assumes that your new database will be a carbon copy of the old one. When I upgraded OSC from a previous version to the current (not 3.0) there were some differences in some tables. I found that it was easier to do this with the data from individual categories, one at a time. You might wait for the OSC3.0 release, because it is supposed to have a database update utility, that could make this easier. You might also want to put your shop in "maintenance" mode, so that no new database entries are made to the old, while setting uo the new. Either way, BACKUP BACKUP BACKUP!!!!! Frederick C Brace,III PA-C www.21st-tees.com (osc) www.tanda-designs.com (osc) Link to comment Share on other sites More sharing options...
MrsZippy Posted February 26, 2009 Author Share Posted February 26, 2009 Using Phpadmin you can export your entire database as one file then upload to new server and install to new database using the runsql commands. That assumes that your new database will be a carbon copy of the old one. When I upgraded OSC from a previous version to the current (not 3.0) there were some differences in some tables. I found that it was easier to do this with the data from individual categories, one at a time. You might wait for the OSC3.0 release, because it is supposed to have a database update utility, that could make this easier. You might also want to put your shop in "maintenance" mode, so that no new database entries are made to the old, while setting uo the new. Either way, BACKUP BACKUP BACKUP!!!!! cheers for the heads-up on V3. I'll have a look about and see what I can find out. If all else fails I'll try a practise run using the method you used - one db section at a time. thank You Smile: A curve that can make a million things straight Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.