944,038 Members | Top Members by Rank

Ad:
  • MySQL Discussion Thread
  • Unsolved
  • Views: 1509
  • MySQL RSS
Jan 20th, 2007
0

MySQL DB just DROPPED!

Expand Post »
Hi,

im running this website,,,worked so hard on it for about 5 months straight. i got it finally up and runnin, and the first 3 months went smooth.

all of a sudden my MySQL DB drops...every table inside...just GONE.

my site went down and error messages were received throughout my entire perl application.

Is there anyway I can see if this was an attack? Was it a problem on my host side ( i have asked them but no response yet)?

I've been programming with PERL for about 5 years and know how to prevent SQL Injections.

Or I could be wrong...who knows. But another reason why i dont think its my programming side is that the user I connect to my database with, does not have any "DROP, or DELETE" privileges...so I don't know how my ENTIRE database tables have dropped.

J/w , what should I do and what procedures can I run to find out what went wrong. This is my first time experiencing such a thing.

Thanks,
Bobby

Thanks,
Bobby
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
bobby08 is offline Offline
10 posts
since Aug 2006
Jan 22nd, 2007
0

Re: MySQL DB just DROPPED!

Click to Expand / Collapse  Quote originally posted by bobby08 ...
Hi,

im running this website,,,worked so hard on it for about 5 months straight. i got it finally up and runnin, and the first 3 months went smooth.

all of a sudden my MySQL DB drops...every table inside...just GONE.

my site went down and error messages were received throughout my entire perl application.

Is there anyway I can see if this was an attack? Was it a problem on my host side ( i have asked them but no response yet)?

I've been programming with PERL for about 5 years and know how to prevent SQL Injections.

Or I could be wrong...who knows. But another reason why i dont think its my programming side is that the user I connect to my database with, does not have any "DROP, or DELETE" privileges...so I don't know how my ENTIRE database tables have dropped.

J/w , what should I do and what procedures can I run to find out what went wrong. This is my first time experiencing such a thing.

Thanks,
Bobby
Have you checked the logs?

Is this db on your own machine or hosted?

Did you take a backup?
pty
Reputation Points: 64
Solved Threads: 39
Posting Pro
pty is offline Offline
530 posts
since Oct 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MySQL Forum Timeline: Hi, need advice on sql statement and table structure
Next Thread in MySQL Forum Timeline: Help i'm not sure if this table set up will work





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC