Table "products" disappeared and can't be restored

[neurotoxic]

I am building a website for a friend and I unfortunately let him look at PHPMyAdmin installed on his website to see if no product's weight was still at "zero".

 

Somehow, he managed to delete completely the table "products" while trying to change some weights from PHPMyAdmin in that table. At least, I thought the table was deleted. So I wrote to the hosting company and asked them to restore a backup that was older than the day the problem occured. To no avail.

 

They restored an old backup, but I still can't see the table "products" and I am getting the same error message (See it here):

 

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

 

select distinct p.products_id, pd.products_name from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_ordered desc, pd.products_name limit 10

 

[TEP STOP]

 

That can be seen on the main page.

 

So I am deeply confused. I can't understand what might've happened. Does anyone have some idea as to what went wrong?

[Guest]

open your backup in a text editor and search for products

see if it is even there