fastdiet

Heloo,
1.see if theres a way to restore the database to an earlier point, like a windows restore fr example. Would restoring windows entirely to an earlier point solve the problem?
2.This depends on what features are made available by your hosting service.
If you can access the MySQL server directly (typically through port 3306) then you can use a visual client that you install on your computer, connect to the database, and do all your table creation and site maintenance in a visual environment. Many of these are free. I highly recommend SQLYog.
If you have shell access, and you don’t mind memorizing commands and doing some typing, then you can log into your account via a shell client and interact with the server that way. This can be especially convenient if you feel comfortable setting up automated scripts for certain tasks, like backup for example. A good and free client that can also connect to a shell account via a secure, encrypted connection is Putty.
Finally, if you do go the PHPMyAdmin route, be extra careful to read ALL the documentation, because if it’s not configured correctly, there will be some security loopholes, and you run the risk of having hackers playing with your database.
3.Xampp will have phpmyadmin installed.

Type

https://localhost/phpmyadmin (or whatever phpmyadmin is named in your configuration) into your web browser
Log into phpmyadmin with your username and password.
This will connect you to mysql. Choose databases. In the tabs along the top you will see one for imports. Browse to the sql file and hit go.
All should import. If there are any problems with the import it may be because client version of phpmyadmin may be too low for the sql file being imported in which case you will have to run sql file directly from a command line in the mysql client itself.
4.Contact your host, and play on their sympathy. Explain what you did, you feel like a fool, blah blah blah
and ask if there is anyway they can restore that table for you.
They can do it – providing they have backups. Problem is they may want to charge you a nice fee.

Hope help