Mysql database change event

Question

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

ALTER TABLE, CREATE TABLE, DROP TABLE

it possible?

How soon do you need to know that a change has occurred? You might have to switch to a DBMS that supports DDL triggers if the answer is "instantly" — Caius Jard
– Caius Jard, Commented Jul 4, 2017 at 16:44

Rahul · Accepted Answer · 2017-07-04 16:46:37Z

1

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

answered Jul 4, 2017 at 16:46

Rahul

78.1k14 gold badges80 silver badges132 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Mysql database change event

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related