phpbu icon indicating copy to clipboard operation
phpbu copied to clipboard

Trigger wasn't backup

Open hafiyzaid opened this issue 4 years ago • 1 comments

I was using mysqldump to backup the database. However, during the recovery, the trigger is not in the database. Is there any solution?

hafiyzaid avatar Jan 21 '21 17:01 hafiyzaid

Triggers should be included in the default dump.

--triggers

Include triggers for each dumped table in the output. This option is enabled by default; disable it with --skip-triggers.

But to make is customizable I have to add this options

  • --triggers
  • --skip-triggers
  • --events
  • --routines

sebastianfeldmann avatar Apr 02 '21 12:04 sebastianfeldmann