CODEWITHSUNDEEP
mysql
Vladimir Sarkisyan
Vladimir Sarkisyan

Reputation: 41

Mysql database change event

I need to call bash script when mysql database schema has changed. As example queries:

ALTER TABLE, CREATE TABLE, DROP TABLE

it possible?

Upvotes: 0

Views: 470

Answers (1)

Rahul
Rahul

Reputation: 77926

Don't think that's possible any way. You could have probably use a DDL Trigger but MySQL doesn't support one. See worklog https://dev.mysql.com/worklog/task/?id=2418.

Though you can write a stored procedure to perform the business logic and call that procedure but capturing the DDL event isn't possible AFAIK. You should also check on Event Scheduler in MySQL

Upvotes: 1

Related Questions