What happened to the Database?

Filed under: Technology; Author: Les Bain; Posted: October 17, 2008 at 5:08 pm;

When I work with clients, I create a task database to keep track of tasks and status.  Both the client and I can add and update tasks, and it provides constant visibility.

I create PHP files to drop, define, load, and list the data base files.  I use that technique so that I easily drop, define and rebuild the data base files and reuse the code.

But I had a problem.  The database kept being deleted.  It was very frustrating.  I thought perhaps someone had hacked into the code and was running the database routines to drop and define the database files.

I started to backup the database with any database change, and enhanced both the database backup and restore routines.

Then I put a silent routine into each database PHP routine that sent a silent email with all the information about who was running the routines.

In a few days, I started to get emails showing the database routines were being run and the database files were being dropped.  But when I did a IP reverse lookup I was surprised to find that the routines were being run by the Yahoo Crawl Robot.

I did have a robots.txt file disallowing the folder in question, but that was apparently not working.

I had to add a user id and password.

No Comments »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a comment

If you want to leave a feedback to this post or to some other user´s comment, simply fill out the form below. Just in case you know some HTML, you may use the following tags to format your text:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>