Moderator
Jan Dembowski
(@jdembowski)
Forum Moderator and Brute Squad
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.
http://codex.wordpress.org/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:
http://codex.wordpress.org/Restoring_Your_Database_From_Backup
I am fellow newbie who needs detailed instructions, I hope you understand? 🙂
Thanks
Shebs
Moderator
Jan Dembowski
(@jdembowski)
Forum Moderator and Brute Squad
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:
http://codex.wordpress.org/FAQ_My_site_was_hacked
http://wordpress.org/support/topic/268083#post-1065779
http://smackdown.blogsblogsblogs.com/2008/06/24/how-to-completely-clean-your-hacked-wordpress-installation/
http://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
http://sitecheck.sucuri.net/scanner/
http://www.unmaskparasites.com/
http://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.