<div>
Can I identify which user has deleted the trigger?<br />

</div>


Can I identify which user has deleted the trigger?


<div>
You can use mysqlbinlog to read the transactions happened in database through Binary Log files.<br />
<br />
For more info:<br />
<br />
<a href="http://www.mydigitallife.info/2007/10/06/how-to-read-mysql-binary-log-files-binlog-with-mysqlbinlog/" rel="ugc">http://www.mydigitallife.info/2007/10/06/how-to-read-mysql-binary-log-files-binlog-with-mysqlbinlog/</a><br />
<br />
But in your case to track it out provided it is not disabled by administrator in my.cny configuration file.
</div>


You can use mysqlbinlog to read the transactions happened in database through Binary Log files.

For more info:

http://www.mydigitallife.info/2007/10/06/how-to-read-mysql-binary-log-files-binlog-with-mysqlbinlog/ [http://www.mydigitallife.info/2007/10/06/how-to-read-mysql-binary-log-files-binlog-with-mysqlbinlog/]

But in your case to track it out provided it is not disabled by administrator in my.cny configuration file.

<div>
<div class="content wysiwyg-content">
HI,<br />
<br />
By mistake a trigger has been deleted.<br />
I am using MySQL 5.1 installed in CentOS 5<br />
<br />
Is there any ways to recover the trigger.<br />
<br />
Thanks.
</div>
</div>


HI,

By mistake a trigger has been deleted.
I am using MySQL 5.1 installed in CentOS 5

Is there any ways to recover the trigger.

Thanks.

Recover Trigger in MySQL

A Linux distribution is an operating system made as a software collection based on the Linux kernel and, often, on a package management system and are available for a variety of systems. A typical Linux distribution comprises a Linux kernel, GNU tools and libraries, additional software, documentation, a window system (the most common being the X Window System), a window manager, and a desktop environment. Most Linux systems are open-source software made available both as compiled binaries and in source code form, allowing modifications to the original software. Over three hundred distributions are in active development, including commercially backed distributions (such as Fedora, openSUSE and Ubuntu) and community-driven distributions (such as Debian, Slackware, Gentoo and Arch Linux).

Linux Distributions

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.