What do I do when my site gets hacked or gets hit by viruses?

I deleted your other duplicate topic, please be careful not to do that as it makes it harder to provide you with support.

This should work for that .sql file.

https://codex.www.ads-software.com/Restoring_Your_Database_From_Backup

If the site gets hacked or gets a virus

If that happens then restoring your database is the least of your worries. You’d have to delouse your installation first then worry about restoring your database.

Hi Just so I understand as I am a newbie, in the event of an virus or hack attached.

I would delete the wordpress files vie ftp, re-install fresh copy and them restore DB as instructed here:

https://codex.www.ads-software.com/Restoring_Your_Database_From_Backup

I am fellow newbie who needs detailed instructions, I hope you understand? ??

Thanks
Shebs

Welcome to using WordPress. I think you’ll like it but there is a small learning curve.

You’re already on the road to Doing It The RIght Way™ because you are thinking about backups, being able to restore, and planning for the worst.

That’s a great start and I think you’re doing fine. ?? Just make sure your backups are stored off of your server too.

I am fellow newbie who needs detailed instructions, I hope you understand? ??

I do and sincerely hope that you (or anyone) do not get hacked and have to deal with that.

This is the often quoted list of articles that get posted when someone is hacked.

You need to start working your way through these resources:
https://codex.www.ads-software.com/FAQ_My_site_was_hacked
https://www.ads-software.com/support/topic/268083#post-1065779
https://smackdown.blogsblogsblogs.com/2008/06/24/how-to-completely-clean-your-hacked-wordpress-installation/
https://ottopress.com/2009/hacked-wordpress-backdoors/

Anything less will probably result in the hacker walking straight back into your site again.

Additional Resources:
Hardening WordPress
https://sitecheck.sucuri.net/scanner/
https://www.unmaskparasites.com/
https://blog.sucuri.net/2012/03/wordpress-understanding-its-true-vulnerability.html

Don’t become intimidated! Those articles are all good but delousing is a lot of work. ??

It’s just that if your site does get compromised then you need to harden your installation and delouse it first. Once that’s done and you’ve validated that your backup is safe then you can worry about restoring it.