Re: Table Records Deleted by anonymous user!

2011-03-14 Thread Joerg Bruehe
Hello! Johan De Meersman wrote: >> From: "Vikram A" > >> Thank you for info. Now we enabled the logs. The DB administrator >> itself made a mistake that he restored the back up > > This may be obvious, but keep your logs on separate disks if you can - full > query logs take quite a bit of I/O

Re: Table Records Deleted by anonymous user!

2011-03-11 Thread Vikram A
Sir, Ok sir, thank you for your advise. We shall keep the logs in another Disk/Drive. From: Johan De Meersman To: Vikram A Cc: MY SQL Mailing list Sent: Fri, 11 March, 2011 2:43:33 PM Subject: Re: Table Records Deleted by anonymous user! From: "V

Re: Table Records Deleted by anonymous user!

2011-03-11 Thread Johan De Meersman
> From: "Vikram A" > Thank you for info. Now we enabled the logs. The DB administrator > itself made a mistake that he restored the back up This may be obvious, but keep your logs on separate disks if you can - full query logs take quite a bit of I/O away, so if you have them on the same disks

Re: Table Records Deleted by anonymous user!

2011-03-10 Thread Geoff Galitz
say that it is done intentionally but could not point anyone because we did not enable the logging feature in MySQL. You already said it yourself: you don't have logging enabled, so that data is not available. If you have binary logs, you could comb through those for the delete statements; t

Re: Table Records Deleted by anonymous user!

2011-03-10 Thread Johan De Meersman
- Original Message - > From: "Vikram A" > > say that it is done intentionally but could not point anyone because > we did not enable the logging feature in MySQL. You already said it yourself: you don't have logging enabled, so that data is not available. If you have binary logs, you

Table Records Deleted by anonymous user!

2011-03-10 Thread Vikram A
Dear Experts!     Our institution has a centralized MySQL server which is accessed by several clients. Today we found that a particular table's records are missing. We could say that it is done intentionally but could not point anyone because we did not enable the logging feature in MySQL. I w