| Author |
Verify DML(Mysterious DROP TABLE command in production)
|
|
| Clyde Lewis 2005-09-26, 8:24 pm |
| Guys,
Our production database had a table that was suddently dropped "a
mystery". I need to find out if there is a way to find the user account
that performed this function. No one is taking ownership and I need to
know if there is a way to find out.
Thanks in advance
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
| |
| SGreen@unimin.com 2005-09-26, 8:24 pm |
| --=_alternative 0071FB0585257088_=
Content-Type: text/plain; charset="US-ASCII"
Clyde Lewis <cllewis@gpi.com> wrote on 09/26/2005 02:44:40 PM:
> Guys,
>
> Our production database had a table that was suddently dropped "a
> mystery". I need to find out if there is a way to find the user account
> that performed this function. No one is taking ownership and I need to
> know if there is a way to find out.
>
> Thanks in advance
>
Have you checked your binlogs? Each command is listed along with the user
account that was used to execute it and a timestamp for proper
replication.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
--=_alternative 0071FB0585257088_=--
| |
| Clyde Lewis 2005-09-26, 8:24 pm |
| I did check the binlog and saw that the command ran along with the
timestamp. Is there a way to figure out who ran the command?
SGreen@unimin.com wrote:
>Clyde Lewis <cllewis@gpi.com> wrote on 09/26/2005 02:44:40 PM:
>
>
>
>
>
>
>
>Have you checked your binlogs? Each command is listed along with the user
>account that was used to execute it and a timestamp for proper
>replication.
>
>Shawn Green
>Database Administrator
>Unimin Corporation - Spruce Pine
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
|
|
|
|