Home / server / Questions / 327079
Accepted
Mathias Lykkegaard Lorenzen
Asked: 2011-11-03 07:30:54 +0800 CST

Exporting MySQL without trigger data?

  • 772

I'm using the MySQL Workbench tool to export a database. However, the database data includes trigger data as well. How can I ignore the triggers and not include them in the generated SQL dump file?

mysql

1 Answers

  1. Best Answer

    I have taken a look at Advanced Export Options tab, it seems that there is no such option related to triggers. So, maybe you must use mysqldump with --skip-triggers option instead.

    • 19