The description is as follows:
Use mysqldump to export Trigger when encountered a problem, posted out, lest everyone make mistakes.
When you perform the following actions:
Copy Code code as follows:
[Root@ytt ~]#/usr/local/mysql/bin/mysqldump-s/tmp/mysql1.sock Test > Test.sql
The results of the export contain Trigger.
Copy Code code as follows:
[Root@ytt ~]#/usr/local/mysql/bin/mysqldump-s/TMP/MYSQL1.SOCK-RDTN Test > Test_sp.sql
The results of the export still contain Trigger.
An error occurred while importing:
[Root@ytt ~]#/usr/local/mysql/bin/mysql-s/tmp/mysql1.sock--database Test < Test.sql
[Root@ytt ~]#/usr/local/mysql/bin/mysql-s/tmp/mysql1.sock--database Test < Sp.sql
ERROR 1235 (42000) at line 26:this version of MySQL doesn ' t yet support ' multiple triggers with the same action time and Event for one table '
Solution:
Default without any parameters when the Tiggers value is true, then we modify his value is false, to mysqldump plus switch:--triggers=false can.