Last Monday night was horrible for me.I meshed up with my wordpress blog Blogging Park again.This time it was a wordpress security plugin which bring this horrible night for me.I can remember since the launching of my blog,I lost total administration control over my blog.But I am confused that every time this is not alarming me,not stopping me to play with codex.How could I do that every time when I am doing something very serious experiment with my wordpress blog.Last time there was a moment(fraction of second) when I was thinking not to play with such risky game but I just overlook the thinking and proceed to play the game,and result was I saw fatal error after some modifying with a wordpress security plugin.Read my horrible story so that it can learn you something which will prevent you to do such risky play.

WordPress Security Plugin :

The victim was my wordpress security plugin which was WP-Security plugin developed by websitedefender.com,though I have reviewed and read some good feedback from the user of this plugin.Unfortunately it brings lot of worse thing for me.
I had this security plugin for few days.It has some good option to check,but two of them were not working for me.Perhaps these two options were their drawback,so I just activate the plugin to see if any security issue and after then de-activate this.It was my routine practice,but few days ago there was an updated version and I did this to check what new things are there in their upgraded version.In the upgraded version we can change our wordpress database table prefix which are by default “wp_”.If you change it with your any letter or phrase then it can stop any SQL  injection attack.So from the plugin dashboard I just proceed to do this,everything was fine but when I was going to clear my cache a screen comes with some fatal error in my “wp-config” file.
I was just shocked and read the line carefully.The error indicating in line 30.Without doing anything I just go for my ftp file up-loader and change the wp-config file with my previously backed-up.But luck was not with me as I was unaware of the real fact what are happening behind my eyes.Actually the fact was my security plugin only was able to change some of my database table prefix name,rest were unchanged.So it brings big confusion with my hosting server and wordpress software.They can’t recognize my files and database.

Careful about wp-security plugin :

Yes if you are using any of these security plugin the be careful about changing any database structure.I will advice not to change any default structure if you are not a seo specialist .WP-security plugin will rename half of your database table prefix name,rest might be unchanged,so it might occur big accident with your blog.

Backup your database :

Now everyone are careful about backup their files and database.You can read how to backup your wordpress blog in my post,anyway remember backup should be in different method.I can give you some list of method here…
1)backup the post,comments etc through wordpress tools section.
2)Backup your whole wp-content,wp-include,wp-admn file (Backing up all files of root directory are very good)
3)Backing up your database file in sql format,Do this through any plugin,manual backup from PhpMyAdmn(through your hosting control panel)are better.

This backups are always save you if you face any problem with your wordpress software.

What I did to recover my blog ?

I was searching here and there to find a solution for this mesh up but nothing was suitable for me.Then I decided to go my hosting control panel to see changes with my database table prefix (As this was my last game with codex).I never use PhpMyAdmin before this,so tried this one to see database table structure.I was just stunned when saw that half of my table has different prefix name.I just realized the fact and remove the table first and upload it from my previously backed-up sql table file.After that I refresh my blog page it was great to watch my page after 15 hours.

But the story was not ended,I noticed only my homepage are accessible but no other pages was loading.I then searching some clue on Google,someone was saying problem might be in your permalinks setting if your pages are not loading except homepage.I just went for permalinks setting,but it was well enough as I had earlier.But yet I just click on save settings button to see whether it might bring some changes.Yes it did.Actually after loading whole wordpress file and changing database table,it needed some cache clearing.

Problem with page loading :

I must include a short tips on not loading page.If you face ever any problem with wordpress page loading then ob-course once check your permalink setting.It might create problem.If you have change your permalink setting and once discover your page are not loading except homepage then it might happen any problem with your permalink settings.So check it again and again.
Thanks.