Where Is This Blog Yesterday?

This blog has gone to take a little vacation a while ago in Manila. :p

Well, actually I was updating my database. Changing the database structure so that it will be more secure and hardly to attack using SQL injection.

I’m editing the .sql file using my Dreamweaver CS3.  Yeah, Dreamweaver can edit .sql files too.  Try it if you don’t believe me.  I just use the find function. ( ctrl + f ) and choose to replace all the match case.  Very convenient.

Still do not know what I’m talking about?
Well, this website is hacked once.  You can see/read my disappointment here at What a Good Luck!
So, as a future precaution, I change the table name wp_ to something_

 

More Secure Database Tables Prefix

This is practically can protect your blog from SQL injection attack which can delete your database, if it execute the sql queries of drop tables wp_ kind like that.  So, the precaution, is change it to something else…  Maybe your favorite celebrity name.  Like shaina_ :lol:

But Seriously, it will make you got a heart attack if you tend to get things easy.

I’ll make a tutorials on this later on.  How to make sure you won’t miss it?  Stay subscribe to my feed, via email is the most convenient way.  Do not know what is feed?  You can get to know with her at What is Feed and RSS?

 

 

 

What a Good Host

I export the database and edit it, but when I try to import it back into the dropped tables, I can’t.  It said it have reach its maximum execution period.
But, fortunately the Namsahaz support team help me to import it and here it is my blog gone live again.

And then, I received an email from them again telling me to insert some code into the .htacces because my permalinks is broken.  Then I visits my the homepage and try to click any post link.  Well, it returns an error 404, not found.  Nice support! ;-)