Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

database table structure and restore


Guest

Recommended Posts

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

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

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

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! :P

Is your Osc dated try Phoenix  raising oscommerce from the ashes.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...