Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Retrieving Deleted Tables


crumpf77

Recommended Posts

Posted

Need Help. I deleted the Product Table. Can it be retrieved? If so, how?

 

Thank you.

 

Cliff

 

 

1146 - Table 'crumpf77_tbl.products' doesn't exist

 

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '1'

 

[TEP STOP]

Posted

If you have a backup then you can recover just one table by editing the backup and by using just the product table records in phpmyadmin you can get it back.

 

If you don't have a back up you are a bit stuck.

 

HTH

 

G

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Posted

Thank you. I backed up my database just before I deleted the products table and was able to retrieve it. Dodged a bullet.

 

Thanks again.

 

Cliff

Posted

Excellent news!!

 

G

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Archived

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

×
×
  • Create New...