Mysql Disable trigger during database recovery

Question

I need to recover a database with a data-only DB dump (made only of "insert"). I don't want to run triggers during this recovery, how can I do?

dbinott · Accepted Answer · 2017-06-15 20:05:32Z

3

If you have the option of recreating the dump, use the --skip-triggers option when running it. You will have to recreate the triggers afterwards, but it's a lot less painful.

MySQL Trigger Docs

answered Jun 15, 2017 at 20:05

dbinott

9221 gold badge12 silver badges37 bronze badges

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

Comments

wchiquito · Accepted Answer · 2013-11-08 15:33:45Z

2

MySQL currently does not have this feature. Here are some links that may be of interest and give some ideas.

Also, if you have the ability, you can make:

Backup triggers only
Remove all triggers
Restore database
Create triggers again

It's more work, but a workaround to lack of feature.

answered Nov 8, 2013 at 15:33

wchiquito

16.6k2 gold badges37 silver badges46 bronze badges

2 Comments

Tobia Over a year ago

How to backup triggers? May I use mysqldump?

wchiquito Over a year ago

@Tobia: Yes, mysqldump is an option.

Collectives™ on Stack Overflow

Mysql Disable trigger during database recovery

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related