Claudia Posted February 17, 2023 Share Posted February 17, 2023 I'm closing one store and starting a new one. I'd like to keep all the customer and order info from the old store either in databases in the new store or an Excel worksheet similiar to the catalogue export. Any thoughts how I can do this? Thanks in advance Quote Link to comment Share on other sites More sharing options...
bsmither Posted February 17, 2023 Share Posted February 17, 2023 A quick solution is to simply point the new store to use the existing database. If the new store hosting account cannot reach the existing database, then have either CubeCart or phpMyAdmin make a backup of the database, copy the file over to the new store, and restore from there. phpMyAdmin can also export database tables to CSV files. Only if there is a need to formulate new data from the existing data would you need an Export module for CubeCart. Quote Link to comment Share on other sites More sharing options...
Claudia Posted February 17, 2023 Author Share Posted February 17, 2023 I don't want to lose any info in the new store. I have the same host for both stores, Ian. How would I do what you say above. Quote Link to comment Share on other sites More sharing options...
bsmither Posted February 17, 2023 Share Posted February 17, 2023 (edited) "I don't want to lose any info in the new store." What info in the new store would be in danger of being lost? During setup, one can specify a distinct table prefix. All the existing tables used by the shuttered store would not be disturbed. The data in the existing set of tables used by the shuttered store would not be available to the new store: because of different table prefixes. Edited February 17, 2023 by bsmither Quote Link to comment Share on other sites More sharing options...
Claudia Posted February 17, 2023 Author Share Posted February 17, 2023 Figured it out. Thanks for once again leading me in the right direction Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.