Description:
When using mysqldump to export a trigger, you may encounter a problem and paste it to avoid mistakes.
When you perform the following operations:CopyCodeThe Code is as follows: [root @ YTT ~] #/Usr/local/MySQL/bin/mysqldump-S/tmp/mysql1.sock test> test. SQL
The exported result contains the trigger.Copy codeThe Code is as follows: [root @ YTT ~] #/Usr/local/MySQL/bin/mysqldump-S/tmp/mysql1.sock-rdtn test> test_sp. SQL
The exported result still contains the 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:
If the tiggers value is true by default without any parameters, we can modify the value to false and add the switch -- triggers = false to mysqldump.