Guest Posted March 10, 2004 Share Posted March 10, 2004 I need to restore to a backup of my shop, but I don't want to loose the products that have been entered since the backup.. (something like 400 prods!) What is the best way to go about this. What tables do I need to backup/create temp store tables/or whatever is the best way. I was thinking of creating temp tables based on the structure of the tables I need and then insert them those rows into the real tables once the backup has been restored. Is this the way to go about this??? Suggestions? Link to comment Share on other sites More sharing options...
Nick Weisser Posted March 10, 2004 Share Posted March 10, 2004 If your products don't have any attributes you need to backup the products and products_description tables. I would export the data (without structure) with phpMyAdmin, restore the old database and then check the products_ids before inserting again. Maybe you have to adjust the product_ids manually? Regards, Nick P.S. You would have done this anyway, I guess, but just to remind you: better backup your entire database before doing anything. ;) Link to comment Share on other sites More sharing options...
Guest Posted March 12, 2004 Share Posted March 12, 2004 Hey Weisser, I basically ended up doing something similar with every table I thought was related to products. I created temp tables in and did a insert into select *. I then inserted in the backup db tables where those rows did not exist. The prod_id's lined up b/c thankfully, I asked them to stop entering products when I realized there was a problem. I had a good backup with the ID's. I just inserted where the id's began. It may not be just right?? But it works for now and if I have to do some more data manipulation that won't be as bad as losing all that data. Thanks for your input. Phil Link to comment Share on other sites More sharing options...
Nick Weisser Posted March 12, 2004 Share Posted March 12, 2004 You're welcome. Link to comment Share on other sites More sharing options...
241 Posted March 12, 2004 Share Posted March 12, 2004 you can also do a full backup from the admin panel, tools, backup database, this gives the full sql which can be downloaded and edited at your local machine No longer giving free advice. Please place deposit in meter slot provided. Individual: [=] SME: [==] Corporation: [===] If deposit does not fit one of the slots provided then you are asking too much! Is your Osc dated try Phoenix raising oscommerce from the ashes. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.